25544345 ASCP Cross Instance Setup - Org From The Second Instance Not Available In The Plan Options

(Doc ID 2234062.1)

Last updated on JUNE 28, 2017

Applies to:

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



We are trying cross instance planning.
Instance 1 is from EBS with data collected using standard collections.
Instance 2 is legacy instance with data collected via legacy collections.

For a plan defined in the first instance, the org from the second instance is not available to choose in the plan options.

1. code levels match between internal and customer instance

PLL/ PLX - MSCFPPSC : 120.33.12020000.15
Plan options form - MSCFPPSC 120.52.12020000.20
Plan names form - MSCFPCSC 120.10.12020000.1

2. The customer has SQL that includes sr_instance_id in the where clause
Our internal instance on same release does not have this SQL using sr_instance_id

INTERNAL TRACE - EBSDB_ora_31896_MFG_0208_092359.trc
 - does not show line for AND pt.sr_instance_Id = :1
CUSTOMER SQL - EBSCGPB1_ora_7469_KKUMAR_0207_180159.trc

SELECT mrp.organization_id,
 pt.partner_name name ,
FROM msc_trading_partners pt,
 msc_parameters mrp
WHERE pt.sr_tp_id = mrp.organization_id
AND pt.sr_instance_id = mrp.sr_instance_id
AND pt.partner_type =3
AND pt.sr_instance_Id = :1 <<<< THIS IS THE PROBLEM <<<<
AND TRUNC(NVL(pt.disable_date, sysdate+1)) > TRUNC(sysdate)
 (SELECT 'x'
 FROM msc_selected_orgs_v mso
 WHERE mso.organization_id = pt.sr_tp_id
 AND mso.sr_instance_id = pt.sr_instance_id
 AND mso.responsibility_id = fnd_global.resp_id
ORDER BY pt.organization_code


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