AutoInvoice Issue: Imported Invoices are Missing Ship To Information on Invoice Header (Doc ID 1396272.1)

Last updated on OCTOBER 20, 2016

Applies to:

Oracle Receivables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

When a sales_order lines has 2 lines and if they both have 2 different ship to contact ids then the Invoice header (ra_customer_trx_all ) is not populated with the ship to information. All the ship_to columns are missing information in ra_customer_trx_all where as in ra_customer_trx_lines_all the information is populated.

In R12 you can have multiple ship to addresses for one Invoice or sales_order, but in this case the ship to address was same, ship to Customer was same but only the ship to contact was different.

AutoInvoice should have populated the ship to address id on the invoice.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms