On Legacy Collection - Planning ODS Load Is Not Loading Information from MSC_DEMANDS Table (Doc ID 2212175.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.

Symptoms

On : 12.2.4.1 version, running the Legacy  Collection.

During this request set, the program MSCPDCW Planning ODS Load Worker is also run and this ends in error/hangs . Planning ODS Load is not loading data to MSC_DEMANDS.

It appears to be stuck when is executing the following SQL:

UPDATE MSC_DEMANDS SET INVENTORY_ITEM_ID= :B24 , ORGANIZATION_ID
= :B1 , OLD_USING_REQUIREMENT_QUANTITY= USING_REQUIREMENT_QUANTI
TY, OLD_USING_ASSEMBLY_DEMAND_DATE= USING_ASSEMBLY_DEMAND_DATE,
OLD_ASSEMBLY_DEMAND_COMP_DATE= ASSEMBLY_DEMAND_COMP_DATE, USING_
ASSEMBLY_ITEM_ID= :B23 , USING_ASSEMBLY_DEMAND_DATE= :B22 , USIN
G_REQUIREMENT_QUANTITY= :B21 , ASSEMBLY_DEMAND_COMP_DATE= :B20 ,
SOURCE_ORGANIZATION_ID= :B19 , PROBABILITY = :B18 , DEMAND_CLAS
S= :B17 , ORDER_PRIORITY = :B16 , PROJECT_ID= :B15 , TASK_ID= :B
14 , SALES_ORDER_LINE_ID= :B2 , DISPOSITION_ID= :B2 , CUSTOMER_I
D= :B13 , CUSTOMER_SITE_ID = :B12 , SHIP_TO_SITE_ID = :B11 , PLA
NNING_GROUP= :B10 , REFRESH_NUMBER= :B9 , REVISED_DMD_DATE = :B8
, REVISED_DMD_PRIORITY = :B7 , LAST_UPDATE_DATE= :B6 , LAST_UPD
ATED_BY= :B5 WHERE PLAN_ID= -1 AND SR_INSTANCE_ID= :B4 AND ORIGI
NATION_TYPE= :B3 AND SALES_ORDER_LINE_ID = :B2 AND ORGANIZATION_
ID = :B1

STEPS TO REPRODUCE THE ISSUE
----------------------------------------
The issue can be reproduced at will with the following steps:

1. Advanced Supply Chain Planner (ASCP)
2. Collections
3. Legacy System
4. Collect Flat File Data

 

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