Hcm extracts error

HCM Extracts Error

1. HCM Extracts Error "A system error occurred during processing. Contact your help desk"
It's been long time I have not posted anything as I was busy with other priorities. Will ensure that I post
at least once a week with the learnings in that week.

Many a times we will get errors in HCM Extract and one of the common errors is "A system error
occurred during processing. Contact your help desk" and it does not show up any other clue on why the
extract is failing.

If we dig into details and add the GMFZT logging at system level and run the extract again we will get the
log file where we can check the issue details. Click here for details on how to setup logging for hcm
extract

Excerpt from log file:
"Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException:
java.lang.SecurityException: Security violation: , user: fusion_apps_hcm_ess_appid, permission: 192"

What this message means is that the user fusion_apps_hcm_ess_appid should have access to the BI
Report in the BI Catalog. If this user doesn't have access to the BI Report, the extract will fail.

Resolution:
Navigate to the BI Catalog path of BI Report
Click on More > Permissions
Add permissions for the username FUSION_APPS_HCM_ESS_APPID
Click OK

Along with the access for the above username, we also need to provide access to the below roles:
Manage HCM Extract Definition Report
Run HCM Extracts Report

3. Now run the extract again. The extract will run to success.