Invoice Line data not appearing DW_AP_SLA_EXPENSE_DIST_CF table

Keith Antone

Our team has entered test data in the Oracle Financials Cloud application that is unexpectedly not being populated in the Expense Distribution fact table.

Is there an undocumented filter condition that is being applied in the FAW pipeline that excludes records from being populated in the DW_AP_SLA_EXPENSE_DIST_CF table if the associated Invoice (DW_AP_INVOICE_CF) has INVOICE_ACCOUNTING_STATUS_CODE ='UNACCOUNTED'?

Sumanth V -Oracle

@Keith Antone - "AP Invoices" subject area[DW_AP_INVOICE_CF] returns all invoices created before the Initial Extract Date defined in the config, plus their installments. Irrespective whether the invoices are accounted or not. However, "AP Expense" subject area[DW_AP_SLA_INVOICE_SCHEDULE_CF] returns the invoice distributions of only accounted invoices. The invoices not yet accounted will not show up in "AP Expense" subject area.
Currently, we don't have a subject area to return AP Invoice Lines and their matched "Purchase Orders" data if they are not accounted yet.

Kindly let us know if this clarifies. Thank you.

Sumanth V -Oracle

@Keith Antone - Yes, there is a filter in pipeline and if the invoice is unaccounted, it will not be available as FAW supports only accounted invoices. This is as per design.

Keith Antone

@Sumanth V -Oracle We are seeing invoices with INVOICE_ACCOUNTING_STATUS_CODE = 'UNACCOUNTED' flow into the DW_AP_INVOICE_CF and DW_AP_SLA_INVOICE_SCHEDULE_CF. The associated Expense Distributions are not available

in FAW for these invoices.