ERP ESS - ESS job with parameters using value set

Usecase: Here, we will create a value set for invoice source and then link to ess job parameter and then run the ess job to invoke the BI report.

Steps to follow:

1. 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
2. My enterprise >> Setup and Maintenance >> golbal search with Manage value Sets >> Create & Manage Value set : XXSOURCE_VS  , module: Application Toolkit>> add values like ISP, ERS. Same repeat for ISP and ERS.
3. Search with Manage Enterprise Schedule >> Manage List of Values sources >> application name: application Toolkit , LOV source name: ValueSetPVO, LOV Source definition name: oracle.apps.fnd.applcore.flex.vst.model.publicView.ValueSetValuePVO
4. Manage Job Definitions >> provide ESS job details. >>create paramter P_source and assign page element as Choice list. LoV source : ValueSetPVO
5. Link the valusset with the parameter Source. Default value: 'XXSOURCE_VS'. And mapped parameter as P_source for p_invoiceNum
6. Tools >> Scheduled Processes >> schedule new process >> XXDEMO_ESS_JOB1 TAB >>> select values and submit

Detailed screenshots:

Full LOV Source Definition name: