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
edited Sep 9, 2020 3:35PM in Expenses 3 comments


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.



Howdy, Stranger!

Log In

To view full details, sign in.


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