cancel
Showing results for 
Search instead for 
Did you mean: 

Purge pre-assignemnt data from cs_transactionassignment

Bidlby
Explorer
0 Kudos

Hello,

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

I868539
Advisor
Advisor

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.

yogananda
Product and Topic Expert
Product and Topic Expert
0 Kudos

basel.idlby

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

Bidlby
Explorer
0 Kudos

I don't have a link for now and i'm looking if this can happen through UI directly where to keep the transaction but remove the assignment.