MSCPDP Planning Data Pull Errors : ORA-04052 Looking Up Remote Object / Release Of Planned Orders From The ASCP Planners Workbench Errors: Cannot Connect To Source Instance (Doc ID 567827.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance 29-JUN-2015***

Symptoms

When attempting to release Planned Orders from the ASCP Planners workbench, the following error occurs.

Cannot Connect to Source Instance.. Please check the connection to source instance.


----AND ---

When attempting to run data collections the MSCPDP module: Planning Data Pull errors with the below error:

ORA-04052: error occurred when looking up remote object APPS.FND_PROFILE@PLUMIC_TO_PLUMII
ORA-00604: error occurred at recursive SQL level 2
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PLUMIC_TO_PLUMII


Both are due to the same problem with dblink PLUMIC_TO_PLUMII

STEPS:
1. Navigate to Responsibility Advanced Supply Chain Planner.. Planners workbench.
2. Release Planned order. Above error occurs.
3. Navigate to Responsibility Advanced Supply Chain Planner.. Collections > Standard Collections.
4. The Planning data pull errors with the above error.

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