Search Results fun_trx_types_b




Overview
Explore in AI Chat

Overview

FUN_TRX_TYPES_B is a table owned by the FUN schema (Financials Common Modules) that stores the master list of Intercompany transaction types defined within an Oracle E-Business Suite instance. It is the base ("_B") table that drives the Intercompany balancing and invoicing behavior of Oracle Subledger Accounting and the Financials Common Modules, which are shared by Payables, Receivables, Assets, and General Ledger. This object is available in both EBS 12.1.1 and 12.2.2, and in 12.2.2 the table is edition-enabled, as evidenced by the ZD_EDITION_NAME column that participates in every unique key.

From a Data Vault modeling perspective, the metadata classifies this table as a standalone structure. Because the single documented foreign key is a self-descriptive reference to the transaction type identifier itself, this object behaves most naturally as a reference hub or reference satellite — it holds stable, descriptive attributes about a coded Intercompany transaction type that are largely independent of transactional activity. There is no demonstrated link to a second independent business entity within the provided relationship data, which supports the standalone classification.

Key Information Stored

The table contains 29 documented columns. The most significant ones are:

  • TRX_TYPE_ID — the surrogate primary key and the primary business identifier for each Intercompany transaction type. It is also the first column of unique index FUN_TRX_TYPES_B_U1.
  • TRX_TYPE_CODE — the user-visible, human-readable short code used to identify the transaction type for reporting and setup. It is the first column of unique index FUN_TRX_TYPES_B_U2.
  • ZD_EDITION_NAME — the editioning column required in EBS 12.2.x. It is included in both unique indexes (TRX_TYPE_ID, ZD_EDITION_NAME and TRX_TYPE_CODE, ZD_EDITION_NAME), so together they define the true business-key candidate a row must satisfy.
  • ENABLED_FLAG — indicates whether the transaction type is active and available for use.
  • MANUAL_APPROVE_FLAG — controls whether transactions of this type require manual approval.
  • ALLOW_INVOICING_FLAG — determines whether the transaction type is eligible for Intercompany invoicing.
  • ALLOW_INTEREST_ACCRUAL_FLAG — indicates whether interest accrual is permitted for outstanding balances of this type.
  • VAT_TAXABLE_FLAG — indicates whether the transaction type is subject to VAT.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for capturing client-specific configuration.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who-audit columns recording row creation and modification history.

Common Use Cases and Queries

Typical applications include validating Intercompany setup, generating configuration reports, and auditing which transaction types accept invoicing or interest. A common query lists enabled types:

SELECT trx_type_id, trx_type_code FROM fun.fun_trx_types_b
WHERE enabled_flag = 'Y';

For an invoicing-capability report, filter on ALLOW_INVOICING_FLAG = 'Y' and join to FUN_TRX_TYPES_TL (where translations are maintained) to obtain the description. For interest-recalculation audits, filter on ALLOW_INTEREST_ACCRUAL_FLAG = 'Y'.

Related Objects

  • FUN_TRX_TYPES_TL — the translation table that provides the display name for each TRX_TYPE_ID.
  • FUN_TRX_TYPES_VL — the view that combines the base and translation tables for reporting.
  • IGI_EXP_TRX_TYPE — referenced by the documented foreign key FUN_TRX_TYPES_B.TRX_TYPE_ID → IGI_EXP_TRX_TYPE, linking the Intercompany type to its extended transaction type definition.
  • FUN_TRX_TYPES_B — the table is self-referencing via TRX_TYPE_ID, supporting transactional relationships back to itself.
  • FUN_INTERCO_TRX_HEADERS and FUN_INTERCO_TRX_LINES — the transactional tables that reference TRX_TYPE_ID when Intercompany documents are created.
  • IGI Transaction APIs — the public interfaces that consume and validate the TRX_TYPE_CODE configured in this table.