1 Reply Latest reply on Jan 23, 2013 5:03 AM by Sadanand Shenoy

    Data Loading Procedure of FA_BALANCES_REPORTS_ITF

      Hi 2 all

      Anybody know that How Retirement & Additional Depreciation data load in FA_BALANCES_REPORTS_ITF.

      Begining and Ending data load in FA_BALANCES_REPORTS_ITF table through FA_BALREP_PKG.populate_gt_table procedure .


        • 1. Re: Data Loading Procedure of FA_BALANCES_REPORTS_ITF
          Sadanand Shenoy
          Hi Zulqarnain,

          The direct process of calculation is a bit complex to explain at the outset.

          From your test / clone instance, you can download the package: fabalrepb.pls and check for Procedures like:
          - get_adjustments, which calculates the Adjustments performed, using FA_ADJUSTMENTS etc tables
          - get_balance, which calculates the Balances, using FA_DISTRIBUTION_HISTORY etc.

          You will get a clear idea on the tables and the way the values are calculated.