How to query third party payments from Cloud expenses
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?