Concurrent Programs Fails With ORA-01403: No Data Found Has Been Detected In FND_CONC_RAC_UTILS

(Doc ID 1988419.1)

Last updated on NOVEMBER 08, 2017

Applies to:

Oracle Concurrent Processing - Version 12.2.3 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


On Oracle Applications 12.2.3, Concurrent Manager Issues:

Various concurrent programs were failing and getting the below error #1. Found the MOS Note 1577982.1 which suggested patch 17909318. The patch upgrades the framework to 12.2.4.

In the middle of upgrade process and have decided to go live with 12.2.3 framework. Applied patch 20312229 to get the 12.2.3 backport to fix the error and received a single core dump in FNDLIBR when running Maintain Summary Templates per error #2 below and requests still fail with errors such as:


ORA-01403: no data found

Error #1

Oracle error 100: ORA-01403: no data found has been detected in FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION

Error #2

Segmentation Fault - core dumped
/home/<node>/dead.letter... Saved message in /home/<node>/dead.letter
The internal concurrent manager has terminated with status 139 - giving up.


Application Object Library: Concurrent Processing version 11.5

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

Internal Concurrent Manager started : 02-MAR-2015 19:05:50

02-MAR-2015 19:05:50
Unsuccessful in TNS ping of node xxxxxx, error reported: Listener Not Found.
Could not start Service Manager FNDSM_xxxxxx_xxxxxx. The TNS alias could not be located, the listener process on xxxxxx could not be contacted, or the listener failed to spawn the Service Manager process.
02-MAR-2015 19:05:50
Request : 36891074
Priority : -75
Program : 0/4
State : Q

  Process monitor session started : 02-MAR-2015 19:05:50


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