Is There A Way To Purge Transactions Staging Table ?

(Doc ID 1941775.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

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?

Cause

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