How To Purge Incentive Compensation Staging ( Transaction , Participant , Rate ) Tables ?
Last updated on FEBRUARY 27, 2018
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms