My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.