My Oracle Support Banner

SKULIST Rebuild Option is Not Working (Doc ID 2268406.1)

Last updated on AUGUST 04, 2020

Applies to:

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

Symptoms

Once a SKULIST is created, the rebuild option is not updating the SKULIST_DETAIL table with proper data.

Steps To Recreate:
1. Create new item list.
2. Add department, class (eg 1118, 1), so all the items under that will be created as skulist.
3. Now add to exclude one subclass 3 which has 2 items and rebuild the list. Skulist_detail is properly populated. (i.e 2 items belonging to subclass 3 are removed).

Case 1:

4. Now create new items for same department.
5. Edit the skulist and click on rebuild -->Execute and close button. Save and close the screen.
6. Check skulist_detail table , newly created item is not added but it should be added as per the process.

Case 2:
7. Now try to delete the exclusion record (i.e subclass 3 record).
8. Rebuild the skulist.
9. Check the items. As the exclusion is removed items belonging to department/class should be added back to the skullist (i.e All the items in subclass 3).






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


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