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