EEX 9.1+: Late Payment Charge Visa Transactions Skipped By Credit Card Upload If 4 Last Digits Of Involved Credit Card Account Numbers Are Equal (Doc ID 1999452.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

A problem in the delivered Credit Card Upload Application Engine Program (EX_DATA_LOAD) has been detected, in which not all Credit Card Transaction Data rows included in the provided Visa Format 4.0 flat file get uploaded into the Employee's My Wallet feature (Record PS_EX_TRANS). This takes place when the following conditions are met:

   - For Visa International, Credit Card Transaction Type of LATE PAYMENT CHARGE will always come in the VCF file with a Transaction Number of 0000000000
   - In the delivered Visa VCF 4.0 flat file, there are at least 2 Late Payment Charges rows, each for a different Credit Card Account Number, but whose last 4 digit values are the same

While loading the VCF data, the Credit Card Account Number is being masked by the process, leaving only the last 4 digit numbers visible at the end, (such as ************1234). Should the VCF file contain 2 distinct Credit Card Late Payment Charge Transactions (Transaction Number being always 0000000000 at all instances) for 2 different Credit Card Account Numbers ending with same 4 digit values, the system loads only the first one, and skips the second transaction. The process treats the second transaction as duplicate from the first one while inserting the transaction data into the staging tables, which in this case is the record PS_EX_VISA_INFO_05. In this case, for all the LATE PAYMENT CHARGE transactions, the Transaction Number in the VCF is 0000000000, whereas for every other kind of transaction it is unique. This is the reason why the second transaction is skipped, and goes missing.

Ideally, the Credit Card Upload process should be able to successfully load into the My Wallet table (PS_EX_TRANS) all the existing transactions, and if not loaded for whatever reason, it should either be loaded into the Error tables, or some kind of notification should be generated stating that the transaction was not loaded.

REPLICATION STEPS:

   - Have from Credit Card Vendor Visa International a new flat file following the Credit Card format for 4.0, containing the below data:
        - 2 rows on Credit Card Maintenance Data, to create 2 new Credit Card Account Number instances into 2 different existing Employee IDs
        - Important to state that these 2 Credit Card Account Number must be equal on the last 4 digits, while may be different on the remaining positions
        - 2 additional rows with Credit Card Transaction Data, one for each Credit Card Account Number, containing Late Payment Charges, which in Visa International such transactions have a Transaction Number delivered value of '0000000000'
   - Place the Visa 4.0 flat file into the Temp Folder of the Application Server Host of the PeopleSoft Enterprise FSCM Environment
   - Log into the FSCM Online Application as User ID VP1
   - Navigate to: PeopleTools > Integration Broker > Configuration > Gateways
   - Open the Default Gateway, and Ping it Successfully
   - Navigate to: PeopleTools > Integration Broker > Integration Setup > Queues
   - Open existing CREDIT_CARD Queue, and make sure it is set to Run status
   - Navigate to: PeopleTools > Integration Broker > Integration Setup > Service Operations
   - Open the existing Service Operations CREDIT_CARD_MERCHANT_VISA_LOAD, and make sure that:
        - That in the General tab, the Active flag is properly selected
        - That the Handler CCMVISALOAD is set to Active
        - That the Routing Definitions are properly configured and in Active status
   - Navigate to: PeopleTools > Integration Broker > Administration > Domain Status
   - Make sure that the Database Domain is properly Active
   - Navigate to: PeopleTools > Integration Broker > Administration > Node Status
   - Select the Local Default Node, and make sure to Ping it Successfully
   - Navigate to: Set Up Financials/Supply Chain > Install > Installation Options > Expenses
   - Make sure to select the below two flags:
        - Include Account Maintenance = Y
        - Update Profile for New Account = Y
   - Navigate to: Travel and Expenses > Manage Employee Information > Update Profiles
   - Open existing Employee ID KU0057, and confirm that at the 'Corporate Card Information' tab, all is in blank
   - Open existing Employee ID KU0079, and confirm that at the 'Corporate Card Information' tab, all is in blank
   - Navigate to: Travel and Expenses > Corporate Credit Cards > Load External Data Sources
   - Add a new Run Control ID, and define the following settings:
        - Run Control ID = GCS
        - Data Source = Visa 4.0
        - Load External Data = Y
        - File Name = (Path from the Application Server Host Template folder, and the flat file name)
   - Launch the EX_DATA_LOAD Application Engine Program
   - Navigate to: PeopleTools > Process Scheduler > Process Monitor
   - Checking the Process Instance from the EX_DATA_LOAD AE Program, it can be seen in Success status
   - Navigate to: PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Services
   - Check within Queue CREDIT_CARD, the Service Operations Message Instance CREDIT_CARD_MERCHANT_VISA_LOAD, and at the Subscription Contract the status is Done
   - Navigate to: Travel and Expenses > Manage Employee Information > Update Profiles
   - Open existing Employee ID KU0057, and confirm that at the 'Corporate Card Information' tab, there is now a row with the proper Credit Card Account Number, masking all but the last 4 digit numbers
   - Open existing Employee ID KU0079, and confirm that at the 'Corporate Card Information' tab, there is also here a row with the proper Credit Card Account Number, masking all but the last 4 digit numbers, which are the same as for the other Employee ID
   - Navigate to: Travel and Expenses > Manage Expenses Security > Authorize Expenses Users
   - Open existing Employee ID KU0057, and make sure to manually add User ID VP1 in the list
   - Open existing Employee ID KU0079, and make sure to manually add User ID VP1 in the list
   - Navigate to: Employee Self-Service > Travel and Expenses > My Wallet
   - Define Employee ID KU0057, and click on Search, to later find in My Wallet, the Late Payment Charges Credit Card Transaction listed
   - Navigate to: Employee Self-Service > Travel and Expenses > My Wallet
   - Define Employee ID KU0079, and click on Search, to later find that for this Employee instance, the My Wallet feature is not listing anything, while it would be expected to contain the second Late Payment Charges Credit Card Transaction from the flat file

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

BUSINESS IMPACT:

The EX_DATA_LOAD Application Engine Program is not uploading all the Visa Credit Card Transaction Data rows contained within the provided Visa 4.0 flat file, which prevents Users from later on find those transactions into their My Wallet features (Record PS_EX_TRANS). As such missing transactions already account for late payment charges on payments that were not reimbursed on time by the Employee/Company, additional fees may apply, getting the Employee's Corporate Card suspended/blocked, or even further legal actions for continuous payment defaults.

EXPECTED BEHAVIOR:

The Application Engine Program EX_DATA_LOAD should be able to process all the Credit Card Transaction Data rows from any Visa 4.0 format, and place the data into the proper Employee My Wallet, or into the Visa Card Transaction Errors Page (EX_VISA_STG_ERR) if data is not validated properly under the below circumstances:

   - Expenses Profile does not exist for the given Employee ID
   - An Expenses Profile exists for the given Employee, but none is marked as Default Profile
   - Expenses Profile of the affected Employee has not passed all Validations for the Expenses module
 

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