My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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

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.