EEX9.2: Few Columns Are Not Populated in EX_TRANS If MasterCard data is Reloaded After an Error (Doc ID 1914084.1)

Last updated on MARCH 27, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When users try to reload MASTER CARD transactions, few columns are not populated in EX_TRANS table.

STEPS
-----------------------
1. Load external data for Master Card transactions.
2. Some transactions are errored as there is no proper cc number associated, fix that error and re-load errors.
3. Some fields like PERSONAL_EXPENSE, EX_TYPE_FLAG, ENHC_DATA_LOADED, and CC_POSTING_DT columns are not populated.


ACTUAL BEHAVIOR
---------------
All fields are not loaded into EX_TRANS

EXPECTED BEHAVIOR
-----------------------
All EX_TRANS columns including PERSONAL_EXPENSE, EX_TYPE_FLAG, ENHC_DATA_LOADED, and CC_POSTING_DT should get populated after errors are reloaded into EX_TRANS table.


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