Results for “fv_be_gl_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_BE_GL_V is an APPS-owned database view within the Federal Financials (FV) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It provides a consolidated reporting and integration surface that joins Budget Execution (BE) transaction detail and header information to the General Ledger journal entries those transactions generate. The "GL" in the name reflects its core purpose: exposing the accounting impact of budgetary transactions alongside the descriptive attributes of the originating chargeback or receipt transaction.

The view is particularly relevant to users searching for the accounting_complete attribute. In FV_BE_GL_V, this column is derived via SUBSTR(FTS.TREASURY_SYMBOL, 1, 30), meaning the value surfaced as ACCOUNTING_COMPLETE is drawn from the treasury symbol associated with the transaction header rather than from a dedicated completion flag. This aliasing is significant for reporting: consumers referencing ACCOUNTING_COMPLETE are in effect reading the treasury symbol, truncated to thirty characters.

Because the view links budgetary execution data to GL_JE_LINES and GL_JE_HEADERS, it supports reconciliation between budget execution activity and posted journal activity, and it carries an explicit APPLICATION_ID constant of 8901 to identify the owning application context.

Underlying Base Objects

FV_BE_GL_V is defined over seven referenced base objects, all exposed through APPS synonyms:

• FV_BE_TRX_DTLS — budgetary transaction detail lines (FBD), supplying transaction identifiers, source, revision, and increase/decrease flag.
• FV_BE_TRX_HDRS — budgetary transaction headers (FBH), supplying document number, transaction date, treasury symbol reference, and document ID.
• FV_BE_TRANSACTION_TYPES — transaction type definitions (FBTT), supplying the appropriation transaction type name.
• FV_BUDGET_LEVELS — budget level definitions (FBL), supplying the applied-to transaction header currency description.
• FV_TREASURY_SYMBOLS — treasury symbol master (FTS), the source of the ACCOUNTING_COMPLETE value.
• GL_JE_LINES — journal entry lines (JEL), supplying accounted and entered debit/credit amounts.
• GL_JE_HEADERS — journal entry headers (JEH), supplying currency code and the header-to-line join.

Joins are keyed on DOC_ID, BUDGET_LEVEL_ID, SET_OF_BOOKS_ID, TRANSACTION_TYPE_ID, and TREASURY_SYMBOL_ID, while the GL linkage uses TO_CHAR(FBD.TRANSACTION_ID) = JEL.REFERENCE_1 combined with JEH.JE_SOURCE = 'BUDGETARY TRANSACTION' and matching ledger and header identifiers.

Key Columns

• ACCOUNTING_COMPLETE — derived from the treasury symbol (first 30 characters); central to completion-oriented reporting.
• CHARGEBACK_NUMBER — the document number from the transaction header.
• TRX_DATE — the header transaction date.
• ACCOUNTED_DR / ACCOUNTED_CR — accounted debit and credit amounts from GL journal lines.
• ENTERED_DR / ENTERED_CR — entered debit and credit amounts from GL journal lines.
• TRX_LINE_TYPE_NAME — appropriation transaction type name.
• SET_OF_BOOKS_ID, JE_HEADER_ID, JE_LINE_NUM, CODE_COMBINATION_ID — GL accounting identifiers.
• CURRENCY_CODE — journal currency from GL_JE_HEADERS.
• APPLICATION_ID — constant 8901 identifying the application context.

Common Use Cases and Queries

Typical uses include reconciling budgetary transactions to their GL postings, auditing accounting completion by treasury symbol, and extracting debit/credit balances by set of books. A representative query:

• SELECT chargeback_number, trx_date, accounting_complete, accounted_dr, accounted_cre FROM fv_be_gl_v WHERE set_of_books_id = :ledger_id AND trx_date BETWEEN :start_date AND :end_date;
• Filtering on accounting_complete to group activity by treasury symbol.
• Summing accounted_dr and accounted_cr against je_header_id to verify journal balance.