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.
  1. In ODI, open the SDE_ORA115<ver>_Adaptor or SDE_ORAR12_Adaptor folder.
  2. Open the SDE_ORA_SalesInvoiceLinesFact.W_SALES_INVOICE_LINE_FS.SQ_BCI_SALES_IVCLNS temp interface, click on the Quick Edit tab.
  3. Expand the Filter section, select the filter RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG='Y'.

    The red cross mark gets highlighted, this is to delete the highlighted filter.

  4. Click on the cross button.
  5. Save your changes to the repository.
  6. Regenerate the scenario.
  7. Repeat steps 2 - 6 for the temp interface - SDE_ORA_SalesInvoiceLinesFact_Primary.W_SALES_INVOICE_LINE_F_PE_SQ_BCI_SALES_IVCLNS.

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.
  1. In ODI, open the SDE_FUSION_Adaptor.
  2. Open the SDE_FUSION_SalesInvoiceLinesFact.W_SALES_INVOICE_LINE_FS_SQ_TRANSACTIONLINEPVO temp interface, click on the Quick Edit tab.
  3. Expand the Filter section, select the filter SALESINVOICECUSTOMERTRXLINESPVO.TransactionHeaderCompleteFlag='Y'.

    The red cross mark gets highlighted, this is to delete the highlighted filter.

  4. Click on the cross button.
  5. Save your changes to the repository.
  6. Regenerate the scenario.
  7. Repeat steps 2 - 6 for the temp interface - SDE_ORA_SalesInvoiceLinesFact_Primary.W_SALES_INVOICE_LINE_F_PE_SQ_BCI_SALES_IVCLNS.