Oracle FDI - Budget date of the purchase requisition and PO

User_M7CX5

I need some assistance on where Oracle FDI stores the Budget Date for PR and PO distribution lines.

In our organization, when a user creates a requisition, funds availability (budget) is validated based on the Budget Date. If funds are not available, we adjust/reshuffle the budget so the requisition can be approved, and the same Budget Date is expected to carry through to the PO as well.

However, in Oracle FDI I cannot find this information in the two main fact tables, DW_REQUISITION_CF and DW_PURCHASE_ORDER_CF. This is critical for building budget vs actual reports, and for tracking the process starting from the requisition stage.

Can anyone advise where FDI stores this Budget Date information from Fusion?. For reference, in Fusion it exists at the distribution level (e.g., POR_REQ_DISTRIBUTIONS_ALL and PO_DISTRIBUTIONS_ALL contain the Budget Date used).

Thank you in advance for your help.

Silvio Garber-Oracle

If the column you need is not part of the prebuilt model, you can create a data augmentation. Here´s the BIVO lineage.
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect

User_M7CX5

Hi Silvio, Thank you for the response, I will try this option.