Thursday, August 25, 2016

VALUE SET IN ORACLE APPS

Question: What is value set?
Answer: It is a set of values

Question: Why do we need value sets?
Answer: You do not always want a user to enter junk free text into all the fields. Hence, Oracle Apps uses value set to validate that correct data is being entered in the fields in screen.

Question: Is value set attached to all the fields that require validations?
Answer : A big NO

Question: Then where lies the usage of value sets?
Answer: Broadly speaking, value sets are attached to segments in Flexfields. You can argue that value sets are also attached to parameters of concurrent program(but in reality oracle treats parameters as Descriptive Flexfields)

Question: This is insane, flexfields haven’t been covered in http://getappstraining.blogspot.com as yet?
Answer: Agreed, hence let’s restrict value set explanation to their usage in concurrent program parameters.

Question: Any examples?
Answer: For the namesake, lets add a Parameter to the concurrent program that we defined in “Concurrent Program Training Lesson link”. Lets add a parameter named “cost centre”, the values to this parameter must be restricted to one of the three values, i.e. HR, SEC, IT.

At the time of submission of the concurrent program the user should be able to pick a cost centre from a list. This is where value set gets used.

Lets now define a simple value set as described above.

Step 1. Go to Application Developer, and select menu /Validation/Set
Image


Step 2. Now define a value set of type Independent. We will cover the other most widely used Type “Table” latter.
Image


Step 3. Now, lets add three independent values to the value set for this Cost Centre list. Hence click on menu Values within Validation
Image

Step 4. Here we add the values for IT, HR, SEC to this independent value set.
Image

“CONTROL-S” to save the data

Step 5. Now let us go back to Concurrent Program that we created in earlier training lesson and Click on Parameters
Image


Step 6. Now lets create a parameter, and attach the value set that we created to this parameter. 
Image


Step 7.
Now to test this, lets go to receivables manager and click on Requests.
Image
Click on Request, 

Step 8.
Submit New Request, and then click on OK.
Image


Step 9 
Now, we can see the values defined in the value set here.
Image


To demonstrate different types (Independent, Dependent and Table) of value set let’s first define a concurrent program.
1. Define Executable.
Navigation: Application Developer > Concurrent > Executable
Conc Prog 1
Enter Information as below
Note: You don’t really need to have PLSQL package defined for this demo.
Conc Prog 2
Save it.
Navigation: Application Developer > Concurrent > Program
Conc Prog 3
Enter Information as below
Conc Prog 4
Save it.
Assign this Concurrent program to “Application Developer” responsibility by adding it to Request group
Conc Prog 7
Note: Form more information about defining concurrent program and adding it to request group follow the below tutorials.
Independent Value Set:
Navigation: Application Developer > Application > Validation > Sets
value sets 1
value sets 2
Enter information as below
value sets 3
Save it.
value sets 4
Create Values for the value set we defined above
Navigation: Application Developer > Application > Validation > Values
value sets 5
Enter information as below
value sets 6
Save it.
Attach this value set to Concurrent program parameter
Navigation: Application Developer > Concurrent > Program > Parameters
Conc Prog 4
Enter information as below
Conc Prog 5
Save it.
To test the value set try submitting the concurrent program
Navigation: Application Developer > View > Requests > Submit New Request > Single Request > OK
Conc Prog 9
Conc Prog 10
Enter Concurrent Program Name that we defined at the beginning of this tutorial
Conc Prog 11
Click on LOV button to see the values available for this parameter.
Conc Prog 12
———————————————————————————
Dependent Value Set
To define a Dependent value set we also need one Independent value set.
Example: To List down States in a Country we need to have list of Countries for which states need to be defined.
First Define list of countries in a independent value set
Navigation: Application Developer > Application > Validation > Sets
value sets 8
Enter Values for the above value set
Navigation: Application Developer > Application > Validation > Values
value sets 9
Enter Values in the below screen
value sets 10
Now define another Value set
Navigation: Application Developer > Application > Validation > Sets
value sets 11
Click Edit Information Button to link this Dependent Value set with Independent Value set defined in previous step
value sets 12
Enter Values for each country
Navigation: Application Developer > Application > Validation > Values
Ensure to Select Country name in “Independent Value” field before click Find.
value sets 13
Click Find and enter states for Country India
value sets 14
Save it
Now repeat the above two steps to enter states of country USA
value sets 15
Ensure to select country as USA before clicking Find button
value sets 16
Save it.
Navigate to Concurrent Program Parameters screen and enter Country parameter as shown below
Navigation: Application Developer > Concurrent > Program > Query our Concurrent Program > Parameters
Conc Prog 13
Save it.
Add another parameter to link State Value set as shown below
Conc Prog 14
Save it.
To test “Dependent Value set” navigate to concurrent program submission window
Conc Prog 15
Select country and you can observe that list of values in State parameter will change automatically depending on value select in Country parameter field.
Conc Prog 16
Conc Prog 17
——————————————————————————–
Table Type Value Set
Navigation: Application Developer > Application > Validation > Sets
value sets 18
Select Validation type as “Table” and click Edit Information button
Enter information as below
value sets 19
Click Test button validate the information that is entered
value sets 20
Navigate to Concurrent Program Parameters screen and add fourth parameter
value sets 21
Navigate to Concurrent Program Submission window to check the list of values in Parameter-4
Click LOV button on Order Number field to see list of values available from OE_ORDER_HEADERS_ALL table.
These values change dynamically as data changes in the OE_ORDER_HEADERS_ALL table.
Conc Prog 18

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...