Including Incomplete Invoice Lines When Extracting Sales Invoices
By default, the Oracle Supply Chain and Order Management Analytics application is configured to extract completed sales invoices when performing the Sales Invoice data extract.
Extracting Incomplete Sales Invoices for Oracle 11i and Oracle R12 Databases
Oracle 11i and Oracle R12 use a flag to indicate whether a sales invoice is complete. In particular, completed sales invoices are those where the RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG = Y in Oracle11i and Oracle R12.
To extract incomplete sales invoices, as well as complete invoices, remove the extract filter statement.
Extracting Incomplete Sales Invoices for Fusion Databases
Oracle Fusion Applications uses a flag to indicate whether a sales invoice is complete. In particular, completed sales invoices are those where the SALESINVOICECUSTOMERTRXLINESPVO.TransactionHeaderCompleteFlag='Y'.
To extract incomplete sales invoices, as well as complete invoices, remove the extract filter statement.