Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
12
Views
3
Comments
User_44NR6
User_44NR6 Rank 2 - Community Beginner

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.

image.png

Answers

  • 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

  • User_44NR6
    User_44NR6 Rank 2 - Community Beginner

    Thank you.

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    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