Valid Credit Card Transactions Being Skipped in AMEX Upload File
Summary: AMEX has created a "Virtual" account that has credit card transactions posted to it that must be expensed in Oracle and which are part of the statement period total that must be paid to AMEX each month (the Corporate Card Program for this is Company Pay). AMEX has given this virtual/dummy account the name CORPMEMRWDS. They say it was setup to capture membership points at the corporate level (rather than the individual card account level) for the purpose of allowing the company to use those points to offset business expenses.
The problem is, AMEX says they cannot enter an employee id for it. So when the transactions come to Oracle in the Daily AMEX upload file, Oracle skips over them with the following message in the log file: