Unable To Save New Application Instance In ASCP (Doc ID 2130076.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On :  12.2.2 version, Data Collections

Unable to save new application instance in ASCP  

When trying to add a second EBS instance to the application instances form in ASCP initially receive an error that "Source to APS db link already exists".
Click OK
and then select the Organizations button,
 receive error ORA-00936: Missing Expression, FRM-40505: ORACLE Error: unable to perform query.
Then able to add the organizations to the form but again not able to save the instance.

We have rechecked the configuration on both the Source instance and ASCP as well as the DB links being set up by the APPS user.

ERROR
-----------------------
"Source to APS db link already exists".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup the dblinks
2. Try to add a second EBS Source instance in the Applications Instances form using the dblinks

Advanced planning administrator>admin>instances
Instance Code = XYZ
Instance Type = Discrete
Version = 12.1
From source = COLLECT.ABC.com
From APS = COLLECT.ABC.com
Enable Flag = Checked
GMT = -1
Currency = GBP
Click save or Organizations

3. Get the error "Source to APS db link already exists".

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