Closed Sales Order Line Not Interfaced To AR Yet INVOICE_INTERFACE_STATUS_CODE = YES (Doc ID 1951677.1)

Last updated on MARCH 21, 2024

Applies to:

Symptoms

Sales Order Line is closed but no invoice is generated despite the INVOICE_LINE workflow activity showing as complete and INVOICE_INTERFACE_STATUS_CODE is Yes.
In this case, order line should be interfaced to AR and an invoice generated.
Due to some issue, Sales Order Line is not interfaced to AR and Invoice was not generated.

Steps

The issue cannot be reproduced at will for a new sales order but it can be verified for problematic sales order lines by following steps below:

1. Go to Order Management responsibility>Orders, Returns>Sales Orders.
2. Query the sales order and go to lines and check status is Closed.
3. Go to Receivables responsibility> Control> Interfaces> Autoinvoice> Interface Lines.
4. Query by Sales Order number and notice lines are not interfaced.
5. Go to Transactions>Transactions.
6. Query by Order Source and Sales Order Number in Reference and notice no invoice / credit memo exists.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.