How can we create custom report which needs Payments, Interests, Liabilities for all leases?
Our requirement is to create a complex disclosure reports which needs values for period wise Closing liabilities, payments, interest, expense and RoU amounts for all the leases grouped by Finance and Operating leases.
To create the report we need to have these values available in a table in Oracle but as i understand these values are stored in staging table on temporary basis, it gets deleted from staging table and stored in LDR excel for each lease after accruals are run. So what is the way to develop the report if the data is not available in any of Oracle table? Opening LDR for all leases to get the data for each lease is not a practical solution.