Saturday, 2 May 2020

How to Create ess job in oracle fusion

How to Create ess job in oracle fusion

In this post , We will be discuss about how to Create ess job in oracle fusion. ess job in oracle fusion is same like concurrent program in oracle apps. We need to create the ess job in oracle fusion for BIP reports and scripts, if we want to run these reports in oracle fusion as a schedule process. Schedule process is more similar like concurrent request in oracle apps r12. So if we want to run the BIP reports in oracle fusion application then we need to register the reports as a ESS job in oracle fusion. Oracle has provided the Standard ess jobs in oracle fusion and we can also create the custom ess job in oracle fusion as per our Requirment. Here below , we will share the detail steps to Create ess job in Oracle fusion.

Creating LOV for custom ess job in oracle fusion

We creates parameters in Concurrent Job and then attach value set in these parameters to provide list of value selection to the users during runtime But in ESS jobs in fusion apps, We have parameters in Oracle Fusion and we can also create Parameters in Oracle Fusion ESS jobs but in Fusion , We Don't attach Value set to ESS jobs parameter but We attach List of Value to Parameters. In Oracle Fusion, List of Value and Value set are two different -2 Terms and Objects. But in Oracle Fusion, we cannot Create custom List of Value (Table Type) to ESS jobs parameters. In Fusion Oracle has provided, standard VO (View Object) and on the basis of View Object (VO), we create List of Values and attach List of List of Value to Parameters.

Step by Step to Create ess job in oracle fusion

 
Step1:- Go to the Setup and Maintenance role.
 
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion
 
 
Step2:- Search 'Manage Custom Enterprise Scheduler Jobs for Financial Common Applications' to register Finance reports in fusion.
 
 
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion
 
 
Step 3:- Click on Add Icon as below to Register BIP report as a ESS job in Oracle fusion for Finance application.
 
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion



Step 4:-
Path :- Finances
Job Application Name:- FinancialsEss
Job Type:- BIP Job Type
Report Id:- Financials/Payables/Invoices/XXINVOICE DETAILS.xdo ( Location of Your BIP Report Remove 'Shared'folder in front of the path)
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion


Step6:-  Our Report has been registered now we will run this report.
click on Schedules Process
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion

Step7:- Click on Flat List and Select the ESS job name as below.
 
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion


Step8:-  Submit the report and view the output.
How to Create ess job in oracle fusion
How to Create ess job in oracle fusion

How to Create ess job in oracle fusion

2 comments:

penujuri photography and poetry said...
This comment has been removed by the author.
penujuri photography and poetry said...

I don't see "+" symbol to add job definition. What should I do..?

Post a Comment

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

Name

Email *

Message *