Error Validating The Database Link While Defining Application Instances In ASCP (Doc ID 2228457.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Patch Application Issues

Error validating the database link while defining application instances in ASCP 12.2.6

We upgraded our test ASCP instance from 12.1.3 to 12.2.6 and trying to connect source instance on 12.1.3, while defining a database link in application instances form (ASCP side) getting above error.

Database link is working fine if you execute from backend toad/sql plus.

ERROR
-----------------------
Error validating the database link


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In the planning instance> Application Instances form
2. Define database link from source to destination and from destination to
source
3. In the field: From Source to Destination, please insert the database link.
4. The error message: Error validating the database link.

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