Smart View Drill Down till Subledgers level
Summary
Is detailed Drill Down / Drill Through till Subledgers possible?Content
We demonstrated Drill-Through feature in Smart View to users. We can go from Smart View excel file to 'Inquire on Detail Balances' in Oracle GL UI through Drill Through feature and from there, we can go the Journal, and even till Subledger Transaction such as AP Invoice etc.
But there are multiple clicks to do to reach to an individual subledger transaction. Business wants to view all the subledger transactions with just one or two clicks. For example, Travelling Cost is appearing for X amount, the user should be able to click on X field and see what subledger transactions (e.g. AP Invoices with supplier, supplier site, invoice #, invoice date etc.) made up this X amount. Is there a way to achieve this? Do you have any such requirement and how you were able to achieve for your business?