My Oracle Support Banner

Custom Query for Outstanding Card Transactions Report (Doc ID 2755945.1)

Last updated on MARCH 07, 2021

Applies to:

Oracle Fusion Expenses Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Expenses

User had used  EXM_CC_OUTSTND_TRXN_SUM table to show outstanding card transactions. However, this does not show employees BY NAME have these transactions, which is the most vital information for client.
User reviewed this link ( but are having issues with creating a query output that contains the following information at minimum:

Employee Name
Employee Number
Assignment Number
Outstanding Credit Card Transaction Amount
Transaction Currency
Transaction Age
Expense Report Status, If Applicable (e.g. pending expense auditor approval, pending approval, etc.)

We had looked at tables:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.