Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Expenses Query Questions

edited Jul 21, 2020 11:03AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 2 commentsAnswered

I'm looking to write 2 queries and am looking for guidance on the correct records and fields to use.

Query 1 - I'd like to identify expense line items less than $25.00 with no receipt attached.  Ideally, I'd like to identify as soon as possible and not after payment.

Query 2 - I'd like to be able query expense items that are sitting in users 'wallets' but are not associated to an expense report.  I anticipate users will accumulate expense items in the wallet but not submit or not submit timely.  I'd like to have visibility to this.

Again, just not sure of the best records and fields to use.

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