Unable To Start Concurrent Manager And Failing With Message Concurrent Manager cannot find error description for CONC-Get plsql file name

Unable To Start Concurrent Manager And Failing With Message Concurrent Manager cannot find error description for CONC-Get plsql file names [ID 1161386.1]

In this Document
Symptoms
Cause
Solution
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Application Object Library - Version: 11.5.10.2 and later [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Symptoms
On R11.5.10.2, it is not possible to start concurrent manager using adcmctl, but it is possible to start it using adstrtal. The ICM log file is showing the following error:

Concurrent Manager cannot find error description for CONC-Get plsql file names

Running the script cmclean does not fix the issue. FNDLIBR processes are showing as defunct on the operating system as follows:

oracle 27109 25564 0 15:07 ? 00:00:00 [FNDLIBR]
Cause
The package fnd_file was invalid.
This can be verified by checking the results for the following query:

select obj.owner,obj.object_type, obj.object_name , err.text
from dba_errors err, dba_objects obj
where err.name =obj.object_name
and err.owner =obj.owner
and obj.status ='INVALID'
order by 1,2;

Solution

Please execute the following to re-create the package FND_FILE:

1. Navigate to the directory containing the package files:

cd $FND_TOP/patch/115/sql/

2. Login to SqlPlus as apps, and run the following:

@AFCPPIOB.pls

***************************************************************************

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...