Open or Close Periods in R12

Open or Close Periods in R12

Purchasing Periods

1. Navigate to Purchasing SuperUser->Setup->Financials->Accounting->Control Purchasing Periods , then enter the Fiscal year and click Go button.

(If it prompts for selecting Operating Unit,select it and click Go button.)

2. Then open the periods by changing the Period Status and click on Save button.

Payables Period

1. Navigate to Payables Super User or Payable Manager->Accounting->Control Payables Periods , then open the periods by changing the Period Status and click on Save button.

General Ledger Periods

1. Navigate to General Ledger Super User->Setup->Open/Close, then the Ledger and click find.

2. Now open the required periods by clicking “Open Periods” button,select the required period as Target Period and click Open button.

Inventory Periods

1. Navigate to Inventory SuperUser->Accounting Close Cycle->Inventory Accounting Periods and select the Inventory Org from LOV.

2. Select the period to be opened and click on Change Status button.

Query to get DFF and SEGMENT values

SELECT ffv.descriptive_flexfield_name DFFName,
  ffv.application_table_name TableName,
  ffv.title Title,
  ap.application_name Application,
   att.column_seq_num SegmentNumber,
  att.form_left_prompt SegmentName,
  att.application_column_name ,
  fvs.flex_value_set_name ValueSet,
  att.required_flag
FROM apps.fnd_descriptive_flexs_vl ffv,
  apps.fnd_descr_flex_contexts_vl ffc,
  apps.fnd_descr_flex_col_usage_vl att,
  apps.fnd_flex_value_sets fvs,
  apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ap.application_id                =ffv.application_id
AND ffv.descriptive_flexfield_name   = ffc.descriptive_flexfield_name
AND ffv.application_id               = ffc.application_id
AND ffc.descriptive_flex_context_code=att.descriptive_flex_context_code
AND fvs.flex_value_set_id            =att.flex_value_set_id
AND ffv.title LIKE 'Additional Line Attribute Information';
--AND att.form_left_prompt LIKE '%VENDOR%';
ORDER BY att.column_seq_num;

Automatic Search External LOV

In this lesson we are going to see how to Create Automatic Search using External LOV and the uses of external LOV in oaf. The difference between inline LOV and External LOV is inline lov is used only inside the page where as external LOV we can use for other pages inside the project.

So therefore the use or advantage of External LOV is if we want a list of values to be used for other pages in the project then we can create External LOV region and we can use the created region in any pages of the project.

Steps to create External LOV in oaf are follows:

Step1: Create Workspace, project , AM and create one page assign AM to the page give page title and window title.

For example :

workspace name : externlallov

Project Name : ExternallovPRJ

package name : externallov.oracle.apps.po.externallovprj.webui

AM name : ExternallovAM

AM Package name: externallov.oracle.apps.po.externallovprj.server

Step2: Right Click on the project select new as shown in the below picture.

After selecting new option we will see a gallery window in that extract web tier in categories select OA Components  and then select Region  in items list.

After selecting region click on ok button so that a window will get open in that

Name : Give any user defined name

Package: Select the proper package of the project.

Style : select style as List of values.

 

Now one .xml region will be created under webui.

Step3: Create on VO under the lov package for example select the package name as follows:

externallov.oracle.apps.po.externallovprj.lov.server

VO Name is : externalLOVVO

Query in the lov is :-

SELECT FULL_NAME FROM PER_ALL_PEOPLE_F

Step4: Attach VO to the AM.

Step5: Under the region create one item and item style as Message LOV input. In previous lesson we already seen how the Message LOV input item structure look like.

The below image shows how the Application Navigator and page structure of the project looks like:

Step6:  Under the Message LOV input region create on table region using wizard. In the table region select the proper package name and then as we attached our VO to the AM it will display our LOVVO so select that VO and therefore a table region will be created with one item under it.

Step7: Select the Message LOV input item and in the Property Inspector of Message LOV input select External LOV as shown in the below figure:

Click on the icon    so that the following window will get opens

Click on the Browse button and then select the proper package name for example see the below picture:

Click on the search button and then select the fully qualified name in the search results for example see the below picture:

Click on OK button so that JDeveloper asks for confirmation in that click on OK button.

Step8: Run the page and see the output. The following three images shows the output and its work process

Click on the search image   so that it displays list of values as shown below.

Select any value whichever you want to select. Use Quick select or radio button process: