Oracle Concurrent program parameters $flex$
Hi Friends, we are going to discuss about the Oracle Concurrent program parameters $flex$. We have $flex$ in concurrent program which helps to create the dependent parameters in oracle concurrent program. If we want to create the dependent parameter in concurrent program , then we have the feature called $flex$ using this we can meet our dependent parameters requirement. $flex$ works only when we have the value set attached to concurrent program parameters. $flex$ feature really helps to create the dependent parameters in concurrent program. If we want to limit the values showing in the concurrent program parameters based on the value selected by user in the another parameter then we need to use the $flex$ feature to implement this. $flex$ really helps in controlling the values in the concurrent program parameters based on another parameter value selected. Please find below the complete detail about Oracle Concurrent program parameters $flex$.
What is $flex$
As we said , $flex$ helps we want to create the dependent parameters. Dependent parameters means , the value set value in the parameter will depend on the value entered in the another concurrent program parameter. Suppose , 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.
How to implement the Oracle Concurrent program parameters $flex$
Step 1:- For example , here below is the First Supplier Parameter. We have the value set "XX_VENDORS".
 |
| Oracle Concurrent program parameters $flex$ |
Step 2:- Here below is the Value set(XX_VENDORS) we have created for first parameter "Supplier".
 |
| Oracle Concurrent program parameters $flex$ |
 |
| Oracle Concurrent program parameters $flex$ |
Step 3:-Here below is the Supplier Site Parameter for the report.But first we need to create the Supplier site valueset.
 |
| Oracle Concurrent program parameters $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:-
 |
| Oracle Concurrent program parameters $flex$ |
0 comments:
Post a Comment