Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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
18
Views
3
Comments
User_44NR6
User_44NR6 Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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.

image.png

Answers

  • 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 .
    ->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
    User_44NR6 Rank 2 - Community Beginner

    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
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    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