Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

EX_TRANS table is populated with User input transaction

edited Oct 22, 2018 4:24AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 14 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center