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
Query to identify the UCM document ID for an Expense Report attachment in BI Publisher — 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

Query to identify the UCM document ID for an Expense Report attachment in BI Publisher

Received Response
34
Views
3
Comments
edited Sep 9, 2020 3:35PM in Expenses 3 comments

Content

Hi experts,

Based on the document:

How to identify UCM Document ID for an attachment from the Expense Report? (Doc ID 2520471.1)​

I have built a query to obtain the ID of the UCM document to obtain the information of the expense reports with status "ready for payment" I made an example expense report to be able to test my query, however it does not return information trying with other reports of expenses if you return information.

I attach the query that I am using.

 

I appreciate your comments.

Regards.

Cesar.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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