My Oracle Support Banner

R12: OIE: The MasterCard Transaction_type 12 'Cash Withdrawal' Should Itemize As Personal (Doc ID 2152978.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
The MasterCard Transaction_type 12 'Cash Withdrawal' Itemization Personal Credit Card
The MasterCard CDF3 Transaction Loader and Validation Program (APXMCCDF3)

Symptoms


ACTUAL BEHAVIOR
---------------
During the credit card transactions load and validate via concurrent request "MasterCard CDF3 Transaction Loader and Validation Program" not all transaction_type 12 "CASH WITHDRAWAL" transactions are automatically flagged as Category= 'PERSONAL'. Some are instead being flagged as 'BUSINESS'.

EXPECTED BEHAVIOR
-----------------------
Expect all transaction_type 12 transactions to be automatically categorized as 'PERSONAL' by the APXMCCDF3 module: "MasterCard CDF3 Transaction Loader and Validation Program".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download a transaction file from the bank.
2. Submit the "APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program"
3. Review the loaded data in the AP_CREDIT_CARD_TRXNS_ALL table and see that not all TRANSACTION_TYPE = '12' transactions have CATEGORY = 'PERSONAL'. Instead some have CATEGORY = 'BUSINESS'.


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!


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