In this article we will look into details of how to access the output of HCM Extract when the Extract is run by other users.
Normally when we run the extract, the output results will be visible to ONLY the user who has ran the extract and not to any other user. If there is an ask for sharing the output with others, then we use FTP/UCM option and they can get the output from FTP/UCM directly.
There is no seeded role which can be assigned to users to get this access. To avoid this scenario, most of the implementation teams use a single user account for scheduling extracts and the troubleshooting is also done with the same user id if an issue arises.
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.
- Creating Custom Job Role
- Adding Custom Job Role to Users
- Adding Custom Job Role as Owner to HCM Extracts
- Run the “Import User and Role Application Security Data” process
- Run Extract by any user other than the one to whom custom role is added
- Check the output from the User which has the Custom Role
Table of Contents
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.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM
Nice post Thanks Sricharan.
A small addon to your post regarding Navigation.
From 20B their is a small change in the navigation to add/Change the owner of the extarct.we will not find out the edit button on the top right corner as shown in the above screenshot.
Refine Ectract →Input the flow instance name & Search→ Select the flow→Click on Actions→Click on edit→Go to task →on the task page click on next →Add the custom role created as owner.
Thanks Phani. I will update the main post with this information.