prchstprg.pc batch deletes tran_type = 0 records which is leading to batch batch_posupld fail. How c

Hi All,

We need to purge the PRICE_HIST table using the prchstprg.pc batch which deletes the data partition wise using the retention days criteria from system_options table,

However, when checked it is selecting the tran_type = 0 records for deletion. If tran_type = 0 records gets deleted for any item from price_hist table then batch BATCH_POSUPLD will get failed

with "BATCH_POSUPLD - get_base_price~price_hist ERROR" error message.

How can we prevent this??

Regards,

GD.