Payables and Cash Management - EBS (MOSC)

MOSC Banner

Is there a sql query to determine if a loaded credit card transaction has already been entered manua

edited Jan 23, 2020 12:25PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

We are implementing MasterCard CDF3 Transaction loads to R12.1.3 iExpense.  Up until this time, users have been entering transactions manually into their expense reports. Is there a sql query to determine if a loaded MasterCard transaction has already been entered manually on a report?  We don't want to allow duplicate entries and so would want to deactivate transactions that have already been entered manually.

I have looked into using the Credit Card Historical Transactions Management program.  This is used to deactivate transactions that have not been used.  I am looking for a way to identify transactions that have already been used through manual entry.  Is there a query or report available to show these?

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