Search Results header_attribute15

Overview

FV_BE_BA_FD_HDR_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, belonging to the FV – Federal Financials product family. Its primary documented purpose is to serve as a transaction extract header source for Subledger Accounting (SLA), allowing the accounting engine to identify the originating source transactions for federal budgetary and fund control processing. In Oracle EBS 12.1.1 and 12.2.2, SLA creates accounting entries through the Create Accounting program, which reads extract views of this kind to resolve the header-level attributes, event identifiers, and distribution accounts required for journal creation.

The view presents one row per accounting event, combining event metadata from XLA_EVENTS_GT with document header details, document line details, chart of accounts information, and ledger currency. It is a header-level extract, meaning the grain is the document or event, not the accounting line. Downstream SLA extract logic joins this header view with corresponding line-level views to assemble complete journal entry headers and lines. Because federal financials tracking requires both budgetary and proprietary accounting, the view supplies segmentation and fund-control attributes consumed by the FV_BE_XLA_PKG package that performs the actual SLAM (Subledger Accounting Method) processing.

Underlying Base Objects

The documented base objects referenced by this view are:

• FV_BE_TRX_HDRS (synonym) – source transaction headers, contributing DOC_ID, DOC_NUMBER, REVISION_NUM, TREASURY_SYMBOL_ID, FUND_VALUE, BUDGET_LEVEL_ID, TRANSACTION_DATE, SEGMENT1 through SEGMENT30, APPROVAL_ID, APPROVED_BY_USER_ID, PARENT_DOC_ID, and ATTRIBUTE1 through ATTRIBUTE10 or higher.
• FV_BE_TRX_DTLS (synonym) – source transaction details, supplying QUARTER_NUM and GL_DATE.
• FV_BE_XLA_PKG (package) – provides the GET_CCID function used to derive the DISTRIBUTION_ACCOUNT from the SQLGL/GL# chart of accounts and budgeting segments.
• FV_FUND_PARAMETERS (synonym) – fund parameter configuration used in budget-level and fund value validation.
• FV_TREASURY_SYMBOLS (synonym) – lookup for treasury symbol values referenced by TREASURY_SYMBOL_ID.
• GL_LEDGERS (synonym) – supplies currency code for the ledger identified by SET_OF_BOOKS_ID.
• XLA_EVENTS_GT (synonym) – the global temporary event table that provides EVENT_ID and drives the extract grain for SLA.

The view therefore acts as a denormalized header projection joining federal budgetary transaction data with the SLA event and ledger context.

Key Columns

• EVENT_ID – the SLA accounting event identifier, the join key back to XLA_EVENTS_GT and to the accounting lines.
• DOC_ID, DOC_NUMBER, REVISION_NUM – identify the federal budget or fund document and its revision.
• QUARTER_NUM, GL_DATE, TRANSACTION_DATE – period and date attributes used for accounting date derivation.
• DISTRIBUTION_ACCOUNT – a concatenated accounting flexfield CCID returned by FV_BE_XLA_PKG.GET_CCID, resolved from the budgeting segments.
• LEDGER_ID (SET_OF_BOOKS_ID) and CURRENCY_CODE – the ledger and its currency from GL_LEDGERS.
• HEADER_SEGMENT1 through HEADER_SEGMENT30 – the full 30-segment key flexfield of the source header, mapped for SLA segment rules.
• HEADER_ATTRIBUTE1 onward, SOURCE, APPROVAL_ID, APPROVED_BY_USER_ID, OLD_DOC_NUMBER, PARENT_DOC_ID, BUDGET_LEVEL_ID, TREASURY_SYMBOL_ID, and FUND_VALUE – descriptive and control attributes carried into the extract.

The word advance_type does not appear as a column of this view; advance-type information, if required, would normally be sourced from related FV advance tables or header descriptive flexfield attributes rather than this header extract.

Common Use Cases and Queries

Typical uses include troubleshooting Create Accounting output, verifying that SLA is receiving the correct header segments and distribution account, and supporting federal audit reconciliations between source documents and journal entries. A representative query retrieves header extract rows for a given ledger:

• SELECT event_id, doc_number, transaction_date, distribution_account, ledger_id, currency_code FROM fv_be_ba_fd_hdr_v WHERE ledger_id = :p_ledger_id AND transaction_date BETWEEN :p_start AND :p_end;
• SELECT h.event_id, h.doc_number, h.header_segment1, h.header_segment2, h.fund_value FROM fv_be_ba_fd_hdr_v h WHERE h.event_id = :p_event_id; to trace a single accounting event.
• Joining the view to XLA_EVENTS_GT and salary or expense line extracts to build full SLA journal headers.

Because the view is read-only and optimized for extract rather than ad hoc reporting, direct queries should be limited to diagnostic purposes; production accounting flows rely on the package-driven SLA process.