How To Purge Incentive Compensation Staging ( Transaction , Participant , Rate ) Tables ?
(Doc ID 1941775.1)
Last updated on SEPTEMBER 15, 2020
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion Incentive Compensation - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
User imported approximately 69,000 transactions with the wrong transaction type, using the display name instead of the lookup code (e.g. Revenue instead of REVENUE).
Docs 1683444.1 and 1553343.1 suggest correcting or re-importing the affected transactions to fix collection errors. However it's impossible to change the transaction type of an existing transaction in the application, and re-importing them will only create new transactions because it's keyed off the combination of transaction type and transaction number. So we'll end up with two copies of all our transactions, the valid one and one that will sit there in Collection Error status forever.
Is there a way to clean the transaction staging table so can re-importing the transaction data with the correct types?
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