My Oracle Support Banner

Updating Database Sequence For Dept/Class/Subclass For MFCS (Doc ID 2873769.1)

Last updated on JUNE 07, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

Updating Database Sequence for Dept/Class/Subclass for MFCS

Users have a query related to how the Database Sequencing will work for Merch Hierarchy.

In MFCS, there is the option to autogenerate Dept/Class/Subclass using the System Options.

So if loading a few dept/class/subclass into MFCS using our Conversion, can the auto-generate sequence be updated to the next highest value for dept/class/subclass?

Ex. Currently in MFCS the Subclass sequence in 65.

In RMS (Source data) we have subclass ranging from 1 to 1000 and we loaded all the data to MFCS using DC Tool. Now when we try to create a new subclass from Frontend it will still show 65 value (sequence value) which can have data integrity issue. So is it possible that after the data load to MFCS using DC Tool. We can update the relevant sequence to something like 1001 or 2000 so that we can use the auto-generated number to continue from the legacy sequence last value?


Solution

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
Goal
Solution


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