How to view the output of HCM Extract run by other users?

However there could be multiple scenarios where we would need access to the results of other extracts which have been run by end users. We will not have their credentials and we will have to look at the output to debug the issue.

One way to solve this issue is to get the process IDs from the Payroll checklist area for this payroll flow and navigate to BI Report and check the BI Run history for that child process id. However it is a time consuming task and there will be many process ids which gets generated when an extract runs and we will have to check them to get to the output.

We will look at the second and a better alternative now.

We need to create a custom role and add it to users who need the access of Others HCM Extract results and also add it to all the extracts for which the user needs access to and then run the extracts.

1. Creating Custom Job Role
2. Adding Custom Job Role to Users
3. Adding Custom Job Role as Owner to HCM Extracts
4. Run the “Import User and Role Application Security Data” process
5. Run Extract by any user other than the one to whom custom role is added
6. Check the output from the User which has the Custom Role

Creating Custom Job Role:

Navigate to Tools > Security Console – Click on Create New Role

Provide the Role Name and Role Code as “XXX_HCM_Extracts_View_Output_Role” (You can create it as per your client naming convention) and select Role Category as “HCM – Job Roles” and provide an optional description and click Next.

After you click on Next, it will navigate to Function Security Policies tab

In this tab, click on “Add Function Security Policy” and search for “View Output Document” and click “Add privilege to Role” and click Next

We will land up on the Data Security policies screen. Click on “Add Data Security Policy” . Provide some name for Policy and click on Search button for “Database Resource” . Search for “Payroll Checklist for Table PAY_CHECKLISTS” and select it and click OK.

Now set the Start Date to “1/1/1951” or any old date and select Data Set as “All Values” and Actions as “View Payroll Flow” and Click OK.

Now Click Next and Next again to until you reach the Summary tab and finally click Save and Close button.

Now we are done with creating a Custom Role “XXX_HCM_Extracts_View_Output_Role“

Adding Custom Job Role to Users:

From Security Console > Click on Users Tab > Search for “TEST.USER” and open the User > Click on Edit > Click on Add Role and search for the “XXX_HCM_Extracts_View_Output_Role” and click on “Add Role Membership”

Finally click Save and Close to save the changes to the User.

Adding Custom Job Role as Owner to HCM Extracts:

In order to set the Owner to HCM Extracts, we need to navigate to Data Exchange > Refine Extracts or Payroll > Checklist > Manage Payroll Flow Patterns.

There is an extract called XXX_CUSTOM_LOCATIONS and we will update the owner for this extract.

Click on Edit button and then Click on the Go to Task in the flow task.

It will open up the Basic Information page with the parameters, Click Next to get to the Task owner details.

Now Select the Owner Type as “Group” and Owner as “XXX_HCM_Extracts_View_Output_Role” which was created above and Click Submit

Finally Click Submit again to submit the changes to the Payroll Flow Pattern.

Run the “Import User and Role Application Security Data” process:

We need to run the “Import User and Role Application Security Data” process which copies users, roles, privileges, and data security policies from the LDAP directory, policy store, and Applications Core Grants schema to Oracle Fusion Applications Security tables.

Navigate to Tools > Scheduled Processes

Click Submit on the next screen to initiate the process. Wait till the process is complete.

Run HCM Extract by any user other than to whom custom role has been added:

Click on View process Results and then Actions > View Results

Check the output from the user which has the role added:

Login as TEST.USER

Navigate to Payroll > Checklist and click on search.

Search for TEST_0509 Payroll Process Flow Name and open it and click on View process Results and then Actions > View Results.

We can see that output is visible from TEST.USER as well.

Tip: If you want to view the output of all extracts run by others then take some time and try this approach. If it’s a onetime task, then check the BI Report history method to get the output file.