My Oracle Support Banner

How To Purge Incentive Compensation Staging ( Transaction , Participant , Rate ) Tables ? (Doc ID 1941775.1)

Last updated on MAY 10, 2022

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version and later
Oracle Fusion Incentive Compensation - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.