posterBalancingJob and posterBalancingHistorySyncJob

Overview

The GL scrubber and poster reports generated with the nightly batch cycle can be used to manually verify balance and transaction totals. The posterBalancingJob simplifies this process and does much of the verification automatically.

The job uses parameters to determine which fiscal years to include and how many failures to print on the report, refer to General Ledger Parameters for additional information. 

The job also generates a report, called balancing, located in the reports/gl directory. It is described in detail below. 

posterBalancingJob

The first time the posterBalancingJob runs it populates entry, encumbrance and balance history tables that future runs of the job will use. From then on, each time the job updates the history tables, it includes entries from the most recent batch cycle.

The job compares the calculated history table amounts and row counts back to the production General Ledger counts and balances. Discrepancies are reported along with summary statistics for row counts and errors.

posterBalancingHistorySyncJob

The posterBalancingHistorySyncJob is unscheduled and can be run to sync the history tables with production tables. This job is normally run after errors are detected and resolved. When there are errors, the GL scrubber and poster batch reports can be used to determine where the problem(s) might lie. 

General Ledger Balancing Report

The General Ledger Balancing Report (reports/gl/balancing) lists errors found while comparing the history GL tables with the production GL tables. It also lists the files it uses for the comparison and row count statistics.

Comparison Errors

An error section is displayed for each history table that failed to balance. Detail is displayed for each error, up to the number specified in COMPARISON_FAILURES parameter.  The report includes the total number of errors, but details are shown only up to the number of errors specified in this parameter. 

Files used to update the history tables

Files used from the most recent batch cycle to update the history GL tables in order to compare with production GL tables. 

Statistics

Statistics are described below.

Label	Description
FISCAL YEARS INCLUDED IN BALANCING	Specifies the years included in the automated comparisons. Financials-PAST_FISCAL_YEARS parameter controls the number of prior fiscal years to include.
HISTORY TABLES INITIALIZED—UPDATES SKIPPED	The first time the posterBalancingJob is run, either initially or after the posterBalancingHistorySycnJob is run, the value is Yes, which indicates that the history tables required for future runs of the automated balancing report have been populated. During subsequent balancing (after the tables have been initialized), this value is No.
OBSOLETE HISTORY DELETED	If a given fiscal year in the history tables is no longer within the range of years to be included in balancing, this entry indicates the fiscal years that have been removed. If no fiscal years were removed, the value is No.
UPDATES SKIPPED DUE TO OUT OF RANGE FISCAL YEAR	If the most recent GL nightly batch cycle included entries for fiscal years that are not within the range of years to be included in balancing, this field indicates how many updates to the balancing tables were skipped due to out-of-range fiscal year entries.
GLEN AMOUNT FAILURES (EntryHistory)	The number of entries in the production GL Entry table that failed to match those in the history GL Entry table.
GLBL AMOUNT FAILURES (BalanceHistory)	The number of entries in the production GL Balance table that failed to match those in the history GL Balance table.
GLEN SUM (ROW COUNT) - CALC. (EntryHistory)	The calculated row count from the history GL Entry table. This number equals the number of entries in the history table prior to the most recent batch cycle plus the number of entries from the last cycle.
GLEN ROW COUNT - PROD.	The number of rows in the production GL Entry table. This value should match the calculated row count from the history GL Entry table (GLEN SUM (ROW COUNT) CALC).
GLBL ROW COUNT - CALC. (BalanceHistory)	The calculated row count from the history GL Balance table. This value equals the number of balance entries in the history table prior to the most recent batch cycle plus the number from the most recent batch cycle.
GLBL ROW COUNT - PROD.	The number of rows in the production GL Balance table. This number should match the calculated row count from the history GL Balance table (GLBL ROW COUNT - CALC).
ACBL AMOUNT FAILURES (AccountBalanceHistory)	The number of rows in the production GL Account Balance table with balance amounts that failed to match those in the history GL Account Balance table.
GLEC AMOUNT FAILURES (EncumbranceHistory)	The number of rows in the production GL Encumbrance table with amounts that fail to match to those in the history GL Encumbrance table.
ACBL ROW COUNT - CALC. (AccountBalanceHistory)	The calculated row count from the history GL Account Balance table. This number equals the number of entries in the history table prior to the most recent batch cycle plus the number of entries from the most recent cycle.
ACBL ROW COUNT - PROD.	The row count from the production GL Account Balance table. This number should match the calculated row count from the history GL Account Balance table (ACBL ROW COUNT - CALC).
GLEC ROW COUNT - CALC. (EncumbranceHistory)	The calculated row count from the Encumbrance History table. This number equals the number of the previous Encumbrance History table entries plus the number from the most recent batch cycle.
GLEC ROW COUNT - PROD.	The row count from the production GL Encumbrance table. This number should match the calculated row count from the history GL Encumbrance table (GLEC ROW COUNT - CALC).