Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Requisitions with empty Procurement BU
Service admins are getting more requisitions than regular users, we found that this is because some requisitions have an empty Procurement Business Unit and thus are excluded by the data security role.
We checked these requisitions in OTBI and they seem fine , How is the "Requisition Procurement Business Unit" column being derived in FDI?
The documentation has some general ideas but I could not use this to troubleshoot in OTBI
Which OTBI columns could help us identify this issue? There are no empty BUs in OTBI for these requisitions.
Best Answer
-
@Victor H It appears you are looking for the logic of the pipeline on how data is loaded from Fusion Application to FDI Data Warehouse which is currently not exposed.
The lineage details covered in the provided guide is the only source of information we have currently.
0
Answers
-
HI @Victor H
As per Data lineage Document - Requisition Procurement Business Unit Name (ORGANIZATION_NAME)
is coming from DW_INTERNAL_ORG_D_TL table & DW_INTERNAL_ORG_D Stores the —> ORGANIZATION_ID.
Can you query above table and see are you able to see the correct data as source?
Regards,
Arjun
0 -
As expected,, REQ_PROC_BU_ID is empty (-99999) so it maps to novalue.
How is REQ_PROC_BU_ID being derived?
0 -
@Victor H Can you please check the REQ_BU_ID column of the Fusion table, POR_REQ_BU_OPTIONS_ALL and verify once?
0 -
Thera are multiple REQ BUs in this table, how are these being picked BY FDI for every requisition?
0
