Purge Staging Inventory Transactions in BCT Tables with Error Status

Hello,

There is a delivered PeopleSoft process IN_BCT_PURGE to delete Transactions in BCT tables with complete status, but not in error status.

We cloned the main SQL Delete steps from IN_BCT_PURGE application engine to create a SQL Test script to delete transactions from TSE_BCT_FLD, BCT_DTL and BCT_CTL with BCT_STATUS='1' (in error).

We are alarmed that we will be deleting respectively 120000, 43000 and 43000 rows from TSE_BCT_DTL, BCT_DTL and BCT_CTL. The errors are related to Par Location Count and Inventory Adjustment Transactions.

Any feedback or guidance would be highly appreciated, as it looks to us as design flaw.