My Oracle Support Banner

Error While Cancelling The Purchase Order When The Cancel Reason Exceeds 240 Characters (Doc ID 2304967.1)

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.