Invoice API Error: Using AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE to Create a Transaction With INTERFACE_HEADER_ATTRIBUTES / CT_REFERENCE Exceeding 30 characters Raises: ORA-12899: value too large (Doc ID 1480147.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

When using AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE to create an invoice wherein the values passed for interface_header_attributes and ct_reference exceeds 30 characters, the following error is raised:

ORA-12899: value too large

Review of the FND debug log file shows:

L_MSG_DATA Error in AR_INVOICE_UTILS.Get_batch_source_details ORA-12899: value too large for column "AR"."AR_TRX_HEADER_GT"."CT_REFERENCE" (actual: 31, maximum: 30)

 

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