Consistency Not Maintained When Deleting Data from MONTH_DATA, WEEK_DATA, and HALF_DATA via SALMAINT
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.
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:
- Run salmaint batch
- 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.
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