My Oracle Support Banner

Detailed Information On Foundation Data Migration For Department/Class/Subclass (Doc ID 2425880.1)

Last updated on JULY 26, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Goal

While during data migration,  data was created as follows

DEPT CLASS SUBCLASS
1           1        1
1           2        1
2           1        1
2           2        1

But the RMS application would have created the same in below manner.

DEPT CLASS SUBCLASS
1         1            1
1         2            2
2         3            3
2         4            4

using the class sequence and subclass sequence generators.

Users want to  correct the data and need some suggestions on the following proposals.

Proposal 1:
------------------
1- jump the sequence and update it to 100, so that the business created data will start from the sequence.
2. Correct the existing data through pending merchandise hierarchy.

proposal 2:
-------------
1. Wipe the entire foundation data and rebuild from scratch.

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.