Search Results fv_transaction_events




Overview
Explore in AI Chat

Overview

FV_TRANSACTION_EVENTS is a configuration table in the Oracle E-Business Suite Federal Financials (FV) module. Its documented purpose is to define transaction events for a given activity in an application. In practical terms, the table stores the setup rules that govern how a specific transaction event — such as a billing, collection, or expenditure event — is accounted for, which transaction codes are permitted, and which receivables, revenue, and charge accounts are derived by default. The table therefore acts as a control point between transaction processing logic and the accounting flexfield, ensuring that federal financial transactions post to the correct Chart of Accounts combination.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault model. This suggests that, from a modeling perspective, the table behaves as an independent reference or configuration entity rather than as a junction or descriptive satellite attached to a larger hub. It carries its own surrogate identity and does not participate in a broad foreign-key web within the documented schema.

Key Information Stored

The table contains 30 documented columns. The primary key, FV_TRANSACTION_EVENTS_PK, is composed of TRANSACTION_EVENT_ID and TRANSACTION_HEADER_ID. A unique index, FV_TRANSACTION_EVENTS_U1, is defined on the same two columns, making this composite the business-key candidate as well as the surrogate identifier in the documented model.

Common Use Cases and Queries

Typical use cases include reviewing accounting defaults before period close, auditing transaction code control settings, and diagnosing posting failures caused by missing or misconfigured account combinations. A common query pattern filters by Chart of Accounts and transaction event:

  • SELECT TRANSACTION_EVENT_ID, TRANSACTION_EVENT, DEFAULT_TRANSACTION_CODE, RECEIVABLE_ACCOUNT_CCID, REVENUE_ACCOUNT_CCID, CHARGE_ACCOUNT_CCID FROM FV_TRANSACTION_EVENTS WHERE CHART_OF_ACCOUNTS_ID = :p_coa_id;
  • Joining RECEIVABLE_ACCOUNT_CCID, REVENUE_ACCOUNT_CCID, or CHARGE_ACCOUNT_CCID to GL_CODE_COMBINATIONS to translate CCIDs into readable segment values for reporting.
  • Filtering on TXN_CODE_REQUIRED = 'Y' to identify events where users must supply a transaction code.

Related Objects

  • GL_MGT_SEG_UPGRADE_H — Referenced by FV_TRANSACTION_EVENTS.CHART_OF_ACCOUNTS_ID, per documented foreign-key metadata.
  • GL_CODE_COMBINATIONS — Resolves the RECEIVABLE_ACCOUNT_CCID, REVENUE_ACCOUNT_CCID, and CHARGE_ACCOUNT_CCID values into account segment combinations.
  • FV_TRANSACTION_HEADERS — The parent transaction header entity implied by TRANSACTION_HEADER_ID.
  • FV_TRANSACTION_CODES — Supplies the transaction code values referenced by DEFAULT_TRANSACTION_CODE and the associated collection and expenditure codes.
  • FV (Federal Financials) accounting and posting programs — Consume these event definitions when generating accounting entries.