Error While Cancelling The Purchase Order When The Cancel Reason Exceeds 240 Characters

(Doc ID 2304967.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3

Actual:
Cancelling the purchase order from the buyer work center is causing an error.

Expected:
Cancellation should complete without error.

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



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



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