Search Results fnd_conc_state_lookups




Overview
Explore in AI Chat

Overview

The FND_CONC_STATE_LOOKUPS table is a core Application Object Library table within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a master repository for lookup values that define the operational states of the Concurrent Processing framework. This table is fundamental to the system's ability to manage and report on the status of concurrent requests, providing the standardized, translatable codes and descriptions used throughout the application's user interface and underlying logic. Its data is critical for workflow control, user notifications, and system monitoring, serving as a key reference point for the state of any job submitted to the concurrent manager.

Key Information Stored

The table stores discrete state codes and their associated metadata. Its structure is defined by a composite primary key consisting of LOOKUP_TYPE_ID and LOOKUP_VALUE. The LOOKUP_TYPE_ID is a foreign key to FND_CONC_STATE_LOOKUP_TYPES, categorizing the state (e.g., phase or status). The LOOKUP_VALUE column holds the actual state code, such as 'R' for Running, 'C' for Completed, or 'E' for Error. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track record history. For user-facing descriptions, the related FND_CONC_STATE_LOOKUPS_TL table provides translated meanings (MEANING and DESCRIPTION) for these codes, linked via the primary key columns.

Common Use Cases and Queries

This table is primarily referenced for translating internal state codes into human-readable form for reports and user interfaces. A common use case is enhancing the readability of concurrent request status reports. Developers and DBAs frequently query this table to understand valid state transitions or to diagnose request lifecycle issues. A typical join pattern to retrieve a request's status description is:

  • SELECT req.request_id, tl.meaning, tl.description
  • FROM fnd_concurrent_requests req,
  • fnd_conc_state_lookups lk,
  • fnd_conc_state_lookups_tl tl
  • WHERE req.phase_code = lk.lookup_value
  • AND lk.lookup_type_id = [PHASE_TYPE_ID]
  • AND lk.lookup_type_id = tl.lookup_type_id
  • AND lk.lookup_value = tl.lookup_value
  • AND tl.language = USERENV('LANG');

Administrators may also query it directly to list all defined states for a given lookup type, such as request phases or statuses within a phase.

Related Objects

FND_CONC_STATE_LOOKUPS maintains integral relationships with several other Application Object Library tables, as documented in the ETRM metadata. It references FND_CONC_STATE_LOOKUP_TYPES via LOOKUP_TYPE_ID to categorize state values. For audit purposes, it references FND_USER (for CREATED_BY and LAST_UPDATED_BY) and FND_LOGINS (for LAST_UPDATE_LOGIN). Crucially, it is referenced as a parent table by key concurrent processing objects. The FND_CONC_RELEASE_STATES table references it via LOOKUP_TYPE_ID and STATUS to manage request release conditions. The FND_CONC_STATE_LOOKUPS_TL table holds translations for its records, linked via the composite key (LOOKUP_TYPE_ID, LOOKUP_VALUE). These relationships underscore its role as the central authority for concurrent processing state definitions.