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:
Oracle Purchasing - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]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.
Changes
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 |
Changes |
Cause |
Solution |
References |