How to Create Dependent LOV in Oracle Fusion Report
Hi Friends in this post I will show you how we can create Dependent LOV in Oracle Fusion Reporting Tools Before creating Dependent Parameters you can also visit below Posts to understand more about Oracle Fusion BIP reports and steps to create in oracle fusion.
This is the parameters of Supplier in BIP reports as below.
P_VENDOR_NAME is the parameters name of Vendor.
Parameter Type Should be Menu if you are attaching LOV to Parameter.
This is the LOV of P_VENDOR_NAME parameter.
SQL Query :- select vendor_name from poz_suppliers_v
Then go back to Parameter P_VENDOR_NAME and attach this LOV to this parameter as below.
We are Creating P_VENDOR_SITE
We are Creating Vendor Site Lov with below Query.
SELECT pvs.vendor_site_code
FROM poz_supplier_sites_all_m pvs, hz_locations hzl, hz_party_sites hps ,POZ_SUPPLIERS PSWHERE hzl.location_id = pvs.location_id
AND hps.party_site_id = pvs.party_site_id
AND pvs.vendor_id=PS.VENDOR_ID
AND PS.VENDOR_NAME=: P_VENDOR_NAME
Now we are going back to P_VENDOR_NAME paramter and do below change as below.
Now i am going to attach Site LOV to P_VENDOR_SITE parameter as below
How to Create Dependent LOV in Oracle Fusion Report
11 comments:
Hi..Thanks for preparing and posting such a Useful article!!
I have a doubt.. In R12, for value sets, we have meaning,description and code.. but here in fusion, in lov--> how to map the code, meaning and description columns if needed...
this is list of value set which we associate with concurrent program parameter. I think you are going to be campier with Lookup of EBS.
Hello Guru, Can you please walk though us about the dependent value set in fusion.?
Hi Sam ,
I will share the new post for your current requirement.
Hi Sam ,
Please refer this below post for step by step process to create dependent value set in fusion.
https://rpforacle.blogspot.com/2019/01/how-to-create-dependent-value-set-in-in-the-oracle-fusion-application.html
Wonderful blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion HCM Online Training
Good blog, Thanks for Sharing informative article. It would be helpful to all.
Oracle Fusion HCM Online Training
good blog
Oracle Fusion HCM Training
Beautiful article ever. Such a good information is given.
Oracle Fusion HCM Training
Good Blog, well descrided, Thanks for sharing this information.
Oracle Fusion HCM Technical Online Training
Really very helpful article , Thank you for sharing
Oracle Fusion HCM Online Training
Post a Comment