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

Last updated on APRIL 18, 2022

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.