Drill Down Custom Report Errors With "You Do Not Have Access To This Report"

(Doc ID 726083.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle E-Business Intelligence - Version 12.0.4 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On 12.0.4 in Production:
After creating two custom Reports using DBI Designer, attached it to the Responsibility Chief HR Officer.
One is the Master and the second is the Details.
When trying to access the Details using drill from the master the following error occurs:

ERROR

SAMPLE_DRILL_REPORT&BIS_COLUMN_<xx>
ERROR
ERROR - You do not have access to this report


The issue can be reproduced at will with the following steps:
1. Create two custom Report, master and details using DBI Designer.
2. Attached the two Report to the Chief HR Officer Responsibility.
3. Access the Master Report.
4. Click on a link to drill to the Details Report, error appear.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms