Search Results gl_bc_packets

Overview

The GL_BC_PACKETS table is a core transactional table within the Oracle E-Business Suite General Ledger module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to function as a budgetary control queue, serving as the central staging area for all transactions that require funds checking and reservation. When budgetary control is enabled for a ledger, transactions from subledgers and the General Ledger itself are inserted into this table. A concurrent process then reads these packets, performs the funds check against defined budgets and control rules, and updates their status. This mechanism ensures that expenditures and commitments do not exceed authorized budgetary limits, enforcing financial compliance before journal entries are finally posted.

Key Information Stored

The table stores a comprehensive record of each transaction requiring funds checking. Key columns include identifiers for the source transaction, such as JE_HEADER_ID, JE_LINE_NUM, JE_BATCH_ID, and REQUEST_ID. It holds critical accounting information like LEDGER_ID, CODE_COMBINATION_ID, PERIOD_NAME, CURRENCY_CODE, and the transaction AMOUNT. The budgetary control context is defined by columns like BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID, and FUNDING_BUDGET_VERSION_ID. Most importantly, the STATUS column tracks the result of the funds check (e.g., 'P' for Pending, 'A' for Approved, 'F' for Failed), while PACKET_ID uniquely identifies a group of related transactions processed together.

Common Use Cases and Queries

The primary use case is troubleshooting budgetary control failures and monitoring the funds reservation process. Common queries involve identifying pending or failed transactions, tracing the budgetary impact of a specific journal entry, or analyzing reservations for a period. For example, to find failed transactions for a ledger, one might query:

• SELECT packet_id, je_header_id, je_line_num, status, status_verified FROM gl_bc_packets WHERE ledger_id = 1001 AND status = 'F';

To analyze the budgetary control queue's contents before a funds check run, administrators often review pending packets:

• SELECT packet_id, COUNT(*), SUM(amount) FROM gl_bc_packets WHERE status = 'P' GROUP BY packet_id;

Reporting use cases include reconciling reserved funds to general ledger balances and auditing the sequence of funds check events for specific documents.

Related Objects

As indicated by its foreign keys, GL_BC_PACKETS is integrally linked to core General Ledger and application foundation tables. It directly references journal entry objects (GL_JE_HEADERS, GL_JE_LINES, GL_JE_BATCHES), the accounting flexfield (GL_CODE_COMBINATIONS), and ledger setup (GL_LEDGERS). Its budgetary control function ties it to GL_BUDGET_VERSIONS and GL_ENCUMBRANCE_TYPES. The table is also linked to the concurrent manager (FND_CONCURRENT_REQUESTS) and currencies (FND_CURRENCIES). Key related APIs include the budgetary control public APIs and the standard funds check process that reads from and updates this table.