The G/L Link to Account Ledger Control Report

You use the G/L Link to Acct Ledger Control Report (R48S720) to verify that the information contained in the G/L Link table (F48S912) accurately represents the information that has been written to the Account Ledger table (F0911).

The report analyzes records in the F48S912 table that are grouped by billing control ID. The report compares all of the records in the group to the first record in the group and prints an error message when the accounting information for any record in the group does not match the accounting information for the first record in the group. The accounting information is stored in these fields:

• Account ID (AID)

• Business Unit (MCU)

• Object Account (OBJ)

• Subsidiary (SUB)

• Subledger - G/L (SBL)

• Subledger Type (SBLT)

• Batch Number (ICU)

As the report analyzes each F48S912 record, it adds the values in the Amount field (AA) and the Units field (U) and calculates the total amount and units for the group.

The report verifies that every record in the F48S912 table has a corresponding record in the F0911 table and verifies that the total amount and units for each F48S912 group equals the values stored in the Amount field (AA) and Units field (U) for the corresponding F0911 record. When the total amount and units are not equal, the report displays an error message and displays the difference between the totals amount and units from the F48S912 table and the amount and units from the F0911 table.

The report also displays an error when the accounting information for the F48S912 group does not match the accounting information for the F0911 record.

You use data selection to specify which records to evaluate. However, including some records from a certain batch number and excluding other records from the same batch might produce false error messages on the report. Oracle recommends that you limit the data selection to the batch number or batch date.