My Oracle Support Banner

SKULIST Rebuild Option is Not Working (Doc ID 2268406.1)

Last updated on AUGUST 25, 2022

Applies to:

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


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).




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.