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 Learn Oracle Fusion , Please Follow the Oracle Fusion Tutorial 

10 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.

Unknown said...

Hi Deepika,

Did you get a solution for above issue, if so please share.

Regards
Rajesh

Varun said...

We are also getting same error.

unable to retrieve content. additional information for remote region error #2

Rohit said...

Hi Varun ,

This might be an Issue of Wrong Lookup Value mentioned in the Step8 and are you creating under Common Lookup.

Anonymous said...

Wonderful blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion HCM Online Training

shaik shah said...

Good blog, Thanks for Sharing informative article. It would be helpful to all.
Oracle Fusion HCM Online Training

shaik shah said...

Good blog, Thanks for Sharing informative article. It would be helpful to all.
Oracle Fusion HCM Online Training

Goutham Raj said...

Good Article, Alots of information provided, Thanks for sharing this information.
Oracle Fusion Technical Online Training

Rainbow Training Institute said...

Really very helpful article , Thank you for sharing

Oracle Fusion HCM Online Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *