Requisition Edit During Request For Information Results In ORA-01403 (Doc ID 2146967.1)

Last updated on JUNE 09, 2016

Applies to:

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

Symptoms

Requisition Edit During Request For Information Results In error.

ERROR
-----------------------
Error:
ORA-01403: no data found ORA-01403: no data found ORA-01403: no data found ORA-01403: no data found ORA-06512: at "APPS.WF_NOTIFICATION", line 6969 ORA-06512: at line 1

-- Log File --
.
.
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@56ab
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.releaseLocalJDBCConnection(weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@56ab): : BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.releaseLocalJDBCConnection: END
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getSessionAttribute(String,int): END
wf.plsql.wf_engine_util.function_call.actfunc_callout 1 Start executing PLSQL procedure - PO_WF_REQ_NOTIFICATION.POST_APPROVAL_NOTIF [Start time -238595723]
wf.plsql.WF_DIRECTORY.GetRoleInfo2 2 BEGIN
wf.plsql.WF_DIRECTORY.GetRoleInfo2 2 END
wf.plsql.WF_DIRECTORY.GetRoleInfo2 2 BEGIN
wf.plsql.WF_DIRECTORY.GetRoleInfo2 2 END
fnd.framework.webui.OAPageErrorHandler 3 "OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at ""APPS.WF_NOTIFICATION"", line 6969
ORA-06512: at line 1
,In VO: null"
fnd.framework.webui.OAPageErrorHandler 3 "OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at ""APPS.WF_NOTIFICATION"", line 6969
ORA-06512: at line 1"
fnd.profiles.Profiles 2 getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10004; levelValue=1466; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10003; levelValue=-1; levelValueApplID=-1
fnd.profiles.Profiles 2 getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10002; levelValue=-1; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10001; levelValue=0; levelValueApplID=0
fnd.framework.webui.OAPageErrorHandler 3 "OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at ""APPS.WF_NOTIFICATION"", line 6969
ORA-06512: at line 1
,In Bean: null"
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_CUSTOM_OA_DEFINTION; levelID=10004; levelValue=1466; levelValueApplID=0
fnd.framework.webui.OAPageContextImpl 1 ===============================================================
fnd.framework.webui.OAPageContextImpl 1 Root Application Module
fnd.framework.webui.OAPageContextImpl 1 ViewUsageName: MsgAttrVO
fnd.framework.webui.OAPageContextImpl 1 isPreparedForExecution: true
fnd.framework.webui.OAPageContextImpl 1 whereClause: null
fnd.framework.webui.OAPageContextImpl 1 whereParam0: 125135
fnd.framework.webui.OAPageContextImpl 1 orderByClause: null
fnd.framework.webui.OAPageContextImpl 1 ViewUsageName: NtfAttrVO
fnd.framework.webui.OAPageContextImpl 1 isPreparedForExecution: true
.

Steps to reproduce:
1. Create iProcurement requisition.
2. Submit for Approval.
3. Approval asks for 'Request for More Information'
4. User - Updated / Edited Requisition and submitted.
5. Try to respond to approval.
6. Click on submit will error out.



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