Cost Change ID Not Generating Based On Sequence Via Cost Change Upload From MFCS UI
(Doc ID 2971740.1)
Last updated on SEPTEMBER 01, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
ERROR
-----------------------
Cost Change ID not generating based on sequence via cost change upload from MFCS UI
MFCS is taking the cost change value provided on the ODS upload sheet and creating the cost change based on the same ID.
If there is a previous cost change with same number in staging table, the record is getting errored out.
In the previous V19 version, post upload of cost change upload sheet, MFCS generated a unique cost change based on max(cost_change)+1 and used that for creating the cost change in MFCS.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load the cost change ODS file
2.Notice that in v22 , the cost change id is what we have provided in the ODS
file but in V19 ,the id is getting generated as per the sequence.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |