Multiple Card Programs Vs Multiple Expense Templates

Summary:

We're encountering a situation in our project where there are multiple Card Programs (Travel Card & Procurement Cards) for Expenses.

Both cards are issued by Visa through the Bank of America. Due to differences in volume and nature of expenses, separate templates may be necessary for Travel expenses and Procurement card purchases.

Given that the Merchant Category Codes (MCC) are identical for both cards, the challenge arises in how the system will distinguish between the two Expense templates when importing Credit card transactions and allocating them to the appropriate Expense type.

Has anyone faced a similar scenario and does anyone have insights into how Oracle will handle this situation? Any input or information on this matter would be greatly appreciated.