Processing Average Daily Balances

This section provides an overview of processing of ADB and discusses how to request the ADB process.

Page Used to Process Average Daily Balances

Page Name	Definition Name	Navigation	Usage
ADB Process Request	ADB_REQ	General Ledger, Average Daily Balance, ADB Process, ADB Process Request	Identify the business unit, ADB definition, and period type that you want to process. Also specify whether you want to recalculate existing average daily balances.

Understanding Processing of ADB

Once you establish the basis for average balance calculations, then initiate the background process that calculates the balances and updates the target ledger. If you want to run average balances for a ledger that has already been archived, you must restore the ledger and then run the ADB process.

ADB processing includes the following activities:

Journal Post (GLPPPOST).

The Journal Post process posts the daily balances into a holding table.
Post Daily Balances (GL_ADB_POST).

The ADB post process (GL_ADB_POST) posts the daily balances from the holding table into the ADB ledger (the source ledger containing the daily balances).

The ADB post process also posts ADB adjustments to the adjustment holding tables. (ADB adjustments are daily balances for a period that was posted after the ADB calculation process was run for that period.)

Note: Although the ADB post process is run from the journal post request, the ADB post process criteria is different from the journal post process for the posting of interunit journals. When posting interunit journals, the journal post process posts all of the non-anchor business units when posting the requested anchor business unit. The ADB post process only posts the anchor business unit. The non-anchor business units must be posted in separate requests.

Note: Instead of running the Journal Post process and the Post Daily Balances process separately, you can run the PS/GL Journal and ADB Post multiprocess job (GLADBPST) to post the journals and update the ADB ledger with the daily balances.

Note: The system prevents double posting in the event that two ADB post processes (GL_ADB_POST) are running concurrently for the same business unit. The ADB_PROCESS_STATUS field on the ADB ledger holding table (LEDGER-ADB_HLD) locks the rows that are being posted to the ADB ledger.

If an abnormal termination or failure occurs on a step in the ADB post process, perform the following steps before rerunning the process:

• Run the delivered DMS script ADBSTATUS.DMS in Data Mover to unlock the rows in the ADB ledger holding table. You must modify the script to include the process instance of the process that failed.

• Delete the failed request from the process monitor by selecting the Delete Request radio button in the Update Process section of the Process Detail page. This step is necessary to clean up data in the application engine state records.
ADB Calculation (GL_ADB_CALCX).

The ADB Calculation process calculates average balances using transactions from the ADB ledger and the adjustment holding table and places the results (average balances) in the ADB target ledger.

The ADB Calculation process creates an ADB log entry. The ADB log is used by the ADB process to determine when the average balances (for a given definition, period type, and requested period) were calculated.

ADB Process Request Page

Use the ADB Process Request page (ADB_REQ) to identify the business unit, ADB definition, and period type that you want to process.

Also specify whether you want to recalculate existing average daily balances.

Navigation

General Ledger, Average Daily Balance, ADB Process, ADB Process Request

ADB (average daily balance)

Enter the ADB definition. This field works in combination with the Period Type field to determine which calculation method the system uses.

Request Type

Select one of these request type options:

Calc End of Per(calculate for period end date): Calculate only one period's average daily balance. The average balance is for the period end date.

Calc Each Per (calculate for each period): Generate multiple periods' average daily balances, one for each day of the reporting period.

Period Type

Define the time period for the ADB calculation. This field works In combination with the ADB field to determine which calculation method the system uses.

Select the Period Type option for average balance calculations. Values are:

DTD (date to date): Calculates average balances from the specified begin date to the date specified in the Request Date Option (request date option) field. The begin date appears when you select this option.

MTD (month to date): Calculates average balances from the first day of the month, which is the beginning date of the accounting period in which the run request date falls, to the date specified in the Request Date Option field. To use this option, the detail ledger for the business unit must be tied to a detail calendar that uses monthly periods.

QTD (quarter to date): Calculates average balances from the first day of the quarter, which is the beginning date of the first accounting period in the quarter in which the run request date falls, to the run request date. To use this option, the detail ledger for the business unit must be tied to a detail calendar that uses monthly periods 1 through 12.

Reg Date (regular date): Calculates average balances for a date range that you enter in Begin Date and End Date fields, which appear when you select this option.

Reg Per (regular period): Calculates average balances from the beginning date of the from period to the ending date of the to period for the specified fiscal year. The from period, to period, and fiscal year appear when you select this option.

YTD (year to date): Calculates average balances from the first day of the year, which is the beginning date of accounting period 1, to the run request date specified in the Req Date Option field.

Fiscal Year

If you selected Reg Per (regular period) in the Period Type field, enter the fiscal year for the period here.

From Per (from period)

If you selected Reg Per in the Period Type field, enter the beginning period here.

To Per (to period)

If you selected Reg Per in the Period Type field, enter the ending period here.

Begin Date

If you selected Reg Date in thePeriod Type field, enter the beginning date for the date range.

If you selected DTD in Period Type field, enter the beginning date for the average balances calculation.

End Date

If you selected Reg Date in the Period Type field, enter the ending date for the date range.

Request Date Option

Specify the date option for the ADB process. Values are:

Process Date: Uses the process date of the business unit as the request date for the ADB process.

SYSDATE: Uses the system date as the request date for the ADB process.

As-Of Date: Uses the date that you specify in the As of Date field, which appears when you select this option.

If As Of Date is selected in the Request Date Option field, the As Of Date field and Update As of Date button appear above the Process Request group box. Click this Update As of Date button to globally update the as of date for requests that use the as of date option.

If you want to update only the as of date for one of the ledgers listed, use the as of date in the process request row.

Tree Date Optn (tree date option)

Select the effective date of the tree used to select the ChartFields values to be processed. Values are:

Use EndDt(use period end date): Sets the effective date to the end of the accounting period.

Use OverDt (use override date): Activates a field in which you can enter a date other than the period end.

Use Date Override

If you selected Use OverDt in the Tree Date Option field, enter a date other than the period end date to be used as the effective date for the tree.

Adhoc

Select this option if you want to recalculate average balances using the ad hoc method.

Description

Identify this run of average balance calculations with a short description, such as the date and type of processing.