How to Change The Generic Logo to Your Company's Logo in Bill Presentment Architecture

Bill Presentment Architecture (BPA) allows you to retrieve billing data from multiple data sources for presenting a bill i.e. the bill presentment is no longer limited to information pertaining to AR. It provides template-based configuration of online and printed bills and gives us the ability to select the content of the bill, configure the layout design, display drilldown details and much more.

BPA provides default templates that you are not allowed to modify. 

If you need to make modifications to a default template then you are required to create your own template by duplicating a default template. 

Then on the duplicate template, you can put your customizations to support your requirements.

Now the question is if  the only change you want to make on the default template is replace the logo with your company's logo, then how to achieve it without really creating a entirely separate custom template ?

Well, following workaround comes handy in such cases:

- Create an image of your company's logo and save it to ag_genericlogo.gif

- Copy your company logo to the OA_MEDIA directory

- Run "Generate Stylesheet for BPA Templates" concurrent program for all templates. 

- Your company logo will now show up for all default templates.

The middle tier needs to be bounced after replacing the images

Read More

How to grant execution privileges to ESS custom jobs in Fusion Applications

Create an ESS job using task 'Manage Custom Enterprise Scheduler Jobs for Payables and Related Applications' 

Display Name: 'Rel12 Custom ESS Job – Testing'

Name: XXRel12CustomESS

Path: Rel12

The path Rel12 is added to the default store location of custom jobs: /oracle/apps/ess/custom/. Therefore the MDS path where this job will be saved is: /oracle/apps/ess/custom/Rel12

Run the ESS job 'Import User and Role Application Security Data'

Verify that the privilege 'Rel12 Custom ESS Job – Testing' have been created using the Security Console

Using same Security Console create a custom job role and add the privilege 'Rel12 Custom ESS Job – Testing' as function security policy

Assign the created job role to an user

Run again the ESS job 'Import User and Role Application Security Data'

Login as the user who has the given privilege and in Scheduled Processes schedule the new job created

Read More

How To Create List of Values (LOV) for ESS Job Parameters in Oracle Fusion

Once you have created a custom ESS job in Oracle Fusion, naturally there'll be need to have custom parameters and some of them may need to have LOVs associated with them. Unlike in EBS, we cannot create table type LOVs in Fusion. So let's see how we can achieve this here.

- Navigate to Setup and Maintenance

- Navigate to Manage Common Lookups

- Create custom Lookup and enter corresponding Lookup Codes

-  Navigate to Manage ESS Job Definitions

- Navigate to Manage List of Values Sources

- Associate List of Value Source Definition with custom Lookup -

List of Values Source Definition Name - oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO

- Navigate to ESS Job Registration and Create Parameter

- Add parameters

- Create Dependencies and provide the Lookup Type in Default Value

Read More

How to create a new ESS Job in Oracle Fusion

Let's see how to create a new ESS Job for any of our reports in Oracle Fusion. Once created, the report can be run like a concurrent request by scheduling an ESS process.

Below are the steps to create a new ESS job - 

- Navigate to the Setup and Maintenance

 

- Search and open 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications'

 

- Click on + icon to create a new ESS Job for the desired report

- Enter all necessary fields as shown in the example below -

Report Id - This should match the actual path of your BIP report .xdo file (e.g. BIP/FAMassAdditionsReport.xdo)

- Save and Close

- The ESS Job for our report has been registered

- Navigate to Scheduled Processes

- Schedule New Process

- Enter the newly created job - XXTest ESS Job

- Submit

- We can see the job has been successfully completed -

Read More

Oracle Enterprise Scheduler Service (ESS) Jobs and Tables in Oracle Fusion

In Oracle EBS, we have Standard Request Submission (SRS) that takes care of all our concurrent requests. 

In Oracle Fusion/ERP Cloud, Enterprise Scheduler Service (aka ESS) does the job of running/scheduling all the processes.

This can be accessed by navigating to hamburger menu on left top corner, then go to Tools -> Scheduled Processes

We can search for specific processes that have been already run or Schedule/Run a new process -

Now, let's discuss about the ESS tables. By using these tables, we can see the details of history ESS jobs which is very similar to FND_CONCURRENT_REQUESTS table in Oracle EBS.

Below are the tables we need to get ESS job history details -

FUSION.ESS_REQUEST_HISTORY

FUSION.ESS_REQUEST_PROPERTY

Query -

  SELECT r.requestid,
         USERNAME,
         PROCESSSTART,
         PROCESSEND,
         EXECUTABLE_STATUS,
         V.NAME,
         V.VALUE,
         DEFINITION,
         APPLICATION
    FROM fusion.ess_request_history r, fusion.ess_request_property v
   WHERE definition LIKE '%Pay%' AND r.requestid = v.requestid
   ORDER BY r.requestid, v.name

Output -

Read More