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

Last updated on JUNE 23, 2016

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
MasterCard
Transaction_type 12 'Cash Withdrawl'
Itemization
Personal
Credit Card
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 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'.


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