How to View the Output of an ESS Jobs Submitted By Another User In Oracle Fusion: Oracle Fusion Role to View the Output of an ESS Jobs Submitted By Another User

How to View the Output of an ESS Jobs Submitted By Another User In Oracle Fusion: Oracle Fusion Role to View the Output of an ESS Jobs Submitted By Another User

In this post , we will discuss , how we can view the Output of an ESS Jobs Submitted By Another User In Oracle Fusion. Oracle fusion has provided the roles to View the Output of an ESS Jobs Submitted By Another User.Using this fusion role , We can view the output of any schedule ess job submitted in oracle fusion application. To troubleshoot the issues for the ESS Scheduled Processes , we need this role so that we can verify the details about the submitted ess schedule process. Here below is the detail explanation of Oracle Fusion Role to View the Output of an ESS Jobs Submitted By Another User.

Step by step to View the Output of an ESS Jobs Submitted By Another User In Oracle Fusion

Step1:- Login using user who has IT SECURITY MANAGER role assigned.

2. Choose Navigator -> Security Console.
3. choose administration --> manage database resources
a. Search on object ESS_REQUEST_HISTORY
b. Create the database condition and save and submit.
Edit and add the condition needed for the security policy name = ess condition
with a sql predicate such as:

EXISTS
(select 1 from dual)
and DEFINITION in (
'JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob'

)

Step2:- Create a job role

Name test_ess
Code ess
Description testing for ess
Role Category HCM - Job Roles

Step3:-
In Security Console navigate to Data Security Policies tab

 Create a data security policy
a. policy name = ess_request_history
b. Policy Description = ?????
c. Data Resource = ESS_REQUEST_HISTORY
d. Privilege = read; ESS_REQUEST_READ; ESS_REQUEST_OUTPUT_READ
e. data set = select by instance set
f. Condition = choose the condition created in step 3 (under manage database resources) ess condition

We need to go to the Tools ==> Security Console.

• Create an abstract role for example

As below , Under Roles , Click on the Create Role Button as highlighted below.

Step2:- 

• Navigate to the Role Hierarchy tab
• Search for ESS Monitor Role
• Press on Add Role Membership button

Step 4:-Now , We need to add the this role to  user

Step 6:- Run the ESS process: Import User and Role Application Security Data