SALPRG(Purge Stock Ledger History) Batch Fails To Drop The Only Partition For Tran_Data_History
(Doc ID 2529125.1)
Last updated on NOVEMBER 30, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
When SALPRG batch attempts to drop last partition of TRAN_DATA_HISTORY table which meets the purge criteria, it fails to drop the partition generating the following error:
Steps to reproduce:
- Make sure TRAN_DATA_HISTORY table is defined as interval range partition.
- Make sure the dates associated to that partition fall within the purge criteria for SALPRG.
- Make sure that you have only one partition for TRAN_DATA_HISTORY table.
- Run SALPRG , notice the above error message.
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