How to create List Of Values (LOV) using Common Lookup in BIP ESS Job in Oracle Fusion?

on

 

For this post we will be creating a new Common Lookup Type and then attaching that to a parameter of BIP ESS Job which we had already defined.

 

  • Go to Manage Common Lookup screen and create a new lookup with below lookup type and values:


  • Now create a new List of Values source with the below information

List of Values Source Definition Name will be:

oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO
  • Now edit the parameter of the ess job and select the Page Element as List of Values, List of Values Source as INV_SRC1 (the name which we had given to LOV), Attribute as LookupCode and Selected Attribute as Meaning and then click on Save and Close

 

  •  Once done click on Manage Dependencies icon after selecting the parameter row. If you're not able to click it, first save the job definition and then try again.


  • You will see the below screen
 
 
 
 
  • Select ByLookupType as View Criteria and enter the name of lookup type in Default Value text box (single qouted) as 'DEMO_LOOKUP1' and click OK button
 

  • Now when you try to submit the ESS job you will see that now the parameter type has been changed to LOV with the values in lookup type we created

 

Comments

Post a Comment