WF_Engine_Util.Function_Call(FND_OAM_KBF_SUBS...) ORA-1403: no data found
Last updated on OCTOBER 04, 2016
Applies to:Oracle Application Object Library - Version: 126.96.36.199 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
### checked for relevance 15-Feb-2012 ###
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
Million Knowledge Articles and hundreds of Community platforms