Configure CCG Error Create Target Schema Objects ORA-06550 PLS-00352 Unable To Access Another Database '%s' (Doc ID 2260804.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

On : 5.5.1 version, Integra Apps

When attempting to configure an ERP instance,
the following error occurs.

ERROR
-----------------------

PLS-00352: Unable to access another database 'SWFDEV_AM_AGENT_LINK'

LOG FILE:

The PDF job log shows the following error:

Create Target Schema Objects (OA
11.0.3 and 11i-specific) Completed : 05-APR-2017 13:24:41
Log
User-Defined Exception
Error while Deploying CCG Apps.
ORA-06550: line 1, column 67:
PLS-00352: Unable to access another database 'SWFDEV_AM_AGENT_LINK'
ORA-06550: line 1, column 67:
PLS-00201: identifier 'DBMS_SQL@SWFDEV_AM_AGENT_LINK' must be declared
ORA-06550: line 1, column 59:
PL/SQL: Statement ignored
ORA-06550: line 1, column 112:
PLS-00352: Unable to access another database 'SWFDEV_AM_AGENT_LINK'
ORA-06550: line 1, column 112:
PLS-00201: identifier 'DBMS_SQL@SWFDEV_AM_AGENT_LINK' must be declared
ORA-06550: line 1, column 112:


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. Press Configure button on a new ERP instance.

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

Changes

 ERP was cloned

Cause

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