Usecase: Here, we will create a lookup for invoice source and then link to ess job parameter and then run the ess job to invoke the BI report.
Steps to follow:
- Tools >> Reports and Anlytics >> browse catalog >> create data model >> create two LOVs for source and invoice number >>create 2 parameters and link to the LOVS >> Create data set >> go to data tab and test >> save as sample data >> create report
- My enterprise >> Setup and Maintenance >> golbal search with Manage Common Lookups >> create lookup : XXSOURCE_LOOKUP , module: Toolkit>> add lookup codes like ISP, ERS.
- Search with Manage Enterprise Schedule >> Manage List of Values sources >> application name: application Toolkit , LOV source name: Common Lookup , LOV Source definition name: oracle.apps.fnd.applcore.lookups.modelpublicView.CommonLookupPVO
- Manage Job Definitions >> provide ESS job details. >>create paramter P_source and assign page element as Choice list. LoV source : Common Lookup
- Link the lookup with the parameter. Default value: 'XXSOURCE_LOOKUP'.
- Tools >> Scheduled Processes >> schedule new process >> XXDEMO_ESS_JOB TAB >>> select values and submit
Detailed screenshots: