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: 18.104.22.168 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)
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
Solution for 11i
Solution for 12.1.3