My Oracle Support Banner

Lease Liability And Amortization Data Not Appearing In FLA Tables For Leases In Finalized Version (Doc ID 2819925.1)

Last updated on NOVEMBER 07, 2021

Applies to:

Oracle Fusion Lease Accounting - Version 11.13.21.07.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.21.07.0 version, Lease Creation

Lease Liability and Amortization data not appearing in FLA tables for leases in Finalized Version.

We observed that for leases in Finalized Version, the Lease Liability and Amortization data for future periods is not available in the FLA tables but we could see those values when the Lease is in Draft/BOOKED Version. We looked into the following tables -

FLA_LIABILITY_SCHEDULES;
FLA_LIABILITY_SCHEDULES_STAGE;
FLA_SCHEDULE_HEADERS;
FLA_ACCRUED_SCHEDULES_V;
FLA_ACTIVE_SCHEDULE_HEADERS_V;
FLA_LIABILITY_CURR_SUMMARY_V;
FLA_LIABILITY_SCHEDULES_V;
FLA_LIABILITY_SCH_SUMMARY_V;
FLA_LIABILITY_SUMMARY_V;

Business requirement is to derive a custom BI report to capture closing liability and amortization values for each period.

We could see this in the standard Lease Detail Report but we are unable to find those values for our report development in tables. Please help us in identifying the correct tables/ mapping to get these values for all the periods on the lease. Also, let us know what are the functions available under fla_schedule_utils_pkg?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.