Dynamic Value set oracle apps
Hi Friends , we are going to discuss about dynamic Value set in oracle apps. Dynamic value set means , the list of values in the value set will be changed based on some condition. Dynamic value set values not always constant , it remains changed based on the condition. Dynamic value set , we also called the dependent value set in oracle apps. In this , based on the value selected in the first value set , the second value set value will be changed so in the dynamic value set , the values keep changing based on the value selected in the first value set. We have the feature called $flex$ in oracle apps which helps to create the dynamic value set in oracle apps. We will share the working example of dynamic value set in oracle apps. Please find below the complete detail about dynamic value set oracle apps.
Dynamic-value-set-Oracle-apps.
Example of Dynamic value set in oracle apps
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 Dynamic Value set oracle apps
Step 1:-
Here below is the First Supplier Parameter. We have used the value set "XX_VENDORS".
 |
| Dynamic Value set oracle apps |
Step 2:- Here below is the Value set(XX_VENDORS) we have created for first parameter "Supplier".
 |
| Dynamic Value set oracle apps |
 |
| Dynamic Value set oracle apps |
Step 3:-Here below is the Supplier Site Parameter for the report.But first we need to create the Supplier site valueset.
 |
| Dynamic Value set oracle apps |
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:-
 Dynamic Value set oracle apps |
0 comments:
Post a Comment