Search Results fii_ar_dso_setup

Overview

FII_AR_DSO_SETUP is a configuration table within the Oracle E-Business Suite Financial Intelligence (FII) product family, historically associated with the Daily Business Intelligence (DBI) for Receivables reporting infrastructure. Its documented purpose is to store setup data that governs Days Sales Outstanding (DSO) calculations and related Receivables performance metrics exposed through DBI dashboards. The table resides in the FII schema and, in the documented ETRM 12.1.1 physical schema, contains nine columns. Notably, the ETRM metadata records the FII product as obsolete and states that the object is "Not implemented in this database," meaning it is a legacy artifact that may not exist in all environments — particularly in later 12.2.2 installations where DBI-Receivables functionality was superseded by Oracle BI Applications and newer Financial Intelligence offerings. Under the heuristic Data Vault classification derived from its foreign key structure, FII_AR_DSO_SETUP is modeled as a standalone object — neither a hub, link, nor satellite in the strict sense, since it participates in no documented FK relationships. This suggests it functions as an independent reference or lookup table whose values are consumed directly by DBI processing logic rather than through relational joins to transactional entities.

Key Information Stored

The table's most significant columns, based on the documented schema, are organized around a small set of business attributes and standard EBS audit columns:

• DSO_TYPE — The primary key column (constraint SYS_C00185121) and the principal business discriminator. It identifies the category or variant of DSO configuration being defined, such as a specific DSO calculation method or reporting dimension.
• DSO_VALUE — Stores the configuration value associated with the given DSO_TYPE, such as a threshold, numerator/denominator selection, or parameter used in the DSO formula.
• DSO_GROUP — Groups related DSO_TYPE entries, enabling logical partitioning of setup rows for different business units, ledger configurations, or reporting scenarios.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework to detect concurrent updates.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the setup row was inserted.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and the login session responsible for it.

The surrogate primary key is SYS_C00185121, which enforces uniqueness on DSO_TYPE. No separate unique business-key index is documented beyond this constraint, so DSO_TYPE serves as both the surrogate and the natural business key candidate.

Common Use Cases and Queries

Because this is a setup table, its typical usage involves reading configuration values that drive DSO reporting. A representative query to enumerate all configured DSO variants is:

• SELECT DSO_TYPE, DSO_VALUE, DSO_GROUP FROM FII.FII_AR_DSO_SETUP ORDER BY DSO_GROUP, DSO_TYPE;
• SELECT DSO_VALUE FROM FII.FII_AR_DSO_SETUP WHERE DSO_TYPE = :p_type AND DSO_GROUP = :p_group;

Common scenarios include verifying DSO calculation parameters before running DBI-Receivables collection programs, auditing changes to DSO setup through the LAST_UPDATE_DATE and LAST_UPDATED_BY columns, and exporting setup rows during environment migration or cloning activities. In environments where the table is not implemented, DBAs should confirm its absence via SELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = 'FII_AR_DSO_SETUP'; before attempting any data retrieval, as queries against a non-existent object will raise ORA-00942.

Related Objects

The ETRM metadata documents no foreign key relationships for FII_AR_DSO_SETUP, consistent with its standalone Data Vault classification. Consequently, the table does not reference or depend on other tables through declarative constraints. Related objects therefore must be inferred from the broader FII/DBI-Receivables ecosystem rather than from the documented FK structure:

• FII_AR_DSO_FACT — The probable fact table consuming DSO setup values during metric computation (inferred; not documented in the provided metadata).
• FII_AR_DSO_GT — A global temporary table often used in the same DBI collection flow (inferred).
• DBI_AR_* views — Receivables dashboard views that present DSO results to end users (inferred).
• FND_* audit columns reference — CREATED_BY and LAST_UPDATED_BY logically reference FND_USER.USER_ID, though no database constraint is documented.

Given the FII product's obsolete status, implementers should treat any dependency list for this table as historical and validate against the actual database inventory in their 12.1.1 or 12.2.2 instance.