Search Results fv_facts_authorizations_u2

Overview

FV.FV_FACTS_AUTHORIZATIONS is the base table that underpins the Other Authorizations window within Oracle E-Business Suite. It functions as one of the detail tables accessed through the Define Appropriation Parameters form, and its specific purpose is to persist the "other authorization" records associated with a given Treasury symbol. In the Federal financials (FV) schema, this table therefore serves as a transactional store bridging a Treasury symbol definition to the authorization amounts and RT7 classification codes that apply to it.

The table is owned by the FV schema and is marked VALID in the ETRM reference for 12.1.1 and 12.2.2. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are held in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is standalone — the table does not sit downstream of a composite parent-child chain but rather records authorization facts keyed to a single entity. This label is offered as a suggestion; the physical table is a conventional EBS detail table with standard WHO columns and a descriptive flexfield.

Key Information Stored

The table contains 26 documented columns. The most significant are summarized below.

• AUTHORIZATION_ID (NUMBER 15) — the unique, system-generated identifier and the surrogate primary key of the table (FV_FACTS_AUTHORIZATIONS_PK).
• TREASURY_SYMBOL_ID (NUMBER 15) — foreign key to FV_TREASURY_SYMBOLS; identifies the Treasury symbol to which the authorization row belongs.
• RT7_CODE_ID (NUMBER) — foreign key to FV_FACTS_RT7_CODES; the RT7 code classifying the authorization.
• SET_OF_BOOKS_ID (NUMBER 15) — the set of books (ledger) identifier governing the record.
• PRECLOSING_UNEXPENDED_AMT (NUMBER) — the preclosing undisbursed amount recorded for the authorization.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns capturing row creation and last modification context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments, each VARCHAR2(150), available for client-specific extension.

Two unique indexes act as business-key candidates. FV_FACTS_AUTHORIZATIONS_U1 enforces uniqueness on the combination (TREASURY_SYMBOL_ID, RT7_CODE_ID), establishing that a given Treasury symbol may hold only one authorization row per RT7 code. FV_FACTS_AUTHORIZATIONS_U2 enforces uniqueness on AUTHORIZATION_ID alone. The user query "fv_facts_authorizations_u2" points directly at this second unique index, which physically guards the surrogate key.

Common Use Cases and Queries

Typical usage centers on reporting other authorizations by Treasury symbol, reconciling preclosing undisbursed balances, and joining authorizations to their RT7 classifications.

• Retrieve all authorizations for a Treasury symbol:

  SELECT AUTHORIZATION_ID, TREASURY_SYMBOL_ID, RT7_CODE_ID, PRECLOSING_UNEXPENDED_AMT FROM FV.FV_FACTS_AUTHORIZATIONS WHERE TREASURY_SYMBOL_ID = :symbol_id;

• Join to the RT7 code definition to produce a human-readable classification report, joining on FV_FACTS_AUTHORIZATIONS.RT7_CODE_ID = FV_FACTS_RT7_CODES.RT7_CODE_ID.
• Look up a single record by primary key — the pattern most aligned with the U2 index:

  SELECT * FROM FV.FV_FACTS_AUTHORIZATIONS WHERE AUTHORIZATION_ID = :authorization_id;

• Aggregate preclosing undisbursed amounts by set of books for period-end reporting.
• Query descriptive flexfield segments (ATTRIBUTE_CATEGORY, ATTRIBUTE1…15) for client-extended reporting.

Because U1 and U2 are unique, duplicate-insert checks and upsert logic should reference them to avoid constraint violations.

Related Objects

• FV.FV_TREASURY_SYMBOLS — referenced via TREASURY_SYMBOL_ID; the parent of each authorization.
• FV.FV_FACTS_RT7_CODES — referenced via RT7_CODE_ID; supplies the RT7 classification.
• FV_FACTS_AUTHORIZATIONS_PK — the primary key constraint on AUTHORIZATION_ID.
• FV_FACTS_AUTHORIZATIONS_U1 — unique index on (TREASURY_SYMBOL_ID, RT7_CODE_ID).
• FV_FACTS_AUTHORIZATIONS_U2 — unique index on AUTHORIZATION_ID.
• Define Appropriation Parameters form — the EBS form whose Other Authorizations window writes to this table.
• FND_USER / FND_LOGINS — referenced by the WHO columns CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

These relationships reflect the documented foreign keys and indexes; additional dependencies may exist through concurrent programs and reporting views in the FV module.