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
@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.
@Ankur Jain--Oracle - Probable cause:
Insufficient permissions for the user in Fusion OTBI side to access the data being validated.
Action:
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
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.
@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.
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.
@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.
1=2
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.
@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!.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
In FDI, most of the Hierarchy folder wont populating any data. This is one of the most required data from HR. Can anyone assist me how can I get that data in FDI.
Hello Oracle Team, Many organizations currently rely on both Oracle Transactional Business Intelligence (OTBI) and Oracle Fusion Data Intelligence (FDI) for reporting and analytics. While FDI continues to expand its subject area coverage, there are still several OTBI subject areas that are not yet available in FDI. Could…
We want a better grasp on what is considered custom data so we can plan ahead and scale properly before we get too big. Fortunately we are no where near the 50gb limit as found using the subject area for custom data but it doesn't tell us other than 'System' where the custom data is coming from. I found documentation here:…
Is there a way to refresh our development environments in OAC with production data? There a lot of developments that didn't make the cut into production and/or was only used for testing and we would like to clean up dashboards, datasets, data flows, etc… Possibly similar to how receive environment refreshes in our Oracle…
Managers want the ability to assign delegates in Fusion Data Intelligence (FDI) so that delegated users can access and use reports on their behalf. Is that available in FDI now? If yes, anyone share docs about steps to implement that in FDI Thanks
