My Oracle Support Banner

Approver Deletes Requisition Line And Receives ORA-06512: At "APPS.POR_UTIL_PKG", Line 1499, ORA-20000: Exception at POR_UTL_PKG.restore_working_copy (Doc ID 2068583.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to delete requisition line by an approver, the following error occurs.

ERROR
-----------------------
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

Enable diagnostic to view error message

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20000: Exception at POR_UTL_PKG.restore_working_copy(p_origHeaderId:<orgHeaderId>,p_tempHeaderId:<p_tempHeaderId>) 010 SQLERRM:ORA-01403: no data found
ORA-06512: at "APPS.POR_UTIL_PKG", line 1499
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException(ErrorUtil.java:667)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitWorkingCopyReq(RequisitionSvrCmd.java:2240)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReqNoValidation(RequisitionSvrCmd.java:945)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.continueSubmitReq(RequisitionSvrCmd.java:893)
 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a purchase requisition with multiple lines
2. Submit the requisition for approval
3. Approver deletes one line on Purchase request and submit.


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


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