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.