My Oracle Support Banner

Understanding DB Links Setup for APS Applications - ASCP and ATP Functionality (Doc ID 813231.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Oracle Order Management - Version 12.2.9 to 12.2.9 [Release 12.2]
Oracle Global Order Promising - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:MSCFINST.FMB - Define Application Instances


This document is to help Users and DBA’s setup and use dblinks correctly for ASCP and ATP Setups.
This is applicable for a distributed installation where APS Instance is on a separate server from the ERP Instance.

Example Setups for the information below:
ERP Instance – NIC located on server1
-- Setup a db_link called NIC_TO_KEP
APS Instance - KEPLER located on server2
-- Setup a db_link called KEP_TO_NIC

Questions and Answers

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
Questions and Answers
 Setting Up TNSNAMES For Each Instance
 Create and Test the DB_LINKS
 Application Setups that Use DB_LINK information
 Additional Setups for ATP When ERP Source is RAC Database
 Error Conditions That Can Occur
 Additional Information

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