Results for “fnd_req_set_program_args_pk”

6 results




Overview
Explore in AI Chat

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

Overview

FND_REQUEST_SET_PROGRAM_ARGS is an Application Object Library (FND) table owned by the APPLSYS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store default values for report set arguments. A report set is a container that groups multiple concurrent programs so they can be submitted together through the Standard Request Submission (SRS) interface. When a report set is defined, individual programs within it expose parameters, and FND_REQUEST_SET_PROGRAM_ARGS holds the default values that pre-populate those parameters at submission time.

The table carries 18 documented columns and is governed by the primary key FND_REQ_SET_PROGRAM_ARGS_PK, composed of APPLICATION_ID, REQUEST_SET_ID, REQUEST_SET_PROGRAM_ID, DESCRIPTIVE_FLEX_APPL_ID, DESCRIPTIVE_FLEXFIELD_NAME, and APPLICATION_COLUMN_NAME. This composite key ties each argument row to a specific program within a specific request set, and, where applicable, to a specific descriptive flexfield segment.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This is a reasonable suggestion: the table resolves relationships between request set programs, descriptive flexfields, and their default argument settings, rather than acting as an independent business hub or as a type-2 satellite tracking attribute history.

Key Information Stored

The most significant columns fall into three groups.

  • Key and relationship columns: APPLICATION_ID, REQUEST_SET_ID, and REQUEST_SET_PROGRAM_ID together identify the target program within a request set and also form part of the foreign key to FND_REQUEST_SET_PROGRAMS. DESCRIPTIVE_FLEX_APPL_ID and DESCRIPTIVE_FLEXFIELD_NAME identify the descriptive flexfield context and form the foreign key to FND_DESCRIPTIVE_FLEXS. APPLICATION_COLUMN_NAME identifies the specific program or flexfield parameter being defaulted.
  • Default behavior columns: DEFAULT_TYPE specifies the mechanism by which the default is derived, while DEFAULT_VALUE holds the actual default value or the reference used to compute it. DISPLAY_FLAG, INSERT_FLAG, and UPDATE_FLAG control whether the argument is displayed and whether its value may be inserted or updated during submission. SHARED_PARAMETER_NAME supports sharing a parameter value across programs in the set.
  • Audit and edition columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard WHO audit tracking. ZD_EDITION_NAME participates in the unique index FND_REQUEST_SET_PROG_ARGS_U1, which extends the business key dimensions with edition information for Online Patching (adop) support in 12.2.2.

The primary key indexes surrogate and business dimensions together, while FND_REQUEST_SET_PROG_ARGS_U1 (APPLICATION_ID, REQUEST_SET_ID, REQUEST_SET_PROGRAM_ID, DESCRIPTIVE_FLEX_APPL_ID, DESCRIPTIVE_FLEXFIELD_NAME, APPLICATION_COLUMN_NAME, ZD_EDITION_NAME) represents the documented business-key candidate enforcing uniqueness of an argument definition per edition.

Common Use Cases and Queries

Typical uses include auditing and migrating report set definitions, diagnosing why a program parameter defaults to an unexpected value, and reporting which request sets depend on a given flexfield segment or shared parameter.

  • List default arguments for a request set program: SELECT application_column_name, default_type, default_value, display_flag FROM fnd_request_set_program_args WHERE application_id = :app_id AND request_set_id = :set_id AND request_set_program_id = :prog_id;
  • Trace flexfield-driven defaults: SELECT a.request_set_id, a.request_set_program_id, a.application_column_name, a.default_value FROM fnd_request_set_program_args a WHERE a.descriptive_flex_appl_id = :df_appl AND a.descriptive_flexfield_name = :df_name;
  • Identify programs using a shared parameter: SELECT request_set_id, request_set_program_id, application_column_name FROM fnd_request_set_program_args WHERE shared_parameter_name = :shared_name;

These queries support reporting on request set configuration, comparison of defaults across environments, and impact analysis before changing a descriptive flexfield.

Related Objects

  • FND_REQUEST_SET_PROGRAMS — parent table referenced via APPLICATION_ID, REQUEST_SET_ID, and REQUEST_SET_PROGRAM_ID; defines the programs that make up a request set.
  • FND_DESCRIPTIVE_FLEXS — referenced via DESCRIPTIVE_FLEX_APPL_ID and DESCRIPTIVE_FLEXFIELD_NAME; supplies flexfield context for argument defaults.
  • FND_REQUEST_SETS — header table describing the request set itself.
  • FND_CONCURRENT_PROGRAMS — defines the executable programs whose parameters are defaulted.
  • FND_REQUEST_SET_STAGE_PROGRAMS — stage-level program definitions that further describe execution ordering within a set.
  • Standard SRS submission APIs, such as FND_REQUEST.SUBMIT_REQUEST, consume the resulting argument values defined here.

Together these objects form the metadata layer that drives report set submission and parameter defaulting in Oracle EBS.