Trying to create a new custom role to allow users to see a Supplier Master Report in OTBI

User_44NR6

Users are getting the following error when they try to run the Supplier master report. We don't want to give certain users the PO Supplier role (which currently allows users to see the report). So we created new role and assigned it the RP Inquiry Role, along with the Supplier Master Transaction Duty Analysis, but they are receiving the error below and are not able to view the report.

Riyaz Ali-Oracle

Hi User_44NR6,

The ACIOA5LN error in OTBI typically indicates an assertion failure related to dashboard prompts or filters. It often appears when:

->A dashboard prompt is misconfigured or corrupted.
->There’s a mismatch between code values and display values in a prompt (e.g., a value expected by the report is missing or renamed).

Try the below:

->Rebuild the dashboard prompt from scratch .
->Check the prompt’s column and ensure it still exists in the subject area.
->Remove and re-add filters in the analysis to refresh metadata.
->If using saved filters, try recreating them manually.

Check the below:

OTBI: Error Code OAMP2OPY:ACIOA5LN - Assertion Failure (Doc ID 2691875.1)

Report dashboard prompt showing error - ACIOA5LN — Cloud Customer Connect

Thanks,
Riyaz Ali

User_44NR6

Thank you Riyaz, however this is an existing out of the box report that runs fine for users that have the PO Supplier role. We are trying to get a new role to work with running this report. This appears to be an access issue with the new custom role we created but can't seem to figure out what rights the role needs to access the report. However, this is the error the users are getting.

Riyaz Ali-Oracle

The issue is almost certainly tied to missing duty roles or data security policies in your custom role.

The PO Supplier role likely includes duty roles such as:

Supplier Master Data Duty
View Supplier Profile Duty
View Supplier Site Duty
Supplier Transaction Analysis Duty

Use the “User and Role Access Audit Report”

Go to Tools → Security Console
Run the User and Role Access Audit Report for a user who has the PO Supplier role
Compare it with the same report for a user with your custom role

Look for:
Duty roles present in one but not the other
Data security policies (especially for Procurement BUs)

Review the below doc as it might be helpful:

Using Procurement

Create a custom role to Restrict Supplier User Access to a particular Business Unit — Cloud Customer Connect