Invoice API: The CT_REFERENCE Column is Not Updated, When Using the Standard API to Create an Invoice

(Doc ID 1919723.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are using the following standard APIs for creating AR Invoices.

AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE
AR_INVOICE_API_PUB.CREATE_INVOICE

You are using 'p_trx_header_tbl(i).reference_number' table type for the value CT_REFERENCE, which will update the column in the RA_CUSTOMER_TRX_ALL table.

The CT_REFERENCE is not getting updated.

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