Search Results rt7_code_id




Overview
Explore in AI Chat

Overview

FV_FACTS_RT7_CODES is a Federal Financials (FV) configuration and reference table that stores authorization code data used by the FACTS II (Federal Agencies' Centralized Trial-Balance System II) reporting process. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the FV schema and is classified as VALID. It functions as the master repository for RT7 authorization codes, which are Treasury-defined borrowing authority and financing source identifiers that federal agencies must associate with their accounting transactions to satisfy Treasury reporting requirements.

Because it is a reference or lookup table with a single-column primary key and no foreign keys pointing outward, a heuristic Data Vault classification of hub is the most appropriate modeling suggestion. The table acts as a hub because RT7_CODE_ID functions as the durable business key that other tables reference. The table's role is administrative rather than transactional: it defines the valid set of RT7 codes that the agency may assign to authorizations, accounts, and ultimately transactions reported through FACTS II.

Key Information Stored

Each row represents a single RT7 authorization code definition scoped to a specific ledger (SET_OF_BOOKS_ID), meaning the same RT7 code can exist independently in multiple sets of books.

  • RT7_CODE_ID — the surrogate primary key (FV_FACTS_RT7_CODES_PK) and the column users most commonly search for. It is also defined as a unique index (FV_FACTS_RT7_CODES_U1 is actually listed as U1 on SET_OF_BOOKS_ID, RT7_CODE; FV_FACTS_RT7_CODES_U2 is on RT7_CODE_ID).
  • SET_OF_BOOKS_ID — identifies the ledger to which the code belongs; together with RT7_CODE forms the business-key candidate (FV_FACTS_RT7_CODES_U1).
  • RT7_CODE — the alphanumeric authorization code value, the human-readable identifier used during data entry and reporting.
  • RT7_CODE_DESCRIPTION — the descriptive text explaining the meaning or purpose of the authorization code.
  • RT7_BORROWING_SOURCE — indicates the borrowing source associated with the authorization, a key Treasury reporting attribute.
  • RT7_AUTHORITY_TYPE — classifies the type of budget or borrowing authority.
  • FACTSII_EDIT_CODE — controls the edit or validation behavior applied when the code is used in FACTS II extracts.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, providing extensibility for agency-specific attributes without schema changes.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns tracking row creation and modification.

Common Use Cases and Queries

The table is primarily queried by code administrators validating code setup and by developers integrating FACTS II reporting. A typical lookup retrieves the description and borrowing source for a given code:

  • Validating that a code exists for a ledger: SELECT rt7_code, rt7_code_description FROM fv.fv_facts_rt7_codes WHERE set_of_books_id = :p_sob AND rt7_code = :p_code;
  • Resolving a code from a transaction join: SELECT c.rt7_code, c.rt7_borrowing_source FROM fv.fv_facts_rt7_codes c, fv.fv_facts_authorizations a WHERE c.rt7_code_id = a.rt7_code_id AND a.set_of_books_id = :p_sob;
  • Reporting all active codes by borrowing source: SELECT rt7_borrowing_source, rt7_code, rt7_code_description FROM fv.fv_facts_rt7_codes ORDER BY rt7_borrowing_source, rt7_code;
  • Extracting agency-specific flexfield data: SELECT rt7_code, attribute_category, attribute1, attribute2 FROM fv.fv_facts_rt7_codes WHERE attribute_category = :p_cat;

Related reporting includes reconciliation of authorizations to RT7 codes and validation of FACTS II extract errors caused by unassigned or invalid codes.

Related Objects

Two documented foreign keys reference the primary key RT7_CODE_ID:

Beyond these, the table relates logically to SET_OF_BOOKS (GL_SETS_OF_BOOKS) via SET_OF_BOOKS_ID, and indirectly to the FACTS II reporting views and concurrent programs that extract authorization data. Standard EBS lookups and value sets referencing RT7_CODE drive data-entry validation in the Federal Financials setup forms. No APIs are dedicated to this table; maintenance is performed through FV setup forms and concurrent processes.