Exclude Adjustment Records in MasterCard Transaction File Upload

You can exclude the MasterCard adjustment transactions in the <FinancialAdjustmentRecord_5900> records from getting created as expenses using the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type.

To this lookup type, add the adjustment reason codes of the adjustment records that you want to exclude as lookup codes. During the MasterCard transaction file upload, the Expenses application will process these records and exclude them from getting created as expenses where the adjustment reason codes match the lookup codes added to this lookup type.

Note: Even though the adjustment transactions are added to the lookup table, they will still get loaded to Expenses and you can view them on the Review Corporate Card Transactions page. However, no expenses are created for these adjustment transactions.

Before you define the lookup codes in the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type, ensure that you have the complete list of adjustment reason codes that you want to exclude. The lookup type is empty by default. You must add the adjustment reason codes that you want to exclude. Once you add adjustment reason codes to the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type, the Expenses application will exclude only the defined adjustment reason codes.

If you don’t define any lookup codes in the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type, the upload process automatically excludes the payment transactions based on any one of these criteria:

• The adjustment description of the <FinancialAdjustmentRecord_5900> record contains the word Payment without any of these keywords: Fee, Charge, Reversal, Adjustment, Credit, or Debit.

• The transaction type of the <FinancialAdjustmentRecord_5900> record is 0108 or 0440.

Note: If the automatic exclusion of the payment transactions works for you or if you are uncertain of the list of adjustment reason codes to exclude, don't add lookup codes to the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type.

This figure shows an example of a <FinancialAdjustmentRecord_5900> record with Payment word in the adjustment description, and the transaction type is 0108.

This is a sample adjustment transaction that's eligible for automatic exclusion when there are no adjustment reason codes defined in the lookup type.

Add the Adjustment Reason Codes to Exclude Adjustment Transactions

This example demonstrates how to exclude the <FinancialAdjustmentRecord_5900> adjustment transactions with adjustment reason code 0108 from getting created as expenses using the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type. With this configuration, the application will process all the other adjustment transactions, such as those with adjustment reason codes 0160 and 0440, and add them as expenses.

This figure shows an example of the adjustment transaction from the Feed file.

Here's how you can use the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS lookup type to exclude the MasterCard adjustment transactions in the <FinancialAdjustmentRecord_5900> records from getting created as expenses:

1. In the Setup and Maintenance work area, go to the following:

   • Offering: Financials

   • Functional Area: Expenses

   • Task: Manage Standard Lookups

2. Click the Manage Standard Lookups link.

3. On the Manage Standard Lookups page, Search section, enter ORA_EXM_MC_EXCLUDE_ADJUSTMENTS in the Lookup Type field and click Search.

4. In the ORA_EXM_MC_EXCLUDE_ADJUSTMENTS: Lookup Codes section, click the New (+) icon to add lookup codes for each of the adjustment transactions that you would like to exclude.

5. In the Lookup Code field, enter the adjustment reason code that you would like to exclude, such as 0108.

6. In the Meaning field, enter the description of the adjustment record.

7. Ensure that the Enabled check box is selected.
8. In the Start Date field, provide an older start date so that the transactions after that date are excluded.

9. Click Save or Save and Close.

In this setup, the application will exclude transactions for <FinancialAdjustmentRecord_5900> with the adjustment reason code 0108. The application will process all the other adjustment transactions and add them to the employee’s Expenses work area.