How to find Oracle Fusion Instance Name through SQL

Wondering how to find the name of your Fusion instance ? Here's the query that will retrieve this information -

SELECT

    SUBSTR(

        EXTERNAL_VIRTUAL_HOST,

        1,

        INSTR(EXTERNAL_VIRTUAL_HOST, '.') -1

    ),

    DEPLOYED_DOMAIN_NAME

FROM

    FUSION.ASK_DEPLOYED_DOMAINS

Read More

What Are The Roles Required To Create Data Model in Oracle Fusion

If you don't see option to create a new Data model or update an existing one, there's a chance that your user account is missing the required roles.
Let's see what roles are required to create Data model in Oracle Fusion BI Environment.


To get Data model access, create a new custom role and map the below roles to the custom role.

  => BI Consumer Role

  => BI Publisher Data Model Developer

Assign this custom role to your user and you should get the access to create a new Data model or edit an existing one.

Read More

How To Store BI Publisher Report output on UCM Server in Oracle Fusion

Below are the steps to check the Content Server / UCM  configuration from BI -

1. Login to Fusion Applications > Navigator > Reports and Analytics > Click on the Book Icon.

2. Click on Administration > Manage BI Publisher > Delivery > Content Server

3. It will show the predefined Server with Server Name as FA_UCM_PROVISIONED.
Use the server FA_UCM_PROVISIONED to deliver the file to UCM.

4. Test connection

5. Schedule the report to be delivered to Content Server

6. Login to UCM to find the output file.
URL - https://<Host>.<Domain>/cs

Read More

How to Fix Merged Columns in BI Publisher Excel Output in Oracle Fusion

So, you have created RTF template which has output in excel form. 

But in the output, some of the columns are shown merged. Please see below column G and H are merged under SDO header -

But the users don't want merged columns and you don't see this in RTF template at design time .. So how to fix this ?

Here are the steps -

- Navigate to BI Publisher Catalog 

- Go to Report Properties - > Formatting

- Look for the property 'Keep Values in same column'

- Set the value to True

- Save

- Run the report and you will see the columns are no more merged.

Read More

How to create ESS Job Set in Oracle Fusion

We've seen the definition and structure of a custom ESS Job in Oracle Fusion here

Now let's see how to create a job set comprising of multiple ESS jobs.

ESS Job Set is useful when there's a need to run multiple ESS jobs for any activity (in sequence or parallel) in Oracle Cloud. Basically, the traditional Concurrent Request Set from EBS has been replaced with an ESS Job Set in Oracle ERP Cloud. 

Let's see how to define an ESS Job Set.

Below example will create a job set which will run two HCM jobs shown below. Read Only initial parameter values come from the job set but  non-read only parameters come from the job definition.

1. Identify the jobs to be included in ESS Job Set -
    a. Generate Cloud Usage Metrics (seeded job)
    b. XX HCM Job (custom job)

2. Run these jobs individually. This will ensure that the jobs are running without issues and users will be able to collect  runtime information about the ESS jobs.

3. Create Job Set

- Navigate to the product specific task. In this example "Manage Custom Enterprise Scheduler Jobs for HCM Core Processes"

- Click on Manage Job Sets tab.

- Enter the new job set details.

- Press on the Add Job Set Step button to add the first job details.

- Give a name for Step ID.

- Search for first Job. For example search by Name CloudMetricsNumberOfNamedUsers.

- Click on the Add Job Set Step button to add the second job details

- It should look like this -

- Under the System Properties add the SYS_effectiveApplication as the value of the application identified in the second SQL from Step 3. In this case EarHcmEss

- Save the Job Set

Read More