EEX 9.1: Duplicate Error When Processing Return Transaction On VISA Credit Card Load (Doc ID 1924305.1)

Last updated on FEBRUARY 08, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Integration - Corporate Cards

When attempting to load a VISA file with same transaction ID,seq number and item seq numbe, but different transaction type,
the following error occurs.

ERROR
-----------------------
Duplicate entries exist. The file was already loaded. (10503,250) 
Process Duplicate entries exist. The file was already loaded. (10503,250) ABENDED at Step 0.EX_LOAD_VISA.EXTRANS (EXTRANS) -- RC = %6
GetMessageText: No default message. (108,524)
Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load a file with one like with transaction type 10 (charge) and note that process runs to success and that data is loaded int EX_TRANS.
2. Now change the transaction type to 11 for the same line and save the file with a different name.
3. Load this file and note that the above error message is displayed.

Expected result:
--------------------
Second file must be loaded too, since its a refund for the transaction which happened before.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load the VISA files which has a transaction and a refund for the same amount for the transaction.

 

Please see attached replication steps document for detailed screen shots of replication for this issue.

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