Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
