Error While Configuring An Instance PLS-00201: Identifier 'AM_PLSQLUTIL_PKG.OBJECT_PREFIX must be declared ORA-06550 (Doc ID 2355280.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

On : 5.5.1 version, Integra Apps.,
While trying to configure an EBS instance in CCG, the following error occurs

ERROR
-----------------------
Error while configuring the instance.
ORA-06550: line 3, column 19:
PLS-00201: identifier 'AM_PLSQLUTIL_PKG.OBJECT_PREFIX@OAQCTTST_AM_AGENT_LINK' mu
st be declared
ORA-06550: line 3, column 9:
PL/SQL: Statement ignored
Error configuring the instance. User-Defined Exception
ORA-06550: line 3, column 19:
PLS-00201: identifier 'AM_PLSQLUTIL_PKG.OBJECT_PRE

+--------------------------------------------------------------------
| Statement# : 1, executing on GCCRPTST
| Description : Compile Agent Package Specifications
| Date and Time : 18-JAN-2018 12:40.32
| Ignore Errors: N
+--------------------------------------------------------------------
SQL statement suppressed from logfile.
+--------------------------------------------------------------------
| Statement# : 2, executing on GCCRPTST
| Description : Compile Agent Package Body
| Date and Time : 18-JAN-2018 12:40.32
| Ignore Errors: N
+--------------------------------------------------------------------
SQL statement suppressed from logfile.
+--------------------------------------------------------------------
| Statement# : 3, executing on GCCRPTST
| Description : Test Function In Am_Plsqlutil_Pkg Package
| Date and Time : 18-JAN-2018 12:40.32
| Ignore Errors: N
+--------------------------------------------------------------------

DECLARE temp_v VARCHAR2(200);
BEGIN temp_v := am_plsqlutil_pkg.object_prefix@OAQCTTST_AM_AGENT_LINK(NULL);
EXCEPTION WHEN OTHERS THEN NULL; END;
Error in am_deploy_Pkg.perform_target_sql -- ORA-06550: line 3, column 19:
PLS-00201: identifier 'AM_PLSQLUTIL_PKG.OBJECT_PREFIX@OAQCTTST_AM_AGENT_LINK' mu
st be declared
ORA-06550: line 3, column 9:
PL/SQL: Statement ignored
***** ORA-06550: line 3, column 19:
PLS-00201: identifier 'AM_PLSQLUTIL_PKG.OBJECT_PREFIX@OAQCTTST_AM_AGENT_LINK' mu
st be declared
ORA-06550: line 3, column 9:
PL/SQL: Statement ignored
***** Terminating SQL Set due

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to CCG as admin user.
2. Navigate to ERP workbench.
3. Add a new ERP instance and click on 'configure'.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run audit reports on a EBS instance.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.