EX_TRANS table is populated with User input transaction
Hi Team,
We recently upgraded from 9.1 version to 9.2 image 11.
Currently we are noticing that when EX_TRAN_PRCS is loading visa transactions its adding USR (user input) transaction as well. Visa file does not have any such data source transactions and we are clueless how user input lines are getting populated in EX_TRANS table.
SELECT EMPLID, DATA_SOURCE_EX, SEQ_NBR, EXPENSE_TYPE, MONETARY_AMOUNT FROM PS_EX_TRANS
WHERE DATA_SOURCE_EX NOT IN ( 'USB', 'VIS');
XXXXX USR 1 DATACAB 0
Can you please assist with this.
Regards,
Vinayak Patil