R12: EDI: ORA-12899: value too large for column EC.ECE_AR_TRX_HEADER_1.INTERFACE_ATTRIBUTE1
Last updated on JANUARY 16, 2018
Applies to:Oracle EDI Gateway - Version 12.1.3 and later
Information in this document applies to any platform.
When a user attempts to run ECEINO: OUT: Invoice (810/INVOIC) the following error occurs:
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms