Search Results fv_operating_units_u1

Overview

FV.FV_OPERATING_UNITS_ALL is a Federal Financials (FV) application table that serves as the detail table for FV_LEGAL_ENTITIES. It stores the operating unit definition and the corresponding federal accounting attributes required for processing in Oracle U.S. Federal Financials. Operating units in Oracle E-Business Suite represent the business units at which transactions are entered and controlled; in the federal context they carry additional attributes such as Agency Location Codes, interagency pay group settings, disbursement-in-transit configuration, and prepayment and advance tolerances.

Because a row exists for each operating unit defined in the application, and because the table centers on a single business key, the metadata suggests modeling this object as a Data Vault hub, with ORGANIZATION_ID serving as the business key. Related descriptive attributes such as tolerances, flags, and federal identifiers would most naturally be modeled as satellite content attached to that hub. The table is owned by the FV schema and resides in the APPS_TS_TX_DATA tablespace.

Key Information Stored

The table contains 35 columns. Its primary key is the unique index FV_OPERATING_UNITS_U1, defined on ORGANIZATION_ID, which is the multi-organization identifier of the operating unit and the documented business-key candidate as well as the surrogate primary key. The most significant columns include:

• ORGANIZATION_ID — Multi-organization identifier of the operating unit; primary key.
• LEGAL_ENTITY_ID — Legal entity defining column; foreign key to FV_LEGAL_ENTITIES.
• ALC_CODE — Agency Location Code used for federal reporting and Treasury processing.
• RECEIVABLES_TRX_ID — Receivables transaction identifier; foreign key to AR_RECEIVABLES_TRX_ALL.
• PAYABLES_IA_PAYGROUP — Interagency pay group for payables processing.
• SET_OF_BOOKS_ID — Set of Books identifier associated with the operating unit.
• ORG_ID — Organization identifier used for multi-org security.
• DIT_FLAG — Disbursement-in-transit flag.
• ENABLED — Indicates whether Oracle U.S. Federal Financials is enabled.
• FED_EMPLOYER_ID_NUMBER — Federal Employer Identification Number from the Define Federal Options window.
• PREPAYMENT_TOLERANCE_FLAG / PREPAYMENT_TOLERANCE — Prepayment tolerance indicator and value.
• ADVANCE_LIMIT — Advance limit for the operating unit.
• PAYABLES_TOLERANCE_FLAG / PAYABLES_TOLERANCE — Payables tolerance indicator and value.
• REIM_TRANSACTION_SOURCE_ID, REC_DUE_TRANSACTION_TYPE_ID, LIQ_ADV_TRANSACTION_TYPE_ID — Foreign-key style references to transaction source and transaction type definitions used in reimbursement, receivable due, and liquidation of advance processing.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE for audit tracking.

Common Use Cases and Queries

The table is commonly queried to resolve an operating unit to its legal entity, to validate federal attributes before transaction entry, and to drive Treasury and interagency reporting. A typical join pattern follows:

• Join to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to obtain the legal entity name and legal entity attributes for an operating unit.
• Join to HR_OPERATING_UNITS or ORG_ORGANIZATION_DEFINITIONS on ORGANIZATION_ID to obtain the operating unit name and short code for reporting.
• Filter on DIT_FLAG or ENABLED to identify operating units configured for disbursement-in-transit or full federal processing.

Sample query:

• SELECT fou.organization_id, fou.legal_entity_id, fle.legal_entity_name, fou.alc_code, fou.dit_flag, fou.enabled FROM fv.fv_operating_units_all fou, fv.fv_legal_entities fle WHERE fou.legal_entity_id = fle.legal_entity_id ORDER BY fou.organization_id;

Reporting use cases include ALC-driven federal Treasury reporting, prepayment and advance tolerance monitoring, interagency agreement validation, and configuration audits against the Define Federal Options setup.

Related Objects

The following objects are most significant in relation to FV_OPERATING_UNITS_ALL, based on documented foreign keys and common federal application dependencies:

• FV_LEGAL_ENTITIES — Referenced through LEGAL_ENTITY_ID; the master legal entity table for which this is the detail table.
• AR_RECEIVABLES_TRX_ALL — Referenced through RECEIVABLES_TRX_ID; defines Receivables transactions.
• HR_OPERATING_UNITS / ORG_ORGANIZATION_DEFINITIONS — Source of operating unit name and classification for ORGANIZATION_ID.
• GL_SETS_OF_BOOKS — Referenced through SET_OF_BOOKS_ID.
• FND_USER — Referenced by LAST_UPDATED_BY and CREATED_BY.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN.