ORA-12899 : value too large for column "PO". "PO_HEADERS_GT" "FREIGHT_TERMS_LOOKUP_CODE" (Doc ID 2065821.1)

Last updated on OCTOBER 25, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Purchase Order (PO)

Unable to update or submit PO to re-approve 

This PO was created in 11i and now the users need to do some modification in R12. 

When trying to submit this PO to reapprove, the following error message occurs: 

This PO currently has the Freight Term "Freight Prepaid and Charge", related Code is "FREIGHT PREPAID AND CHARGE". It is 26 digits. 
 

ERROR
-----------------------
ORA-12899 : value too large for column "PO". "PO_HEADERS_GT" "FREIGHT_TERMS_LOOKUP_CODE" (actual: 26, maximum: 25) 
in Package PO_DOCUMENT_CHECKS_PVT Procedure POPULATE_PO_HEADERS_GT.




STEPS TO REPRODUCE
---------------------------

1. Query order SO-000917
2. try to change, receive error
3. try to approve, receive error


Changes

 PO created on R11.5.x and upgraded to R12.1.3

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