ERP - Lookups in Fusion - Use in ESS Jobs Parameter

Usecase: Here  we will create a lookup and use it as list of values in one paramter of the ESS job.

Highlevel steps:

• Create a lookup XXSOURCE_LOOKUP with lookup codes (search Manage Common Lookup% under setup and maintenance)
• Create a List of values Source COMMON LOOKUP under Manage lisy of values sources (search Manage%Enterprise%Job under setup and maintenance)
• Application name: Application Toolkit
• User List of Values Source Name: Common Lookup
• List of Values Source Def name: oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO
• Edit the previously created ESS job XXDEMO_JOB and edit paramter Invoice Source as Choice list and select source name as "Common Lookup" with attribute lookup codes.
• Select Invoice Source paramter >> Manage dependencies >>select ByLookupType >> default value : 'XXSOURCE_LOOKUP'
• Test this ess job from scheduled processes.

Detailed steps with screenshots:

Create first ESS job on BI Report | ERP Cloud

Usecase: We will create our first ESS job on BIP report and shedule the ESS job from scheduled processes and track the details from ess_request_history and ess_request_property tables.

Steps with detailed screenshots:

ERP - Secure BI Report

We can provide permissions to specific user to use the report to make it more secure.

Report >> More >> permissions >> add user >> no access to BI admin, BI author and cosumer if needed

Detailed steps with screenshots:

ERP - BI Report Export | Send to UCM | Send as Email Attachment

Usecase: Here, we will see the following -

• How to schdule BI report and send using email attachment and also send to UCM.
• How to check schedule report history
• How to check BI ess job run from scheduled process
• How to see export file to UCM
• See other delivery options in administration settings.

Detailed steps with Screenshots: