My Oracle Support Banner

Planner Extract Does Not Respect Org Filter In Msc_instance_orgs And Planner Disable_date (Doc ID 2720789.1)

Last updated on OCTOBER 16, 2020

Applies to:

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

Symptoms

Planner extract does not look at the disable date of Planner code and msc_instance_orgs. So even though user disable the mismatch value, they will still be pulled by extract.

Example:

Planner code AA11 is setup in 3 orgs:
- ABC: This org is in MSC_INSTANCE_ORGS. The planner code is active in this org.
- XYZ: This org is in MSC_INSTANCE_ORGS. The planner code is NOT active in this org.
- AAA: This org is in NOT MSC_INSTANCE_ORGS. The planner code is active in this org.

So based on this, the extract should only pull the records from ABC. So the correct description in “DOE, JOHN”.
But the extract now pulls the description as “JOHNSON, SAM” because it took the max across all disabled planner and orgs that are not in MSC_INSTANSCE_ORGS.

 

Cause

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
Symptoms
Cause
Solution
References


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