My Oracle Support Banner

Consistency Not Maintained When Deleting Data from MONTH_DATA, WEEK_DATA, and HALF_DATA via SALMAINT (Doc ID 2182238.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Consistency is not maintained when deleting data from MONTH_DATA, WEEK_DATA, and HALF_DATA using the SALMAINT batch.  After running this batch, records are cleared in the HALF_DATA table, but a few records for the same half period can be found in the MONTH_DATA and WEEK_DATA tables.

This can later cause issues when using the application. For example, when attempting to delete a subclass from the system, it may not get deleted due to the reason "MONTH_DATA exists for that subclass", even if the half partition related to the involved transaction has been dropped.

Steps to Recreate:

  1. Run salmaint batch.
  2. Notice that records can be found in month data table for a half, even when the half partition of HALF_DATA table has been dropped.





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.