My Oracle Support Banner

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

Last updated on APRIL 30, 2017

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
References


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