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

(Doc ID 579444.1)

Last updated on OCTOBER 04, 2016

Applies to:

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


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)


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