Sunday 9 August 2020

Dependent value set in Oracle apps $flex$

Dependent value set in Oracle apps $flex$

Hi friends, we are going to discuss about the dependent value set in Oracle apps $flex$. We will share the detail steps to create the Dependent value set in Oracle apps $flex$.In oracle apps , we have the feature called $flex$ using this we can create the dependent value set in oracle apps. Dependent value set means , value set list of value will be depend based on the value selected by user in another value set. In simple language. second value set values will be depend upon the value selected in the first value set. We do use the dependent value set in different operations in oracle apps. We do use the dependent value set in Descriptive flex fields. We do use the dependent value set in concurrent programs. In concurrent programs dependent value set , helps to create the dependent parameter in oracle apps. We will share the working example to implement the dependent value set in oracle apps. Please find below the detail about Dependent Value set in Oracle apps.

Example of Dependent value set in Oracle apps using $flex$

In this Post , We are sharing one example in which we have the concurrent program. In concurrent program , we have two parameters. First Parameter is Supplier and second parameter is supplier site.

We want that the Second parameter Supplier site should depend upon the first parameter supplier.It means , What ever the supplier we will select in the supplier first parameter based on that only those supplier sites will be show in the second supplier site parameter.


Steps to implement the Dependent value set in Oracle apps $flex$

Step 1:- Here below is the First Supplier Parameter. We have used the value set "XX_VENDORS".

Dependent value set in Oracle apps $flex$
Dependent value set in Oracle apps $flex$

Step 2:- Here below is the Value set(XX_VENDORS) we have created for first parameter "Supplier".
Dependent value set in Oracle apps $flex$
Dependent value set in Oracle apps $flex$
Dependent value set in Oracle apps $flex$Dependent value set in Oracle apps $flex$

Step 3:-Here below is the Supplier Site Parameter for the report.But first we need to create the Supplier site valueset.

Dependent value set in Oracle apps $flex$
Dependent value set in Oracle apps $flex$
Step 4:- 
Here below is the Value set(XX SUPPLIER SITE) we have created for second parameter "Supplier Site".
Table Name : AP_SUPPLIERS A1,AP_SUPPLIER_SITES_ALL A2
Where Condition : WHERE A1.VENDOR_ID=A2.VENDOR_ID
AND A1.VENDOR_ID=:$FLEX$.XX_VENDORS

Column : A2.VENDOR_SITE_CODE

Step 5:- 
Dependent value set in Oracle apps $flex$Dependent value set in Oracle apps $flex$


Dependent value set in Oracle apps $flex$

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *