is there anyway to delete pre-assignment data from cs_transactionassignment table ?
I already tried Reset from classify it's deleting credit and trace but not pre-assignment.
PS: I'm using custom stagehook package for pre-assignment.
With the 2301 release, users can now remove transaction assignment data by dropping a blank TXTA (assignments) file along with a transaction file (such as TXSTA, TXSTAR, TXSTARG, or TXSTAG) via ODI if the database preference callidus.Import.ImportTxn.RemoveTxnAssignments is enabled.
For example, if you originally loaded 100 transactions with assignments, and then wanted to remove assignments for 90 from the original set, you must create a new batch with just the 90, and pair that with a blank TXTA file. Note: A blank file is an empty file with no records.
Create a support ticket to get the database preference callidus.Import.ImportTxn.RemoveTxnAssignments enabled in your tenant to use this functionality.
If the database preference callidus.Import.ImportTxn.RemoveTxnAssignments is not enabled, transaction assignment data will not be removed when a blank TXTA (assignments) file is dropped.
You can do Reset from Validate from pipeline job only if transaction is pushed from TXSTA and TXTA which has batchname linked from stagetables. In transaction field, there is source field - if its imported it will purge the data.
If you're doing it through stagehook for assignment, then there should be way of you're linking to batchname of salestransactionSeq