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 JANUARY 17, 2017

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:2025,p_tempHeaderId:2025) 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.


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