Search Results fun_system_options




Overview
Explore in AI Chat

Overview

FUN_SYSTEM_OPTIONS is a Financials Common Modules (FUN) configuration table that stores setup options applied at the system level across the entire Oracle E-Business Suite instance. Unlike most EBS configuration tables, which retain one row per operating unit, ledger, or responsibility, FUN_SYSTEM_OPTIONS is guaranteed to contain exactly one row. This singleton design reflects its scope: the values stored here act as instance-wide defaults for currency, transaction thresholds, exchange rate handling, document numbering, batch processing behavior, rejection controls, and intercompany/intracompany processing. Administrators maintain these values through the Financials system options setup flow, and virtually every financial transaction processing path consults the table — directly or through cached lookups — to determine how to default and validate transaction attributes.

The documented physical schema is owned by the FUN schema and comprises 37 columns in ETRM 12.2.2, with a unique index FUN_SYSTEM_OPTIONS_U1 defined on (SYSTEM_OPTION_ID, ZD_EDITION_NAME). From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. In Data Vault terms it is best treated as a satellite-style reference holding descriptive setup attributes keyed by a single business identifier, rather than a true hub or link, since no meaningful many-to-many or multi-entity relationship originates here.

Key Information Stored

The columns below represent the functionally significant attributes; the remaining columns are primarily descriptive flexfield segments (ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY) and standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

  • SYSTEM_OPTION_ID — surrogate primary key and the first component of the unique index FUN_SYSTEM_OPTIONS_U1; functionally the singleton row identifier.
  • ZD_EDITION_NAME — editioning component of the unique index FUN_SYSTEM_OPTIONS_U1; together with SYSTEM_OPTION_ID it forms the documented business-key candidate under the 12.2 online patching editioning model.
  • DEFAULT_CURRENCY — the functional/default currency applied to transactions when no other currency is specified.
  • MIN_TRX_AMT and MIN_TRX_AMT_CURRENCY — minimum transaction amount threshold and the currency in which that threshold is expressed.
  • EXCHG_RATE_TYPE — default exchange rate type used for currency conversion.
  • NUMBERING_TYPE — controls sequential versus manual document numbering behavior.
  • ALLOW_REJECT_FLAG — determines whether transactions may be rejected in the approval workflow.
  • GL_BATCH_FLAG and APAR_BATCH_FLAG — govern batch processing behavior for General Ledger and Payables/Receivables respectively.
  • DEFAULT_AR_TRX_TYPE_ID, DEFAULT_CM_TRX_TYPE_ID, and DEFAULT_MEMO_LINE_ID — default transaction type and memo line identifiers used when creating AR, credit memo, and memo line records.
  • INTECO_CALENDAR and INTECO_PERIOD_TYPE — the calendar and period type applied to intercompany processing.
  • ALLOW_INTER_INTRA — controls whether intercompany and intracompany transactions are permitted.

Common Use Cases and Queries

Typical uses include validating posting-level defaults, auditing configuration drift between environments, and joining system-level defaults into transaction reports. Because the table holds a single row, queries are simple and can be joined unconditionally.

  • Configuration audit — retrieve all functional defaults: SELECT default_currency, exchg_rate_type, numbering_type, allow_reject_flag FROM fun.fun_system_options;
  • Threshold validation — confirm the minimum transaction amount and its currency: SELECT min_trx_amt, min_trx_amt_currency FROM fun.fun_system_options;
  • Intercompany setup review — inspect inteco_calendar, inteco_period_type, and allow_inter_intra.
  • Default transaction type reporting — resolve default_ar_trx_type_id and default_cm_trx_type_id against transaction type definitions to produce human-readable labels.
  • Date-tracked change analysis — compare last_update_date and last_updated_by to determine when system options were most recently changed.

Related Objects

The documented foreign key establishes that FUN_SYSTEM_OPTIONS.SYSTEM_OPTION_ID references CS_SYSTEM_OPTIONS, making that table the principal parent reference. Additional significant relationships arise from the default identifier columns and shared FUN configuration, including the AR transaction types referenced by DEFAULT_AR_TRX_TYPE_ID and DEFAULT_CM_TRX_TYPE_ID, memo line definitions referenced by DEFAULT_MEMO_LINE_ID, intercompany calendar definitions matching INTECO_CALENDAR, and standard EBS reference objects such as FND_CURRENCIES for currency validation. Together these dependencies confirm the table's role as a central default provider within the FUN configuration layer.