HCM Extract failing with error "user: fusion_apps_hcm_ess_appid, permission: 2240"

Question

HCM Extract failing with error, please let me know how to resolve this issue:

================ BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition for reportAbsolutePath [/Custom/Human Capital Management/Core HR/Interfaces/Paas HCM Extension/XXXX.xdo] Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation: /Custom/Human Capital Management/Core HR/Interfaces/Paas HCM Extension/XXXX.xdm, user: fusion_apps_hcm_ess_appid, permission: 2240 ============

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/23954/hcm-extract-failing-with-error-user-fusion-apps-hcm-ess-appid-permission-2240

Hi Arun,

Follow the steps mentioned in below MOS note to assign permissions and clear cache:

All HCM Extracts Were Erroring Out. ESS Process Shows Error java.lang.SecurityException: Security violation user: fusion_apps_hcm_ess_appid, permission: 2240 (Doc ID 2870939.1)

Once done, please rerun the extract.

Thanks.

Hassan El Bouihi-Oracle · Answer

Hello Arun,

Navigate to the BI Catalog with a user that has the BI Admin role.

Click the More ⇒ Permission on the report in question.

Ensure that the fusion_apps_hcm_ess_appid user has the proper permissions.

Repeat the same steps for the data model.

Thank you

Hassan