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

Last updated on APRIL 04, 2025

Applies to:

Goal

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.

Solution

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