Oracle Fusion HCM Analytics

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

FAW Data Validation Source value is showing null

Accepted answer
114
Views
9
Comments

HI Team,

I have enabled all the HCM pipeline in FAW but in data validation tab source value is showing null. Please suggest what could be the issue. I have verified the source credentials and it is working fine.

Regards

Ankur

Best Answer

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    Answer ✓

    @Ankur Jain--Oracle Since you are able to see Administration→ Manage session in OTBI so ideally you should have admin privileges. Sometimes it takes a while to show the corresponding OTBI query when a Data Validation run is triggered. Just wait for sometime and then refresh the browser and check the Manage session again on OTBI side again. A side tip, it would help you if you first cleared all the cache ie. server and Close All cursors on the OTBI side and then trigger the data validation runs.

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Ankur Jain--Oracle - Probable cause:

    Insufficient permissions for the user in Fusion OTBI side to access the data being validated.

    Action:

    1. Get the Fusion OTBI report query log while running the FAW Data Validation tool.
    2. In the log, check if there are any additional filters added apart from the ones selected in the Data Validation tool. If so, it is because the user has restricted access to data on Fusion OTBI side.
    3. Work with your Fusion Administrator and make sure the user has sufficient permissions to access the required data in Fusion OTBI side for validation. And then rerun the Data Validation.
  • Ankur Jain--Oracle
    Ankur Jain--Oracle Rank 5 - Community Champion

    Hi @Sumanth V -Oracle ,

    Thanks for your reply. I have checked the OTBI report query and there is no additional filters are there. Here is the query I got it from log:

    SELECT "Facts - Workforce Headcount"."Current Headcount" FROM "HCM - Workforce Core" WHERE "Employment Information"."System Person Type Code" IN ('EMP') AND "Assignment Information"."Primary Flag Code" IN ('Y') AND "Assignment Information"."Assignment Status Type Code" IN ('ACTIVE')

    and it was giving me output in data model when I am running it.

    I have created the FAW validation user based on oracle documentation and added only BI impersonate role with this user.

    https://docs.oracle.com/en-us/iaas/analytics-for-applications/doc/create-custom-bi-abstract-role.html

    infact in TEST instance it is working as expected but not in prod

    Regards

    Ankur

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    Hi Ankur,
    The user with whom the query is executed in Fusion source as part of Impersonation, does that user get the valid data when tried creating an OTBI report based on the logical SQL created. If yes, then the same output should get displayed in data validation page. If no, then you need to check the permissions of the FA user with whose account the query gets triggered in OTBI.

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach

    @Ankur Jain--Oracle You can compare the OTBI Session logs generated in both Test and Prod for this particular metric. In case there is no difference then there is something missing on the permissions of the user on the FA side. Also, if your security structure is same between Test and Prod then compare the User accounts between them.

  • Ankur Jain--Oracle
    Ankur Jain--Oracle Rank 5 - Community Champion

    Hi @Sumanth V -Oracle /@ashish.f.singh-Oracle ,

    I am confused here. I was trying to execute the query in OTBI with my login as I was logged in FAW with my user.

    AS source data is validated by the user which I passed under source credential tab so I tried to check with that user but that user is only have BI Impersonate role so I was not able to create the data model to run the query.

    Should I add more roles to FAWValidationUser(which I passed in data validation > source credentials) .

    W.r.t. Test instance , Unfortunately I am getting some weird issue there and lookup value of mandatory attributes in detailed validation itself is not appearing so I can't check it there but it was working before that I remember.

    Regards

    Ankur

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    edited Jun 13, 2024 12:50PM

    @Ankur Jain--Oracle - It is not necessary to add more roles to the FAWValidationUser. The Impersonate role is designed to inherit the roles of the user running the data validation. To debug further, please check the OTBI Session log created as a result of the data validation run. Look for any data security conditions, such as 1=2. If such conditions are applied, revisit the roles your user has on the source side and consider adding a superior role.

  • Ankur Jain--Oracle
    Ankur Jain--Oracle Rank 5 - Community Champion

    Hi @Sumanth V -Oracle ,

    I was not able to see the logs when I checked manage session against « FA-URL>/Analytics where as I was able to see the logs for FDI - OAX analytics.

    Regarding roles , if we have provisioned the FAW in the same domain where FA application exists then roles and permissions are in sync. I am just thinking how roles could be different in FA application.

    Regards

    Ankur

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Ankur Jain--Oracle - In FAW you are haven Admin privileges, make yourself as an superuser in FA and then try running data validation and compare the results. This should help us confirm if the issue is with roles or not. Thanks!.