Results for “tot_warrant_amount”

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

Overview

FV_APPROPRIATION_HDR_V is a Federal Financials (FV) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents appropriation header information enriched with the corresponding Treasury Symbol, providing a consolidated, denormalized read model over the appropriation header data stored in the FV schema. Its principal role is to support inquiry, reporting, and integration scenarios in which appropriation balances and warrant, rescission, and deferral totals must be viewed in the context of the Treasury Symbol (also known as the Treasury Account Symbol, or TAS) to which they belong.

The view is documented as based on FV_APPROPRIATION_HDR_V and FV_TREASURY_SYMBOLS. In Oracle EBS Federal Financials, this view is a standard reporting interface used by appropriation and fund control functionality, budget execution reporting, and downstream extracts such as SF-133 and related Treasury reporting. It is not implemented as a stored table; it is a query-only construct intended for SELECT access.

Underlying Base Objects

The view is defined over two documented base objects:

• FV_APPROPRIATION_HDR (aliased FAH) — the appropriation header table holding one row per appropriation, including document, revision, and aggregate amount information.
• FV_TREASURY_SYMBOLS (aliased FTS) — the Treasury Symbol definition table, supplying the readable Treasury Symbol for each appropriation.

The join condition is FAH.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID AND FAH.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID. This composite join key enforces that the Treasury Symbol is resolved within the same set of books as the appropriation header, which is essential in Federal Financials because Treasury Symbols can be defined per set of books. The result set is ordered by FTS.TREASURY_SYMBOL, so consumers receive rows in ascending Treasury Symbol sequence. The view exposes FAH.ROWID as ROW_ID, which identifies the underlying appropriation header row and can be used for row-level identification or updates against the base table.

Key Columns

• ROW_ID — the ROWID of the underlying FV_APPROPRIATION_HDR row; a unique row identifier within the base table.
• APPROPRIATION_ID — the primary identifier of the appropriation record.
• TREASURY_SYMBOL — the human-readable Treasury Symbol drawn from FV_TREASURY_SYMBOLS; the primary reporting dimension of the view.
• TREASURY_SYMBOL_ID — the foreign key linking back to the Treasury Symbol definition.
• SET_OF_BOOKS_ID — the set of books to which the appropriation and Treasury Symbol belong.
• DOCUMENT_NO / REVISION_NO — the appropriation document number and its revision number. REVISION_NO supports versioning of appropriation documents; the highest revision typically represents the current document.
• TOT_APPROPRIATION_AMOUNT, TOT_WARRANT_AMOUNT, TOT_RESCISSION_AMOUNT, TOT_DEFERRAL_AMOUNT — aggregate appropriation, warrant, rescission, and deferral amounts for the appropriation header.
• BU_USER_ID / BU_GROUP_ID, ORG_ID — business unit and organization security/ownership columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, allowing customer-specific appropriation attributes to be reported.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include appropriation status inquiries, Treasury Symbol-based balance summaries, revision tracking, and integration extracts for Treasury reporting. A basic inquiry selecting current appropriation activity by Treasury Symbol might be written as:

• SELECT treasury_symbol, document_no, revision_no, tot_appropriation_amount, tot_warrant_amount FROM fv_appropriation_hdr_v ORDER BY treasury_symbol, document_no, revision_no;
• SELECT treasury_symbol, SUM(tot_appropriation_amount) total FROM fv_appropriation_hdr_v WHERE set_of_books_id = :p_sob GROUP BY treasury_symbol;
• SELECT appropriation_id, document_no, revision_no, tot_rescission_amount, tot_deferral_amount FROM fv_appropriation_hdr_v WHERE treasury_symbol_id = :p_ts_id ORDER BY revision_no DESC;
• SELECT treasury_symbol, attribute_category, attribute1, attribute2 FROM fv_appropriation_hdr_v WHERE org_id = :p_org_id;

The view is read-only in practice and should be queried with appropriate SET_OF_BOOKS_ID, ORG_ID, and Treasury Symbol predicates to bound result sets and honor access controls. Because it joins two base tables and exposes ROWID, it is suitable both for reporting and for identifying the specific appropriation header row to be acted upon in correction or reconciliation processes.