Monday 15 January 2018

How to Create Dependent LOV in Oracle Fusion Report


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 parameter that will be dependent on P_VENDOR_NAME parameter. This P_VENDOR_SITE parameter will show Vendor Sites based on Vendor Selection.
 



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 PS
WHERE 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:

Unknown said...

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...

sam said...

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.

sam said...

Hello Guru, Can you please walk though us about the dependent value set in fusion.?

Rohit said...

Hi Sam ,

I will share the new post for your current requirement.

Rohit said...

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

Anonymous said...

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

shaik shah said...

Good blog, Thanks for Sharing informative article. It would be helpful to all.
Oracle Fusion HCM Online Training

raveena said...

good blog
Oracle Fusion HCM Training

raveena said...

Beautiful article ever. Such a good information is given.

Oracle Fusion HCM Training

Goutham Raj said...

Good Blog, well descrided, Thanks for sharing this information.
Oracle Fusion HCM Technical Online Training

Rainbow Training Institute said...

Really very helpful article , Thank you for sharing

Oracle Fusion HCM Online Training

Post a Comment

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

Name

Email *

Message *