My Oracle Support Banner

WF_Engine_Util.Function_Call(FND_OAM_KBF_SUBS...) ORA-1403: no data found (Doc ID 579444.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Application Object Library - Version: 11.5.10.2 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
### checked for relevance 15-Feb-2012 ###

Symptoms

Here is what is happening:
1. Logging is turned on and an exception occurs.
2. The logging code (fnd_log_repository package.post_exception) raises a business event.
3. The business event kicks off a workflow to notify the system administrator of the exception.
4. The workflow calls pl/sql package FND_OAM_KBF_SUBS,
     which gets information out of the logging tables to put in the workflow notification.
     Since the logging data in the logging tables is missing, FND_OAM_KBF_SUBS fails with
     an ora-1403 no_data_found exception.


OAM Business Events Error
========================  
Error Name = 100
Error Message = ORA-01403: no data found
Error Stack = Wf_Engine_Util.Function_Call(fnd_oam_kbf_subs.CreateSubList, OAM_BE, 627396, 138561, RUN)
.

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
     Solution for 11i
     Solution for 12.1.3
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.