ORA-12899: Value to Large for Column "PO"."PO_HEADERS_INTERFACE"."COMMENTS" (actual: 499, maximum: 240) (Doc ID 2929775.1)

Last updated on FEBRUARY 25, 2023

Applies to:

Symptoms

On : 12.2.9 version, G-Invoicing

While trying to interface IGT Order with Requesting Agency Comment field, the following error appears:

Error:
Error occurred while populating interface tables: ORA-12899: value too large for column "PO"."PO_HEADERS_INTERFACE"."COMMENTS" (actual: 499, maximum: 240)


Replication Steps:
The issue can be reproduced at will with the following steps:
1) Create order in G-Invoicing with Requesting Agency having the Comments field with more than 240 characters
2) Interface order into the E-Business Suite (EBS) using the Intragovernmental Orders Interface program.
3) Find that the Order is not imported and error above is encountered

Cause

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