In this post we are going to see the  steps that are needed to validate/configure the EBS and ASCP instance integration. This Setup changes might be  required after cloning and setting up new APS destination and EBS source.

Source EBS: DEBS

Destination APS : DAPS


1) Create DBapps and public schema of both source and destination instance.

On Source Instance DEBS create DB link with name 
DAPS connecting to DAPS instance. DB link should be present in both public and APPS schema.

On Destination Instance DAPS create DB link with name 
DEBS connecting to DEBS instance. DB link should be present in both public and APPS schema.

2. Log in to the Target (ASCP) System and choose “Advanced Planning Administrator”.
Navigate to Admin --> Instances. The Application Instances window appears.
Insert record for the Source (ERP) system as follows:
Instance Code : Give a new name for the Instance Code (uniquely identified).
Instance Type : Select “Discrete” (consult Functional Consultant).
Version : 11i (default, for 11i E Business Suite).
From Source to APS : Database Link created on the Source System for Target System Database.
From APS to Source : Database Link created on the Target System for Source System Database.
Check “Enable Flag”, “Allow ATP” and “Allow Release”.

You can verify the values from below table on APS side

select * from MSC_APPS_INSTANCES.

3) On EBS source set Below profile value as DB link name pointing to APS instance.

MRP:ATP Database Link = DAPS

4)  On EBS side check below table/view should be having correct value.


In case multiple rows are available in the above query, then update
MRP_AP_APPS_INSTANCES_ALL.ALLOW_ATP_FLAG = 1 for only the one correct instance we want to use for ATP.
For all other rows update it as 2.

In case no rows are present in the table the we can insert.

 insert into mrp.MRP_AP_APPS_INSTANCES_ALL values (1,46523506,'27-SEP-18','FUN','DEBS','DAPS',-1,'27-SEP-18',1396,'30-APR-08',104,6269,'HR',2,2,2,14,13,14,13,12,11,NULL,13,14,14,14,14,14,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,'x.SEGMENT1',2,NULL,NULL,'C');

There might be various other steps than need to worked upon by you functional or technical consultant.