Search Results processor_application_id




Overview
Explore in AI Chat

Overview

The table FND_CONC_PROCESSOR_PROGRAMS is a core Application Object Library table in Oracle E-Business Suite (EBS) that defines the mapping between immediate concurrent programs and the concurrent manager processes responsible for their execution. It plays a critical role in the concurrent processing architecture by specifying which specific programs are included within a concurrent program library. This table ensures that immediate concurrent programs, which are designed for rapid, short-duration execution, are correctly associated with and can be serviced by the appropriate concurrent processor, thereby enabling efficient workload management and resource allocation within the EBS environment.

Key Information Stored

The table stores a composite key that uniquely identifies the relationship between a concurrent processor and an immediate concurrent program. The primary columns are the foreign key pairs that link to the parent tables. The column PROCESSOR_APPLICATION_ID, combined with CONCURRENT_PROCESSOR_ID, references a specific concurrent processor defined in FND_CONCURRENT_PROCESSORS. The column PROGRAM_APPLICATION_ID, combined with CONCURRENT_PROGRAM_ID, references a specific immediate concurrent program defined in FND_CONCURRENT_PROGRAMS. Together, these four columns constitute the primary key (FND_CONC_PROCESSOR_PROGRAMS_PK), enforcing the uniqueness of each processor-to-program assignment.

Common Use Cases and Queries

This table is primarily referenced for administrative and diagnostic purposes related to concurrent manager configuration. A common use case is auditing which immediate programs are assigned to a specific concurrent processor. System administrators may run queries to verify setup or troubleshoot program execution issues. A typical reporting query would join this table to its parent tables to get descriptive names. For example:

  • To list all immediate programs assigned to a processor: SELECT cp.concurrent_processor_name, cp.user_concurrent_program_name FROM fnd_concurrent_processors p, fnd_concurrent_programs cp, fnd_conc_processor_programs cpp WHERE cpp.processor_application_id = p.application_id AND cpp.concurrent_processor_id = p.concurrent_processor_id AND cpp.program_application_id = cp.application_id AND cpp.concurrent_program_id = cp.concurrent_program_id;
  • To identify orphaned records or validate configuration integrity.

Related Objects

The table FND_CONC_PROCESSOR_PROGRAMS is centrally linked to two key parent tables via foreign key constraints, as documented in the ETRM metadata.

  • FND_CONCURRENT_PROCESSORS: The foreign key from columns (PROCESSOR_APPLICATION_ID, CONCURRENT_PROCESSOR_ID) references this table to define the specific concurrent manager process.
  • FND_CONCURRENT_PROGRAMS: The foreign key from columns (PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID) references this table to define the specific immediate concurrent program included in the library.

These relationships ensure referential integrity, guaranteeing that mappings in FND_CONC_PROCESSOR_PROGRAMS correspond to valid, defined entities in the system.