Nothing Happens - Unable To Cancel Purchase Order When Long Cancel Reason Is Being Given (Doc ID 1510110.1)

Last updated on DECEMBER 15, 2023

Applies to:

Symptoms

Using Purchasing, cannot apply the 'Cancel' control action to PO and the cancel form returns and nothing happens or get error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package PO_DOCUMENT_CONTROL_PVT Procedure control_document"

Error:

Either the form just does nothing or get error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package PO_DOCUMENT_CONTROL_PVT Procedure control_document" or get error message "You attempted to perform a document action that is incompatible with the document status."

Replication Steps:

1. Login to the E-Business Suite and choose the Purchasing Module.
2. Purchase Order Summary - query back a purchase order - move to the lines - and then Tools/Control - Cancel
3. Find that upon doing a cancel - the form does nothing - action just returns back to the Cancel sub-form - will alternately see error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package PO_DOCUMENT_CONTROL_PVT Procedure control_document"

Another issue was noted in <Bug 16414343> which is also solved using the same patch (slight different symptoms).

When a supplier user submit the cancel request for PO and buyer accept it, the cancel request is rejected automatically even though buyer accept the request.

In this case supplier user see the following error message in Change Request page in iSupplier.

Although you have accepted the request to cancel this document, an error has occured while processing the cancellation.
Therefore the request is rejected. Please contact your system admin for more information

** NOTE: Users are seeing similar error, "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package PO_DOCUMENT_CONTROL_PVT Procedure control_document" when during Cancel, email address of more than 30 characters is entered in Cancel form. See Note 1515581.1 - R12.1.3 Unable To Cancel PO that will be Communicated with an Email Address more than 30 Characters **

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.