My Oracle Support Banner

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:

  1. Make sure TRAN_DATA_HISTORY table is defined as interval range partition.
  2. Make sure the dates associated to that partition fall within the purge criteria for SALPRG.
  3. Make sure that you have only one partition for TRAN_DATA_HISTORY table.
  4. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.