My Oracle Support Banner

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 later
Information in this document applies to any platform.



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.

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.