Search Results fnd_request_set_program_args




Overview
Explore in AI Chat

Overview

The FND_REQUEST_SET_PROGRAM_ARGS table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It serves as the central repository for storing default argument values for individual programs that are part of a request set. A request set is a collection of concurrent programs that can be submitted as a single job. This table's primary role is to define and persist the pre-configured, or default, parameters for each program within the set, enabling the automated and repeatable execution of complex, multi-step reporting and processing workflows without requiring manual parameter entry each time.

Key Information Stored

The table's structure is designed to uniquely identify a specific argument for a specific program within a specific request set. Its primary key is a composite of APPLICATION_ID, REQUEST_SET_ID, and REQUEST_SET_PROGRAM_ID, which links it to the parent FND_REQUEST_SET_PROGRAMS table. Crucially, it also includes DESCRIPTIVE_FLEX_APPL_ID, DESCRIPTIVE_FLEXFIELD_NAME, and APPLICATION_COLUMN_NAME to identify the exact parameter or descriptive flexfield segment for which the default value is being stored. Other columns, not detailed in the excerpt but standard for such argument tables, typically include VALUE and DEFAULT_VALUE columns to hold the actual default data, and ENABLED_FLAG to control whether the default is active. The foreign key constraints enforce referential integrity with the request set programs table (FND_REQUEST_SET_PROGRAMS) and the descriptive flexfields definition table (FND_DESCRIPTIVE_FLEXS).

Common Use Cases and Queries

The primary use case is the administration and analysis of request set configurations. System administrators or developers query this table to audit or troubleshoot the default parameters applied across request sets. A common reporting need is to list all default arguments for a particular request set. A sample query pattern would join FND_REQUEST_SET_PROGRAM_ARGS to FND_REQUEST_SET_PROGRAMS and FND_REQUEST_SETS_VL for descriptive information.

  • Sample Query: To find default arguments for a request set by name:
    SELECT rs.request_set_name, rsp.program_application_id, rsp.concurrent_program_name, rspa.application_column_name, rspa.default_value FROM fnd_request_sets_vl rs, fnd_request_set_programs rsp, fnd_request_set_program_args rspa WHERE rs.request_set_id = rsp.request_set_id AND rsp.application_id = rspa.application_id AND rsp.request_set_id = rspa.request_set_id AND rsp.request_set_program_id = rspa.request_set_program_id AND rs.request_set_name = '&REQUEST_SET_NAME';
  • Administrative Scenario: Identifying all request sets where a specific program argument has been set to a particular default value, useful for impact analysis before changing a global parameter.

Related Objects

This table is a child entity in several key relationships within the EBS concurrent processing framework.

  • FND_REQUEST_SET_PROGRAMS: The direct parent table. The foreign key defines the specific program within a request set to which these argument defaults belong.
  • FND_REQUEST_SETS / FND_REQUEST_SETS_VL: The grandparent entity, representing the request set definition itself.
  • FND_DESCRIPTIVE_FLEXS: Provides the definitional metadata for descriptive flexfield contexts referenced by the DESCRIPTIVE_FLEXFIELD_NAME and DESCRIPTIVE_FLEX_APPL_ID columns.
  • FND_CONCURRENT_PROGRAMS: While not directly linked via a foreign key in the provided metadata, the REQUEST_SET_PROGRAM_ID ultimately relates to a concurrent program defined in this table.