How To Create List of Values (LOV) for ESS Job Parameters in Oracle Fusion

Once you have created a custom ESS job in Oracle Fusion, naturally there'll be need to have custom parameters and some of them may need to have LOVs associated with them. Unlike in EBS, we cannot create table type LOVs in Fusion. So let's see how we can achieve this here.

- Navigate to Setup and Maintenance

- Navigate to Manage Common Lookups

- Create custom Lookup and enter corresponding Lookup Codes

-  Navigate to Manage ESS Job Definitions

- Navigate to Manage List of Values Sources

- Associate List of Value Source Definition with custom Lookup -

List of Values Source Definition Name - oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO

- Navigate to ESS Job Registration and Create Parameter

- Add parameters

- Create Dependencies and provide the Lookup Type in Default Value