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