Results for “interagency_flag”

8 results




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

Overview

FV_REPORT_DEFINITIONS is a Federal Financials (FV) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the data elements required to generate two statutory U.S. federal reports: the SF 1081 Voucher and Schedule of Withdrawals and Credits and the FMS Form 224 Statement of Transactions. Each row defines a named report definition that governs how transactions are selected, summarized, and formatted for those outputs, including which ledger is interrogated, which account segments participate, and which report-specific flags apply.

Owned by the FV schema and documented as VALID in ETRM, the table comprises 60 columns. Its primary key is FV_REPORT_DEFINITIONS_PK, defined on the single column FEDERAL_RPT_ID. A unique index, REPORT_DEFINITIONS_U1 (FEDERAL_RPT_ID), provides the same business-key guarantee. From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning: it hangs off GL_SETS_OF_BOOKS_11I via SET_OF_BOOKS_ID, making the ledger the natural hub-like anchor, while the substantive descriptive and flag attributes reside on this table as a satellite of the ledger and the report identifier.

Key Information Stored

The table mixes identifying keys, report behavior flags, and a flexible account-segment specification:

  • FEDERAL_RPT_ID — surrogate primary key and the unique business identifier for a report definition; it is surfaced as a foreign key from FV_SF224_TEMP, linking temporary SF 224 report data back to its governing definition.
  • SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I, establishing the ledger whose balances and transactions the definition applies to.
  • ORG_ID and DESCRIPTION — the operating unit context and the human-readable name of the definition.
  • INTERAGENCY_FLAG, SF224_FLAG, and D_R_FLAG — control flags determining interagency processing, SF 224 eligibility, and debit/credit handling respectively.
  • SEGMENT1 through SEGMENT30 — a wide array of accounting flexfield segment values used to scope which accounts are included in the report.
  • ACCOUNT and AGENCY_LOCATION_CODE — the consolidated account designation and the agency location code used by Treasury reporting.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Oracle's standard descriptive flexfield columns for site-specific extension data.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard WHO-column lineage.

Common Use Cases and Queries

Typical usage centers on setup validation and report reconciliation. Federal Financials administrators query this table to confirm which definitions exist for a ledger before running the SF 1081 or SF 224 processes, and auditors reconcile flag settings against agency policy. A representative lookup follows:

  • SELECT federal_rpt_id, description, set_of_books_id, sf224_flag, interagency_flag, d_r_flag FROM fv.fv_report_definitions WHERE set_of_books_id = :ledger_id;
  • Joining to the ledger to obtain ledger name and currency: SELECT frd.federal_rpt_id, gl.name FROM fv.fv_report_definitions frd, gl.gl_sets_of_books gl WHERE gl.set_of_books_id = frd.set_of_books_id;
  • Tracing generated SF 224 temporary lines back to their definition: SELECT t.federal_rpt_id, d.description FROM fv.fv_sf224_temp t, fv.fv_report_definitions d WHERE t.federal_rpt_id = d.federal_rpt_id;

Because the table carries thirty segment columns plus fifteen attributes, reporting queries often search for definitions whose configured segments match a given accounting combination, or export the entire definition set for migration between environments and ledgers.

Related Objects

  • GL_SETS_OF_BOOKS_11I — referenced via FV_REPORT_DEFINITIONS.SET_OF_BOOKS_ID; the ledger anchor for every definition.
  • FV_SF224_TEMP — references FV_REPORT_DEFINITIONS.FEDERAL_RPT_ID; holds temporary SF 224 Statement of Transactions data.
  • FV_REPORT_DEFINITIONS_PK — the primary key constraint on FEDERAL_RPT_ID.
  • REPORT_DEFINITIONS_U1 — the unique index enforcing the FEDERAL_RPT_ID business key.
  • GL_CODE_COMBINATIONS — the accounting flexfield source underlying the SEGMENT1–SEGMENT30 and ACCOUNT columns.
  • HR_OPERATING_UNITS — the organization context implied by ORG_ID.
  • FND_DESCRIPTIVE_FLEXS / FND_FLEX_VALUES — the flexfield infrastructure supporting ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.