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.
On : 220.127.116.11 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)
3. Legacy System
4. Collect Flat File Data
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
|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.|