My Oracle Support Banner

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 NOVEMBER 26, 2018

Applies to:

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


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

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.


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

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