My Oracle Support Banner

If Import Duplicate Transaction Number Into the Transaction Interface Table, Which Transaction Will be Collected ? (Doc ID 2560590.1)

Last updated on JULY 01, 2019

Applies to:

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

Symptoms

There are multiple transaction data file imported into the Transaction Staging table.  When running Collection, it's not clear on which version of the same transaction is collected.

Examples:

Case # 1
Transaction Number Transaction Type Source Event Date Amount LAST_UPDATE_DATE ( Imported Date/Timestamp )
TRX-1 INVOICE 01-JAN-2019 100.00 2019-06-18 16:44:01
TRX-1 INVOICE 01-FEB-2019 100.00 2019-06-18 17:00:00

Case # 2
Transaction Number Transaction Type Source Event Date Amount LAST_UPDATE_DATE ( Imported Date/Timestamp )
TRX-2 INVOICE 01-APR-2019 200.00 2019-06-18 16:44:01
TRX-2 INVOICE 01-MAR-2019 200.00 2019-06-18 16:44:01

 

Cause

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
Symptoms
Cause
Solution


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