Oracle Fusion Data Intelligence

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

Business users couldn't able to see any data on general ledger OOTB workbooks

Received Response
16
Views
3
Comments
GovardhanGuru-Oracle
GovardhanGuru-Oracle Rank 3 - Community Apprentice

Team,

The security setup has been completed for users with access to both AP and GL modules.
While AP users are able to access data and content without issues, the user with GL access is experiencing a problem: they can open the OOTB GL reports, but no data is rendering.

I have double-checked and confirmed that all the necessary DUTY and DATA roles related to GL have been assigned.

Has anyone faced similar challenges? Any insights or suggestions would be greatly appreciated.

Thanks

Guru

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @GovardhanGuru-Oracle,

    You probably know this but the documentation for managing users, groups and roles is here: https://docs.oracle.com/en/cloud/saas/analytics/25r1/fawag/manage-users.html#GUID-D93FA090-46C4-434D-9B69-F21E741A4DBA

    Your FDI IDCS users should be sync'd with your FA users. If possible, test with the out-of-the-box roles before moving on to Custom Security.

    Regards,

    John

  • PRATHEEK
    PRATHEEK Rank 5 - Community Champion

    Hello @GovardhanGuru-Oracle , I have experienced the same issue too .

    As suggested by @JohnW-Oracle FDI Sync Process pulls user and role mappings from the Fusion ERP Identity Domain.

    Here's a high-level overview of how these roles are typically assigned and how they relate to FDI:

    Role Type

    Purpose

    Example

    Relevance to FDI

    Duty Role

    Provides access to specific functions or data sets in a module (e.g., GL Inquiry, GL Journals).

    General Ledger Inquiry Duty

    Used to grant permissions to access subject areas like Journals, Balances in FDI.

    Data Role

    Combines a Job Role (like Financial Analyst) with a Data Security context (e.g., Business Unit, Ledger).

    Financial Analyst – Vision Operations

    Controls which ledger, BU, or legal entity data a user can see in FDI.

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion

    If data is not rendering after you have done everthing you can, check with you DBA to see if there are any DB level GRANTS that need to be executed. Sometimes, the DB layer has additional levels of security.