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

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms