Legacy Collection - Workdays Patterns Days On And Off Not Respected
(Doc ID 2153731.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.4 version, Legacy Data Collections
ACTUAL BEHAVIOR
---------------
The Pre-Processor assigns the shift_num and seq_num. The seq num should not be changed. The result is the work-day patterns days on and off get re-ordered. The ODS Load then loads the incorrect workday patterns.
Note, this customer was using ODBC direct connect from a DB2 database.
Example:
For Calendar AAAAA, Shift BBBBBB,
When looking at MSC_ST_WORKDAY_PATTERN table:
SEQ_NUM | DAYS_ON | DAYS_OFF
1 | 1 | 0
2 | 1 | 0
3 | 1 | 0
4 | 1 | 0
5 | 1 | 0
6 | 0 | 1
7 | 0 | 1
When looking at the MSC_WORKDAY_PATTERNS table:
SEQ_NUM | DAYS_ON | DAYS_OFF
4 | 1 | 0
5 | 1 | 0
6 | 0 | 1
58 | 1 | 0
59 | 1 | 0
60 | 1 | 0
61 | 0 | 1
Customer tried loading as support recommended.
For Calendar DDDDD, Shift EEEEEE
When looking at MSC_ST_WORKDAY_PATTERN table:
SEQ_NUM | DAYS_ON | DAYS_OFF
12 | 0 | 1
13 | 5 | 1
When looking at the MSC_WORKDAY_PATTERNS table:
SEQ_NUM | DAYS_ON | DAYS_OFF
1 | 5 | 1
15 | 0 | 1
EXPECTED BEHAVIOR
-----------------------
Work-day pattern days on and off do not get re-ordered after the Pre-Processor runs.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load legacy Workday pattern
2. Run Pre-Processor
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 |