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 12.2.6.1 and later
Information in this document applies to any platform.

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

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