R12: EDI: ORA-12899: value too large for column EC.ECE_AR_TRX_HEADER_1.INTERFACE_ATTRIBUTE1 (Doc ID 2195171.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Symptoms

When a user attempts to run ECEINO: OUT: Invoice (810/INVOIC) the following error occurs:

ERROR
-------
Program level ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl: Please check the log file, correct the problem, and try again.
  Program level xProgress: Please check the log file, correct the problem, and try again.
  ECE_ERROR_CODE (ERROR_CODE=-12899)
  SQL error message ORA-12899: value too large for column "EC"."ECE_AR_TRX_HEADER_1"."INTERFACE_ATTRIBUTE1" (actual: 31, maximum: 30).


The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Other > Requests

3. Click on Single Request

4. Enter Request Name (ECEINO: OUT: Invoice (810/INVOIC) )

5. Enter Parameters

6. Click Ok

7. Click on Submit

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