Custom LOV in Oracle Fusion: How to create ESS Job Parameters value set (LOV) Using SQL Query in Oracle Fusion

How to create ESS Job Parameters value set (LOV) Using SQL Query in Oracle Fusion

Hi Friends , We are going to discuss about ESS job Parameters value set (LOV). We will share , how we can create the SQL Query based Values sets(LOV's) and use in the ESS job Parameters in Oracle Fusion. In Oracle Fusion , We have the option of create the query based LOV and then attach into the ESS job Parameters. Using this method , We can create any LOV or Value sets as per our requirements and uses in the ESS job Parameters. Using SQL Query , we can create the Dynamic lov's for custom ESS jobs. We can create the LOV's for any ESS job parameters using this SQL query method. Here below we will show your the detail steps to create the ESS job Parameters Value sets using SQL query. 

Step by Step to create the ESS Job Parameters value set (LOV's) using SQL Query in Oracle Fusion

Step1:-  We need to go to the Task List 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications'. 

Under that , We need to go to the Manage List of Values Sources as below.

Step2:-  Here we are going to create the Custom LOV for Suppliers in Oracle Fusion and then we will attach this LOV to the ESS job Parameter.

LOV Type : User Defined

LOV should be User Defined , if we want to create the SQL based custom LOV.

Step3:- 

Here below LOV has been Created.

STEP 4:- Now We need to go to the ESS Job Definition. 

Here below i have selected the ESS Job Parameter 'Supplier' in which i would attach the Custom SQL Based LOV. Click on Edit Tool as below.

Step5:- In this step , We are going to attach the Custom SQL based LOV 'XXVendorLOV' to this Parameter as below. 

Now we are ready to run the ESS job in Oracle Fusion with Supplier Custom LOV.

Customer LOV in Oracle Fusion: How to create ESS Job Parameters value set (LOV) Using SQL Query in Oracle Fusion