Search Results carrying value




The FND_CONC_STAT_PERIODS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for storing statistical data related to concurrent processing. This table is part of the Oracle Applications Foundation (FND) module and serves as a key component in monitoring and analyzing the performance of concurrent programs over defined time periods. It captures aggregated metrics that help administrators evaluate system efficiency, identify bottlenecks, and optimize resource allocation.

Purpose and Functionality

The primary purpose of FND_CONC_STAT_PERIODS is to store summarized statistics for concurrent programs executed within specific time intervals. These intervals, referred to as "periods," can be hourly, daily, weekly, or monthly, depending on the configuration. The table aggregates data such as execution counts, average runtime, success/failure rates, and resource consumption (CPU, I/O) for concurrent requests. This enables administrators to perform trend analysis and capacity planning.

Key Columns and Structure

The table includes several important columns:

  • PERIOD_ID: A unique identifier for each statistical period.
  • PERIOD_TYPE: Defines the time interval (e.g., 'HOUR', 'DAY', 'WEEK', 'MONTH').
  • START_TIME and END_TIME: Timestamps marking the beginning and end of the period.
  • CONCURRENT_PROGRAM_ID: Links to FND_CONCURRENT_PROGRAMS to identify the program.
  • EXECUTIONS: Total number of executions during the period.
  • AVG_RUNTIME: Average runtime of the program in seconds.
  • SUCCESS_COUNT and FAILURE_COUNT: Tracks successful and failed executions.
  • RESOURCE_USAGE: Metrics like CPU time and memory consumption.

Integration with Concurrent Processing

The data in FND_CONC_STAT_PERIODS is populated by the Concurrent Processing Manager, which logs execution details to FND_CONCURRENT_REQUESTS and periodically aggregates them into this table. The table supports Oracle EBS's built-in performance dashboards and can be queried for custom reports using SQL or tools like Oracle BI Publisher.

Use Cases

Administrators leverage this table for:

  • Performance Tuning: Identifying long-running programs or periods of high load.
  • Capacity Planning: Analyzing historical trends to predict future resource needs.
  • Failure Analysis: Pinpointing programs with high failure rates for debugging.
  • SLA Compliance: Monitoring whether programs meet expected runtime thresholds.

Maintenance Considerations

Oracle provides purge utilities (e.g., FND_STATS_PURGE) to manage table growth. Inactive periods should be archived or purged to maintain performance. The table is also indexed on key columns like PERIOD_ID and CONCURRENT_PROGRAM_ID for efficient querying.

Version-Specific Notes

In EBS 12.2.2, the table may include additional columns for cloud-oriented metrics, such as elasticity adjustments. However, its core functionality remains consistent with 12.1.1. Both versions rely on this table for the Concurrent Processing Statistics Report (FNDSCPST.rdf).

In summary, FND_CONC_STAT_PERIODS is a foundational table for concurrent processing analytics in Oracle EBS, enabling data-driven decision-making for system optimization.