Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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
25
Views
1
Comments
edited Apr 13, 2020 5:29PM in Expenses 1 comment

Content

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.

Register

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