25544345 ASCP Cross Instance Setup - Org From The Second Instance Not Available In The Plan Options
(Doc ID 2234062.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 188.8.131.52 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_XXXXX_0207_180159.trc
pt.partner_name name ,
FROM msc_trading_partners pt,
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)
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
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