Search Results avail_posted_balance

Overview

APPS.GL_BC_PACKETS_V is a supplementary Oracle E-Business Suite view in the General Ledger schema, registered under FND Design Data as SQLGL.GL_BC_PACKETS_V. In Oracle EBS 12.1.1 and 12.2.2, it serves as a forms-support view that presents budget and encumbrance packet information in a denormalized, reporting-friendly structure. The view consolidates transactional packet rows from GL_BC_PACKETS with descriptive attributes from set of books, journal sources, categories, budget versions, and encumbrance types, eliminating the need for forms code to perform multiple joins.

Because the view is classified as a supplementary view used to simplify forms coding, Oracle explicitly warns that it should not be queried or altered directly. Its definition may change substantially across minor or major releases. For this reason, it is best treated as a diagnostic or reverse-engineering target rather than a stable integration interface. Reporting solutions should instead target the documented base tables.

The view is particularly relevant to users searching for budget_total_balance, a column that aggregates posted, approved, and pending budget amounts into a single total for funds-checking and budget review purposes.

Underlying Base Objects

The documented base objects underlying GL_BC_PACKETS_V are:

• GL_BC_PACKETS — the primary packet table holding budget/encumbrance check rows.
• GL_BUDGET_VERSIONS — supplies budget version names.
• GL_ENCUMBRANCE_TYPES — supplies encumbrance type names.
• GL_JE_BATCHES — provides journal batch context.
• GL_JE_CATEGORIES — supplies journal category names.
• GL_JE_HEADERS — provides journal header attributes.
• GL_JE_SOURCES — supplies journal source names.
• GL_LOOKUPS — resolves lookup codes into meanings.
• GL_SUMMARY_TEMPLATES — supplies summary template context.

These objects are referenced through APPS synonyms, meaning the view resolves base tables owned by the GL schema. The view effectively joins packet records to their descriptive dimensions, producing a wide projection suitable for a single-block forms query.

Key Columns

Important columns include:

• PACKET_ID, SET_OF_BOOKS_ID, CODE_COMBINATION_ID — primary identifiers linking the packet to ledger and account.
• JE_SOURCE_NAME, JE_CATEGORY_NAME — descriptive journal attributes.
• ACTUAL_FLAG, PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM — accounting period context.
• CURRENCY_CODE, STATUS_CODE, RESULT_CODE — currency and funds-check outcome.
• BUDGET_VERSION_ID, FUNDING_BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID, TEMPLATE_ID — budget and encumbrance configuration.
• ENTERED_DR, ENTERED_CR — entered debit and credit amounts.
• ACCOUNTED_DR, ACCOUNTED_CR — accounted amounts stored as VARCHAR2(40).
• BUDGET_POSTED_BALANCE, BUDGET_APPROVED_BALANCE, BUDGET_PENDING_BALANCE — component balances.
• BUDGET_TOTAL_BALANCE — the aggregate budget balance exposed as VARCHAR2(40), representing the combined posted, approved, and pending budget position for the packet.
• ACTUAL_TOTAL_BALANCE, ENC_TOTAL_BALANCE — corresponding actual and encumbrance totals.
• AVAIL_POSTED_BALANCE, AVAIL_APPROVED_BALANCE, AVAIL_PENDING_BALANCE, AVAIL_TOTAL_BALANCE — funds availability figures.

Common Use Cases and Queries

Typical uses include diagnosing funds-check failures, auditing budget packet contents, and reconciling budget versus actual balances at the account and period level. A representative query filtering on the balance column follows:

• SELECT packet_id, set_of_books_id, code_combination_id, period_name, budget_version_id, budget_total_balance FROM apps.gl_bc_packets_v WHERE budget_total_balance IS NOT NULL AND period_name = :period;

Because balances are stored as VARCHAR2, numeric comparisons require explicit conversion:

• SELECT packet_id, TO_NUMBER(budget_total_balance) AS budget_total FROM apps.gl_bc_packets_v WHERE set_of_books_id = :sob AND TO_NUMBER(budget_total_balance) <> 0;

Given Oracle's documented warning, these queries are appropriate for support and diagnostic work. Production reporting should be redirected to GL_BC_PACKETS and its associated base tables.