Results for “xla_fv_tc_gl_v”

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

Overview

XLA_FV_TC_GL_V is a Subledger Accounting (XLA) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is one of the family of "FV_TC" views that present subledger journal entry lines in a format compatible with the general ledger interface and diagnostic reporting structures. The prefix "FV" denotes a flexible validation or reporting view, "TC" denotes a trial/consolidated or transfer container presentation, and "_GL" indicates that the projection is aligned to general ledger account balances and journal line attributes. In practice, the view exposes journal header and line identifiers, accounted and entered debit/credit amounts, currency information, code combination identifiers, ledger and operating unit context, and the standard WHO audit columns. Its principal role is to provide a stable, query-friendly projection over the underlying general ledger journal view FV_TC_GL_V so that subledger accounting reconciliation, transfer-to-GL diagnostics, and reporting extensions can be issued without coupling directly to the base view definition. Because the view is defined almost entirely with NULL and TO_NUMBER(NULL)/TO_DATE(NULL) placeholders for subledger-specific attributes, it functions as a GL-centric slice of a larger, multi-source subledger accounting structure.

Underlying Base Objects

The documented metadata identifies a single referenced base object: FV_TC_GL_V, itself a view. XLA_FV_TC_GL_V selects directly from that view and renames only the JE_HEADER_ID and JE_LINE_NUM columns; all remaining columns are passed through or replaced with typed NULL constants. This structure indicates that the FV_TC view family is built as a union-compatible set, where each member projects the same column list but populates only the attributes relevant to its source system. XLA_FV_TC_GL_V therefore contributes the general ledger journal lines to that family, while sibling views populate the subledger accounting event, header, and line identifiers. The view does not carry a direct dependency on base tables such as XLA_AE_HEADERS, XLA_AE_LINES, or GL_JE_LINES in the documented metadata; those relationships are inherited indirectly through FV_TC_GL_V.

Key Columns

• JE_HEADER_ID, JE_LINE_NUM — Journal entry header and line identifiers; the primary means of joining to GL_JE_HEADERS and GL_JE_LINES.
• ACCOUNTED_DR, ACCOUNTED_CR, ENTERED_DR, ENTERED_CR — Accounted and entered debit and credit amounts for the journal line.
• CODE_COMBINATION_ID — Reference to the accounting flexfield combination used by the line.
• CURRENCY_CODE — Currency of the entered amounts.
• APPLICATION_ID, ORG_ID, SET_OF_BOOKS_ID — Owning application, operating unit, and ledger context.
• Subledger placeholders — AEH_ID, AEL_ID, AEL_TABLE, AE_LINE_REFERENCE, TRANSFER_SYSTEM, GL_TRANSFER_STATUS, and ACCOUNTING_COMPLETE are returned as typed NULLs, preserving column-position compatibility with the wider view family.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID support standard EBS auditing and concurrent program traceability.

Common Use Cases and Queries

The view is typically used for reconciliation and diagnostic reporting where GL journal lines must be presented alongside, or in place of, subledger accounting lines. A representative query retrieves journal activity for a ledger and period:

SELECT je_header_id, je_line_num, accounted_dr, accounted_br, entered_dr, entered_cr, currency_code, code_combination_id FROM apps.xla_fv_tc_gl_v WHERE set_of_books_id = :p_ledger AND org_id = :p_org;

Because the subledger-specific columns are NULL, the view is best suited to GL-only extracts, period-end tie-outs between subledger accounting and GL, and union queries against sibling FV_TC views that supply the subledger attributes. Querying it in 12.1.1 and 12.2.2 follows identical syntax, as the view definition is unchanged across those releases.