My Oracle Support Banner

FAQ For ADB Calculation (Average Daily Balance Calculation) (Doc ID 2229561.1)

Last updated on AUGUST 08, 2019

Applies to:

Oracle General Ledger
Information in this document applies to any platform.

Purpose

The purpose of this document is to answer some basic questions about Average Daily Balance Setup and Calculation in Release 12.
More information can be obtained from the Oracle General Ledger User Guide and Average Daily Balance associated whitepapers.

 

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Questions and Answers

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
Purpose
Questions and Answers
 1. What is the Purpose of the Average Daily balance?
 2. How to setup the Average Daily Balance in R12?
 2.1 How to Define Transaction Calendar
 2.2 How to Enable the Average Balance flag in ASM?
 2.3 How to Define the Average Daily Balance Translation rate?
 3. How to calculate the Average Daily Balance?
  3.1 What is the Relationship Between Aggregate and Average Balances?
  3.2 How to calculate the End of day (EOD) balance?
 3.3 How to calculate the Period Aggregate balance?
 3.4 How to Calculate the Quarter Aggregate Balance?
 3.5 How to Calculate the Year Aggregate Balance?
 3.6 What are the types of Average balances?
 3.6.1 How to calculate the Period Average-to-Date (PATD) Balance?
 3.6.2 How to calculate the Quarter Average-to-Date (QATD) Balance?
 3.6.3 How to calculate the Year Average-to-Date (YATD) Balance?
 4. How to do the Multi-Currency processing?
 4.1 How to calculate End of day(EOD) Balance in Foreign Currency?
 4.2 How to calculate Period Aggregate Balance in Foreign Currency?
 4.3 How to calculate Quarter Aggregate Balance in Foreign Currency?
 4.4 How to calculate Year Aggregate Balance in Foreign Currency?
 4.6 How to Calculate Quarter Average-to-Date Balance in Foreign Currency?
 4.7 How to Calculate Year Average-to-Date Balance in Foreign Currency?

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