Sunday, 4 February 2018

How To Create List of Value (LOV) to ESS Job Parameter in Oracle Fusion



How To Create List of Value (LOV) to ESS Job Parameter in Oracle Fusion

Hi Friends, in this post we will create LOV in Oracle Fusion for Concurrent Programs/ESS jobs. We all know that , concurrent program is now changed to ESS jobs in Oracle Fusion and we cannot create Table type LOV in Fusion so there is another way to achieve this requirement that I will share step by step.


Step1:- Go to Setup and Maintenance.

 
Step2:- Go to Manage Common Lookups.
 
 
Step3:- Create Lookup Type and Give Values as Below
 
 
 
Step4:-  Now We will go to Manage Custom ESS Job Roles as per module


 
 
if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.
 
Step5:-
 List of Value Source Definition :- oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO
 
 
 
 
 
Step6:- Now we will go to ESS Job Registration and Create Parameter and assign LOV.
 
 


Step7:-





Step8:- Now We Create Dependencies as below

Here We will give the Name of Lookup type in Default Value as below.



How To Create List of Value (LOV) to ESS Job Parameter in Oracle Fusion


If you want to see Other OAF Related Posts , Please visit Below URL.https://rpforacle.blogspot.in/2013/03/oaf_10.html



If you want to see  Oracle Fusion Related Posts , Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html

If you want to Learn Oracle Workflow Builder, Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html

2 comments:

Syed Farhan Ashraf said...

Nice Work, Man!!

Deepika said...

Hi Rohit,

i tried the way you have created the list of values using lookup and attached the same to parameter. But when scheduling my report it errors out with error statement as 'unable to retrieve content. additional information for remote region error #2'. Please suggest what could be the reason.

Post a Comment