Search Results dso_type




Overview
Explore in AI Chat

Overview

FII.FII_AR_DSO_SETUP is a configuration table in the Oracle E-Business Suite Financial Intelligence (FII) product family, owned by the FII schema. It supports the Days Sales Outstanding (DSO) calculation engine delivered within Oracle's receivables and financial analytics offerings. The table acts as a control list that determines which transaction classes and net receivables categories participate in the DSO computation. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, is registered under FND Design Data as FII.FII_AR_DSO_SETUP, and carries a VALID status.

From a heuristic Data Vault modeling perspective, this object classifies as a standalone structure, most closely resembling a reference satellite or lookup configuration table rather than a true hub or link. The relationship metadata indicates no foreign key dependencies, so it does not participate in a star or hub-link topology. Its purpose is purely to hold user- or installation-specific configuration flags that drive downstream DSO aggregation logic.

Oracle marks the object as "Oracle Internal Use Only," meaning supported access is limited to standard Oracle Applications programs. Direct DML is unsupported.

Key Information Stored

The table contains nine documented columns. The most significant are described below.

  • DSO_TYPE (VARCHAR2, 15): Stores the distinct transaction class or net receivables category available for DSO calculation. It is the primary key column, constrained by SYS_C00185121, and therefore the strongest business-key candidate in this table.
  • DSO_VALUE (VARCHAR2, 15): Holds a Y or N flag indicating whether the associated transaction class or net receivables category is applicable for the DSO calculation.
  • DSO_GROUP (VARCHAR2, 15): Signifies the DSO type classification, distinguishing Transaction Class (TC) from Net Receivables (NR) category. This is the column most often referenced by implementers searching for configuration control of DSO grouping.
  • OBJECT_VERSION_NUMBER (NUMBER, 15): The standard EBS optimistic locking column used by the Oracle Applications Framework to detect concurrent updates.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN: The standard Who columns providing audit trail information for row creation and modification.

The surrogate primary key is SYS_C00185121, defined on DSO_TYPE. No separate unique indexes are documented beyond this constraint, so DSO_TYPE functions simultaneously as surrogate and business key.

Common Use Cases and Queries

Typical usage centers on reviewing or validating which receivables elements are enabled for DSO reporting. Analysts query the table to confirm configuration before reconciling DSO output with the underlying AR aging data.

  • Listing all enabled transaction classes: SELECT DSO_TYPE, DSO_VALUE FROM FII.FII_AR_DSO_SETUP WHERE DSO_GROUP = 'TC' AND DSO_VALUE = 'Y';
  • Listing all enabled net receivables categories: SELECT DSO_TYPE, DSO_VALUE FROM FII.FII_AR_DSO_SETUP WHERE DSO_GROUP = 'NR' AND DSO_VALUE = 'Y';
  • Auditing configuration changes over time: SELECT DSO_TYPE, DSO_VALUE, LAST_UPDATE_DATE, LAST_UPDATED_BY FROM FII.FII_AR_DSO_SETUP ORDER BY LAST_UPDATE_DATE DESC;
  • Reporting use case: feeding a BI Publisher or OBIEE report that documents which elements contribute to the DSO denominator and numerator, ensuring consistency between the configured scope and published DSO figures.

Because the object is internal-use only, modifications should occur through Oracle-provided setup screens or concurrent programs, not through ad hoc SQL.

Related Objects

The documented dependency data shows the table does not reference any other database object directly. It is referenced by the APPS synonym FII_AR_DSO_SETUP, which is the public access point used by application code and reporting tools. Downstream DSO calculation programs and the FII analytics views consume this configuration to determine calculation scope.

  • APPS.FII_AR_DSO_SETUP: The APPS-layer synonym providing supported runtime access to the FII table.
  • FII_AR_DSO_SETUP (base table): Referenced object entry; no FK relationships were identified.
  • DSO calculation and aggregation programs within the FII schema consume the DSO_TYPE, DSO_VALUE, and DSO_GROUP columns to determine eligible transaction classes and net receivables categories.
  • AR aging and receivables reporting objects logically complement this setup by supplying the transaction-level data that DSO aggregates.

No direct foreign key or primary key propagation to other tables is documented, reinforcing the standalone classification of this configuration object.