My Oracle Support Banner

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:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.


On : 12.2.9 version, G-Invoicing

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

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


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

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