Requisitions with empty Procurement BU

Victor H

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.

Ashish-Oracle

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

Mallikarjuna Kuppauru-Oracle

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

Victor H

As expected,, REQ_PROC_BU_ID is empty (-99999) so it maps to novalue.

How is REQ_PROC_BU_ID being derived?

Ashish-Oracle

@Victor H Can you please check the REQ_BU_ID column of the Fusion table, POR_REQ_BU_OPTIONS_ALL and verify once?

https://docs.oracle.com/en/cloud/saas/procurement/24c/oedmp/porreqbuoptionsall-19976.html#porreqbuoptionsall-19976

Victor H

Thera are multiple REQ BUs in this table, how are these being picked BY FDI for every requisition?