Error While Cancelling The Purchase Order When The Cancel Reason Exceeds 240 Characters
Last updated on MAY 09, 2018
Applies to:Oracle Purchasing - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Using Purchasing, Version 12.1.3
Cancelling the purchase order from the buyer work center is causing an error.
Cancellation should complete without error.
Exception of ARCHIVE_LINES()-010: ORA-12899: value too large for column "PO"."PO_LINES_ARCHIVE_ALL"."CANCEL_REASON" (actual: 293, maximum: 240) Cause: A SQL error has occurred in Exception of ARCHIVE_LINES(). The SQL error is ORA-12899: value too large for column "PO"."PO_LINES_ARCHIVE_ALL"."CANCEL_REASON" (actual: 293, maximum: 240). Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
User-Defined Exception in Package po.plsql.PO_Document_Cancel_PVT. Procedure update_po_rev_archive:006:1:User-Defined Exception
User-Defined Exception in Package PO_Document_Cancel_PVT Procedure cancel_document:004
The issue can be reproduced at will with the following steps:
1. Buyer work center proceed to query the purchase order.
2. Attempt the cancellation - giving the reason
3. Find that the cancel action results in the error above.
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