My Oracle Support Banner

EEX 9.1: Credit Card Upload Program Abends at Step EX_LOAD_MCV3.ProcMnt.InsError With Duplicate Insert Into PS_EX_MC_MNT_ERR When Processing Multiple MasterCard CDFv3 Files With Different Account Maintenance Rows (Doc ID 2967849.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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

Symptoms

The Credit Card Upload process (EX_DATA_LOAD AE Program) is abending at Step EX_LOAD_MCV3.ProcMnt.InsError, with a duplicate violation constrain at Record PS_EX_MC_MNT_ERR.

On the reported scenario, since the company is loading multiple files on the same day, and it has the same source, the system is throwing a unique constraint error for transactions that are clearly different. If the Process Instance field exists on the error Record, unique constraint may not appear.

REPLICATION STEPS:

    1.- Have a couple of MasterCard CDFv3 xml files containing Credit Card Account Maintenance transactions, and place them into the needed Folder from Process Scheduler
    2.- Log into the FSCM Online Application as an Expenses User
    3.- Navigate to: Travel and Expenses > Corporate Credit Cards > Load External Data Sources
    4.- Create a new Run Control ID with the below settings:
          a) Data Source = MasterCard CDFv3
          b) Load External Data = Y
          c) File Name = Place the Folder navigation, and name of the FIRST MasterCard electronic flat file
    5.- Click on RUN button
    6.- Select the EX_DATA_LOAD AE Program
    7.- Click on OK button
    8.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
    9.- Confirm that the Process Instance has completed in Success
    10.- Navigate to: Travel and Expenses > Corporate Credit Cards > Credit Card Maintenance Errors
    11.- Go to the MasterCard Errors tab, and confirm that the Maintenance Account transactions from the first file are listed and flagged in Error (Such as Invalid Employee ID, Expiration date, Business Unit, etc...)
    12.- Navigate to: Travel and Expenses > Corporate Credit Cards > Load External Data Sources
    13.- Load the previously used Run Control ID, and define the below settings:
          a) Data Source = MasterCard CDFv3
          b) Load External Data = Y
          c) File Name = Place the Folder navigation, and name of the SECOND MasterCard electronic flat file
          d) Reprocess Corporate Card Errors = N
          e) Reprocess Corporate Card Maintenance Errors = N
    15.- Click on RUN button
    16.- Select the EX_DATA_LOAD AE Program
    17.- Click on OK button
    18.- Navigate to: PeopleTools > Process Scheduler > Process Monitor
    19.- Confirm that the Process Instance has completed in No Success

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

Changes

 

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
Changes
Cause
Solution
References


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