My Oracle Support Banner

ORA-20000: EXCEPTION AT POR_UTL_PKG.RESTORE_WORKING_COPY Error When Approval Tries to Edit Requisition and Submit the Changes (Doc ID 3020945.1)

Last updated on JUNE 06, 2024

Applies to:

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

Symptoms

When approver user is trying to Edit the requisition and submit the changes the following error occurs:

 

ERROR
-----------------------
"You have encountered an unexpected error"

Fatal OAException:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20000: Exception at POR_UTL_PKG.restore_working_copy(p_origHeaderId:1185244,p_tempHeaderId:1191224) 150 SQLERRM:ORA-20002: 3203: Attribute '#HDR_1' does not exist for notification '10032258'.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1628
ORA-06512: at line 1
;
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitWorkingCopyReq(RequisitionSvrCmd.java:2376)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReqNoValidation(RequisitionSvrCmd.java:1107)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.continueSubmitReq(RequisitionSvrCmd.java:1055)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReq(RequisitionSvrCmd.java:734)
at oracle.apps.icx.por.req.server.RequisitionAMImpl.submitReq(RequisitionAMImpl.java:1064)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processSubmitReq(EditSubmitCO.java:942)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processFormRequest(EditSubmitCO.java:780)

....
## Detail 0 ##
java.sql.SQLException: ORA-20000: Exception at POR_UTL_PKG.restore_working_copy(p_origHeaderId:1185244,p_tempHeaderId:1191224) 150 SQLERRM:ORA-20002: 3203: Attribute '#HDR_1' does not exist for notification '10032258'.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1628
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
...
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitWorkingCopyReq(RequisitionSvrCmd.java:2376)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReqNoValidation(RequisitionSvrCmd.java:1107)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.continueSubmitReq(RequisitionSvrCmd.java:1055)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReq(RequisitionSvrCmd.java:734)
at oracle.apps.icx.por.req.server.RequisitionAMImpl.submitReq(RequisitionAMImpl.java:1064)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processSubmitReq(EditSubmitCO.java:942)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processFormRequest(EditSubmitCO.java:780)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:967)



STEPS
-----------------------
1. iProcurement Responsibility
2. Workflow notification
3. Open Requisition 140083268 approver notification
4. Edit Requisition Button
5. Select Responsibility
6. Update item details
7. Change charge account
8. Select “Apply this Cost Allocation information to all applicable requisition lines” option
9. Apply
10. Check Funds
11. Submit
12. Error occurs

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
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.