25544345 ASCP Cross Instance Setup - Org From The Second Instance Not Available In The Plan Options
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 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
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
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