Results for “fnd_conc_stat_list”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_CONC_STAT_LIST is a configuration table in the Oracle E-Business Suite Application Object Library (FND) owned by the APPLSYS schema. The table name identifies it as a Concurrent Statistics List, a repository that controls which runtime statistics the Concurrent Manager collects during concurrent program execution. Administrators use the records in this table to govern the level of diagnostic instrumentation applied to the concurrent processing subsystem, allowing them to trace execution behavior, timing, and resource consumption for troubleshooting or performance analysis without modifying application code.

The ETRM documentation records this object as Retrofitted, indicating it belongs to the original FND foundation layer carried forward into release 12.2.2. Its Data Vault classification is heuristic and mined from its foreign-key structure: the table is standalone and therefore does not participate in any hub, link, or satellite relationship. This classification is offered only as a modeling suggestion; functionally the table behaves as a small, self-contained reference/control list rather than a transactional entity.

Key Information Stored

The documented physical schema for 12.2.2 shows a compact structure of two columns, which is consistent with a pure control table. The most important columns are:

• STATISTIC# — The numeric identifier for a statistic definition. This column is both the primary key (index FND_CONC_STAT_LIST_PK) and the sole business-key candidate (unique index FND_CONC_STAT_LIST_U1). Because the table is a simple list, the surrogate primary key and the business key coincide on this single column; there is no separate system-generated identifier.
• COLLECT_LEVEL — The collection level associated with the statistic, determining the degree or tier at which the statistic is gathered by the concurrent processing framework. This controls whether a given statistic is captured under normal, elevated, or diagnostic collection settings.

Although the ETRM metadata documents only these two columns, other FND statistics tables in the same family (such as FND_CONC_STAT and FND_CONC_STAT_VALUES) typically provide the descriptive name and the collected values that correlate to STATISTIC#. Any column beyond those documented above should be verified directly against the dictionary before use.

Common Use Cases and Queries

The primary use case is to inspect or adjust the statistics collection threshold for concurrent processing. Typical patterns include:

• Listing the configured statistics and their collection levels, for example SELECT STATISTIC#, COLLECT_LEVEL FROM FND_CONC_STAT_LIST ORDER BY STATISTIC#;.
• Identifying how many statistics are enabled at each level: SELECT COLLECT_LEVEL, COUNT(*) FROM FND_CONC_STAT_LIST GROUP BY COLLECT_LEVEL;.
• Joining to concurrent statistics value tables to attribute collected measurements back to their definitions, using STATISTIC# as the linking column.
• Verifying post-upgrade or post-clone configuration to confirm that diagnostic collection levels match the intended baseline.

Because the table is small and read-mostly, queries are inexpensive; however, direct DML should be avoided in favor of supported profile options or Concurrent Manager administration, as incorrect collection levels can degrade concurrent processing throughput or mask diagnostic data.

Related Objects

The following objects are the most significant surrounding the statistics list:

• FND_CONC_STAT — The principal statistics definition table, joined on STATISTIC#, providing descriptive metadata and default collection behavior.
• FND_CONC_STAT_VALUES — Stores the actual collected statistic values, linked to definitions via STATISTIC#.
• FND_CONCURRENT_PROGRAMS — The concurrent program definitions whose executions are instrumented by the collection settings.
• FND_CONCURRENT_REQUESTS — The runtime request rows against which collected statistics are recorded.
• FND_CONCURRENT_QUEUES — The concurrent manager queues that apply collection policies at runtime.
• FND_CONC_STAT_LIST_PK / FND_CONC_STAT_LIST_U1 — The primary-key and unique indexes enforcing the STATISTIC# key.