Concurrent Programs Fail With: Oracle Error 100: ORA-01403: No Data Found Has Been Detected In FND_CONC_RAC_UTILS. (Doc ID 1988419.1)

Last updated on AUGUST 01, 2016

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 is huge and upgrades the framework to 12.2.4.
In the middle of upgrade process and have decided to go live with 12.2.3 frame work. 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 stat BEGIN
 FND_STATS.gather_table_stats('GL',
'GL_SUMMARY_INTERIM_10' ,
  20);
  END;

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 NBSR12RAPID, error reported: Listener Not Found.
Could not start Service Manager FNDSM_NBSR12RAPID_anbsqual. The TNS alias could not be located, the listener process on NBSR12RAPID 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

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