My Oracle Support Banner

When Ordering From Punchout, Receive Error JBO-26041, Java.sql.SQLException: ORA-12899 (Doc ID 2580708.1)

Last updated on SEPTEMBER 12, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Requisitions

When ordering from punchout, receive error JBO-26041, java.sql.SQLException: ORA-12899

When ordering item from extenal shop - punchout, receive error
Error Code: 100 Unexpected Error
Unexpected exception occured in performCallback
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert"
And

## Detail 0 ##
java.sql.SQLException: ORA-12899: value too large for column "PO"."PO_REQUISITION_LINES_ALL"."ITEM_DESCRIPTION" (actual: 242, maximum: 240)


Replication:
1. In internal shop
2. Press punchout to external shop
3. Order item, basket, return to internal shop
4. Error occurs

ERROR
-----------------------
ORA-12899, JBO-26041


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
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.