My Oracle Support Banner

Delivery Number Is Not Populated Into INTERFACE_LINE_ATTRIBUTE3 in AR Interface Which Results in Two Invoices (Doc ID 2811978.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.


One has configured an ATO model and options bills of material. The unit (ATO item) is shipped and one expects to get one invoice for model and all ATO options on one invoice, but two invoices are being produced.
One can see this is a result of invoice grouping rule based on interface_line_attribute3, which is the delivery_id of the shipment.
The invoice grouping rule is by shipment (delivery_id) for many reasons and cannot be changed.
For the model, the interface_line_attribute3 is being populated in the ra_interface_lines_all table, however, for the options and configured item (aka star item) this value is always 0.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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