My Oracle Support Banner

Nested exception is: javax.jcr.RepositoryException: access denied for user to path When Running Or Saving FR Report (Doc ID 2242670.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.11.1.0 version, Other Issues

When attempting to Migrate reports from Test to Production, users were not able to see the migrated reports. It was suggested to move the reports from the  /Shared Folders/Custom Servipag/Reportes FSG to the  /Shared Folders/Custom/Reportes and now user are able to see the reports, but just the owner of the reports is able to run them, all other users are not able to, they get  multiple errors:

ERROR
-----------------------
1. Error al ejecutar la consulta: SEP-17 y AccountingPeriod no se encuentran en la misma generacion. (Error executing the query: SEP-17 and AccountPeriod are not in the same generation).
2. Other report shows Error al ejecutar la consulta:  (Error executing the query : ) but no query is shown.
3. Trying to create/save a new or existing report in My folder from FRS shows error: ; nested exception is: javax.jcr.RepositoryException: access denied for user to path /users/xxxxx/Basse_Oracle_EE_RR_por_Dep.

STEPS
-----------------------
Opening a report from FRC, BI or FRS . The issue can be reproduced at will with the following steps:
1. Create reports in one environment
2. Export the reports from source environment using Archive with Keep Privileges.
4. Import the report using the Unarchive on the target environment.
5. On the target environment move the reports to Custom folder.
6. Log in as the user that is not the owner/creator of the report
7. FRC
8. Search for the report, Open it.

Saving or creating a new report in My Folder:
1.Open FRS
2. Open a report and try to save it in My Folder.
3. Create a new report and try to save it in My Folder.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Users are not able to user the FRS reports needed for the day by day operation.

Other Facts:
- Users are getting also errors when trying to save the report in My Folders : Oracle Hyperion Financial Reporting Studio, Fusion Edition: ; nested exception is: javax.jcr.RepositoryException: access denied for user to path /users/xxxxx/Basse_Oracle_EE_RR_por_Dep.
- Same error is got when trying to change from EPM Financial Reporting User POV: nested exception is: javax.jcr.RepositoryException: access denied for user to path /users/xxxxx/_internals/frpfres.xml.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.