My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2023

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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