EEX 9.2: EX_DATA_LOAD AE Program Abends at Step EX_PUB_VISA.PUBVISA.LoadFile Due to Inconsistent Length Value of Field EX_VISA_15_FLO.VS_DEPART_TIME Versus EX_VISA15_TA1.VS_DEPART_TIME (Doc ID 2889780.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

The Credit Card Upload process (EX_DATA_LOAD AE Program) is not properly importing into the Employees' My Wallet feature Visa International enhanced data (Folio) containing Transaction Type 15 (Airline Passenger information). The system detects that the value to be stored into Record Field PS_EX_VISA15_TA1.VS_DEPART_TIME coming from File Layout Field EX_VISA_15_FLO.VS_DEPART_TIME is longer than expected:

Value '000000' is being tried to get stored while the Field is a Number type with a length of only 4 positions, not 6.

REPLICATION STEPS:

    1.- Place the received Visa International electronic flat file into the Temp folder of the Process Scheduler
    2.- Navigate to: Travel and Expenses > Corporate Credit Cards > Load External Data Sources
    3.- Create a new Run Control ID, and define the path for the electronic flat file placed in the Temp folder
    4.- Click on Run button
    5.- Confirm that the EX_DATA_LOAD AE Program completes in Success, but checking the Message Log, it states several transactions have been found in error, and not loaded

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

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