Search Results fv_operating_units_all




Overview
Explore in AI Chat

Overview

FV_OPERATING_UNITS_ALL is a Federal Financials (FV) configuration table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores operating unit-level setup information that drives federal receivables and payables processing behavior, including transaction type defaults, reimbursement sources, tolerance thresholds, and cash confirmation accounts. Operating units are the organizational partitions that determine which transactions a user can access and how those transactions are processed across Oracle Receivables, Oracle Payables, and Federal Financials-specific logic.

From a Data Vault modeling perspective, the heuristic classification of this table is standalone. It functions most closely as a hub-like reference entity keyed on ORGANIZATION_ID, with some attributes exhibiting historical or descriptive characteristics typical of satellites. The standalone designation reflects that the table primarily holds its own configuration data rather than acting as a pure junction between other core entities.

Key Information Stored

The table contains 35 documented columns. The most frequently referenced attributes include:

Common Use Cases and Queries

Configuration and support teams query this table to verify operating unit setup before troubleshooting federal receivables or payables processing. A typical retrieval pattern joins the operating unit to its legal entity and set of books:

  • Reporting on all active operating units: SELECT organization_id, legal_entity_id, set_of_books_id FROM fv_operating_units_all WHERE enabled = 'Y';
  • Identifying transaction-type defaults for a given operating unit by joining RECEIVABLES_TRX_ID to AR_RECEIVABLES_TRX_ALL.
  • Validating ALC_CODE and DIT configuration ahead of cash confirmations.

Because the table carries LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY, audit and change-tracking reports are also common.

Related Objects

  • FV_LEGAL_ENTITIES — joined via FV_OPERATING_UNITS_ALL.LEGAL_ENTITY_ID.
  • AR_RECEIVABLES_TRX_ALL — joined via RECEIVABLES_TRX_ID.
  • RA_BATCH_SOURCES_ALL — joined via REIM_TRANSACTION_SOURCE_ID.
  • RA_CUST_TRX_TYPES_ALL — joined via REC_DUE_TRANSACTION_TYPE_ID and LIQ_ADV_TRANSACTION_TYPE_ID.
  • HR_OPERATING_UNITS — the standard operating unit definition source in EBS.