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

Question

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 create 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 · Answer

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 to eliminate hidden corruption.

->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:

Thanks,

Riyaz Ali

User_44NR6 · Answer

Thank you.

GayathriAnand-Oracle · Answer

Hi

You have posted this question in OAC/OAS Community but your issue seems specific to OTBI. Kindly post your query in OTBI forum:

https://community.oracle.com/products/oracleanalytics/categories/otbi

Thanks

Gayathri