Concurrent Programs Fails With ORA-01403: No Data Found Has Been Detected In FND_CONC_RAC_UTILS
(Doc ID 1988419.1)
Last updated on MAY 04, 2024
Applies to:
Oracle Concurrent Processing - Version 12.2.3 to 12.2.5 [Release 12.2]Information in this document applies to any platform.
Symptoms
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:
FND_STATS.gather_table_stats('GL',
'GL_SUMMARY_INTERIM_10' ,
20);
END;
ORA-01403: no data found
Error #1
Error #2
/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
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 |
References |