Error Page While Trying To Open Change Order Approval From Notification Work List ORA-01422: "APPS.PO_REQCHANGEREQUESTNOTIF_PVT", line 3040

(Doc ID 2320150.1)

Last updated on OCTOBER 23, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.1.3

Actual:
Getting Error Page While trying to open Change Order Approval from notification work list

Expected:
Error should not be encountered when opening the change order approval from notification.

Error:
Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PO_REQCHANGEREQUESTNOTIF_PVT", line 3040
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.wf.server.RCOBuyerApprovalNotfnVORowImpl.getChangedAmount(RCOBuyerApprovalNotfnVORowImpl.java:991)
at oracle.apps.icx.por.wf.server.RCOBuyerApprovalNotfnVORowImpl.getChangedAmountDisplayFlag(RCOBuyerApprovalNotfnVORowImpl.java:783)
at oracle.apps.icx.por.wf.server.RCOBuyerApprovalNotfnVORowImpl.getAttrInvokeAccessor(RCOBuyerApprovalNotfnVORowImpl.java:557)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectGoodValue(OADictionaryDataViewObject.java:146)
at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue(OADictionaryData.java:90)
at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectValue(OADictionaryDataViewObject.java:119)
at oracle.apps.fnd.framework.webui.OADataBoundValueViewObject.selectValue(OADataBoundValueViewObject.java:317)
at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(OADataBoundValue.java:238)
at oracle.apps.fnd.framework.webui.OADataBoundValue.getValue(OADataBoundValue.java:158)
at oracle.apps.fnd.framework.webui.OADataBoundValueViewObject.getValue(OADataBoundValueViewObject.java:396)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1833)
at oracle.apps.fnd.framework.webui.beans.layout.OASpacerBean.getAttributeValueImpl(OASpacerBean.java:196)
at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)


Replication Steps:
The issue can be reproduced at will with the following steps:
1. Notification is received for approval.
2. Upon trying to open the notification an error is encountered.



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