Search Results agb_agb_uk

Overview

The OKL_ACC_GROUP_BAL table is a core data object within Oracle E-Business Suite's Leasing and Finance Management (OKL) module. It serves as the central repository for storing account group balance information. In the context of lease and finance contracts, an account group is a logical collection of accounts (e.g., for principal, interest, fees) associated with a contract. This table maintains historical and current balance snapshots for these groups, which is fundamental for financial reporting, revenue recognition, and portfolio analysis. Its role is critical for tracking the financial performance and status of leasing contracts over time, enabling accurate period-end closing and balance inquiries.

Key Information Stored

The table's structure is designed to capture balance information at a specific point in time for a given contract and account group. Based on the provided metadata, the primary components of the data stored include:

• KHR_ID: A foreign key column linking to the OKL_K_HEADERS table, which is the master table for lease contracts. This associates every balance record with a specific contract.
• DATE_BALANCE: The date for which the balance snapshot is recorded. Together with KHR_ID, this forms part of the primary key (AGB_AGB_UK), indicating that balances are tracked over time for each contract.
• ACC_GROUP_ID: A foreign key column, likely referencing a table defining account groups (e.g., OKL_ACC_GROUPS or similar). This identifies the specific financial account group (e.g., receivable, unearned income) for which the balance is stored.
• While not explicitly listed in the brief excerpt, typical balance columns would also be present, such as amounts for opening balance, period activity, and closing balance, denominated in functional and potentially transaction currency.

Common Use Cases and Queries

This table is primarily accessed for financial reporting and reconciliation. A common use case is generating a trial balance or account analysis report for a specific lease contract or a portfolio of contracts as of a given date. Accountants may query it to verify the ending balances for revenue or receivable accounts during month-end close. System processes within the OKL module automatically populate and update this table during transaction posting and period-end accrual runs.

A fundamental sample SQL pattern retrieves balances for a contract on a specific date:

SELECT khr_id, date_balance, acc_group_id, balance_amount
FROM okl. okl_acc_group_bal
WHERE khr_id = &contract_id
AND date_balance = TO_DATE('&balance_date','DD-MON-YYYY')
ORDER BY acc_group_id;

Another typical reporting query aggregates total balances by account group across a portfolio for financial statement preparation:

SELECT acc_group_id, SUM(balance_amount) as total_balance
FROM okl. okl_acc_group_bal
WHERE date_balance = (SELECT MAX(date_balance) FROM okl_acc_group_bal)
GROUP BY acc_group_id;

Related Objects

The OKL_ACC_GROUP_BAL table exists within a key network of related objects in the OKL schema, as indicated by its foreign keys:

• OKL_K_HEADERS: The primary foreign key relationship. Every record in OKL_ACC_GROUP_BAL must correspond to a valid contract header in this table. Joining to OKL_K_HEADERS is essential for reporting that includes contract details like number, customer, and product.
• OKL_ACC_GROUPS (or similarly named table): The foreign key on ACC_GROUP_ID implies a lookup table that defines the valid account groups, their descriptions, and their accounting classifications. This relationship provides the descriptive meaning for the numeric ACC_GROUP_ID.
• The table is also likely referenced by various OKL financial reports, views (such as OKL_ACC_GROUP_BAL_V), and public APIs used for balance inquiries and data extraction.