Issues With The Changed Definition Of OE_ODR_LINES_SN (Doc ID 2014247.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

We observed that the snapshot definition of - "OE_ODR_LINES_SN" is changed in R12.2.4 when compared to 11i.

This snapshot is used in many of our collection programs and as this definition has changed in R12.2.4 it is affecting our custom code.

The where conditions of this snapshot are:

11i Version

FROM ONT.OE_ORDER_LINES_ALL OOL, MSC.MSC_COLLECTED_ORGS org
WHERE OOL.SHIP_FROM_ORG_ID = org.Organization_ID
  AND OOL.VISIBLE_DEMAND_FLAG = 'Y'
  AND OOL.ORDERED_QUANTITY <> 0
  AND SHIP_FROM_ORG_ID IS NOT NULL;
  
  
R12 Version
  
  FROM ONT.OE_ORDER_LINES_ALL OOL
WHERE OOL.ORDERED_QUANTITY <> 0
AND SHIP_FROM_ORG_ID IS NOT NULL;


These missing conditions ( AND OOL.VISIBLE_DEMAND_FLAG = 'Y' and OOL.SHIP_FROM_ORG_ID = org.Organization_ID) in R12 are returning more records compared to 11i. This is causing some issues in our custom programs. Can you please help us understand why these conditions are missing?
 

Solution

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