25544345 ASCP Cross Instance Setup - Org From The Second Instance Not Available In The Plan Options (Doc ID 2234062.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

12.2.5

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.



ANALYSIS
--------------
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

SELECT mrp.organization_id,
 pt.organization_code,
 pt.partner_name name ,
 mrp.consider_wip,
 mrp.consider_po,
 mrp.consider_reservations,
 mrp.plan_safety_stock,
 pt.sr_instance_id
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)
AND EXISTS
 (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

Cause

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