Oracle ERP invoice data is not appearing in the DW_INVOICE_SPEND_CF table

Keith Antone

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

Is there an undocumented filter condition that is being applied in the FAW pipeline that excludes records from being populated in the DW_INVOICE_SPEND_CF table?

it appears that the table contains both ACCOUNTED and UNACCOUNTED records, but our data is not being reflected in the table.

Mallikarjuna Kuppauru-Oracle

Hi @Keith Antone

The Invoice Spend data is will populates for ACCOUNTED invoices ONLY .

I hope we have resolved the same from your SR. If yes please close this Thread after accept the same as Answer.

Thanks for using Oracle Communities.

Regards,

Arjun

Sumanth V -Oracle

@Keith Antone - Please validate the data configuration parameters and make sure data entered qualifies for the incremental load based on last extract date. If data being entered is back dated then you can consider doing a full reset of functional area and validate if the data flows in.

Mallikarjuna Kuppauru-Oracle

Hi @Keith Antone

Can you check this thread and accept the same and close.

Regards,

Arjun