FAW Data Validation Source value is showing null

Ankur Jain--Oracle

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

Ashish-Oracle

@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.

Sumanth V -Oracle

@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

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

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

@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

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

@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

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

@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!.