This discussion is archived
1 Reply Latest reply: Jan 22, 2013 9:03 PM by Sadanand Shenoy RSS

Data Loading Procedure of FA_BALANCES_REPORTS_ITF

user570667 Newbie
Currently Being Moderated
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 .




Regards

Zulqarnain
  • 1. Re: Data Loading Procedure of FA_BALANCES_REPORTS_ITF
    Sadanand Shenoy Newbie
    Currently Being Moderated
    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.

    Thanks,
    Sada

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points