Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to query third party payments from Cloud expenses — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to query third party payments from Cloud expenses

Received Response
edited Apr 13, 2020 5:29PM in Expenses 1 comment


Users are creating expense reports in Cloud but reimbursements are happening in a third party system (on prem EBS). We are using the standard ESS jobs to extract the payments to EBS and then to import the payment data from EBS back to cloud. That process works fine.

My question is, once this data comes back into Cloud from the third party system, is there any way to query it in a report, either a BI report using SQL or OTBI? The system adds the incoming xml as an attachment so the user can click on the attachment and see the payment details, but how can we query the amounts that were paid on an expense report with the payment date? 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!