Search Results request_id_pk

Overview

FND_CONC_DEFERRED_ARGUMENTS is a table in the APPLSYS schema of Oracle E-Business Suite, owned by the FND (Application Object Library) product. In Oracle EBS 12.1.1 and 12.2.2, this table stores the parameter values (arguments) associated with concurrent program submissions that have been deferred or staged for later execution. Rather than persisting the full runtime parameter set in the concurrent requests structures at submission time, the argument values are held here until the request actually runs, which supports features such as deferred submission, request scheduling, and argument pre-validation.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is best classified as a link. It captures a relationship between a concurrent request, the concurrent program definition, and the audit users who created or last updated the record. It is neither a standalone hub (it does not carry an independent business key beyond the request) nor a pure satellite (it holds a structured association referencing multiple parent entities). This classification is a heuristic derived from the FK topology and should be treated as a modeling suggestion rather than a documented attribute of the physical schema.

Key Information Stored

The documented physical schema consists of 108 columns, dominated by a hundred positional argument columns (ARGUMENT1 through ARGUMENT100) that hold sequential concurrent program parameter values in submission order.

• REQUEST_ID — The surrogate primary key, enforced through unique index FND_CONC_DEFERRED_ARGUMENTS_U1 (and the REQUEST_ID_PK constraint). It links each deferred argument row back to a specific concurrent request. As a single-column unique index, it is also the business-key candidate for this table.
• PROGRAM_APPLICATION_ID and CONCURRENT_PROGRAM_ID — The composite foreign key identifying the concurrent program definition that the request will execute. These reference FND_CONCURRENT_PROGRAMS.
• ARGUMENT1 to ARGUMENT100 — The positional parameter values captured for the deferred request. Each field corresponds to the ordinal position of a concurrent program parameter, allowing the full parameter set to be reconstructed without a one-row-per-argument structure.
• CREATION_DATE and CREATED_BY — Standard who-column audit attributes; CREATED_BY references FND_USER.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — Standard who-column maintenance attributes; LAST_UPDATED_BY references FND_USER.

Common Use Cases and Queries

Analysts and administrators typically access this table to inspect the exact parameter values retained for deferred or queued concurrent requests, particularly when diagnosing why a program behaved unexpectedly or when auditing parameter history. A common query joins the deferred arguments to the request and program metadata:

• Retrieve the arguments for a specific request: SELECT * FROM fnd_conc_deferred_arguments WHERE request_id = :p_request_id;
• Resolve the program definition: SELECT d.request_id, d.concurrent_program_id, p.concurrent_program_name FROM fnd_conc_deferred_arguments d JOIN fnd_concurrent_programs p ON d.concurrent_program_id = p.concurrent_program_id AND d.program_application_id = p.application_id;
• Audit creation activity: join CREATED_BY to FND_USER to identify the submitting user.

Because arguments are positional, reporting requires knowledge of the target program's parameter list to interpret ARGUMENT1 through ARGUMENT100 meaningfully.

Related Objects

• FND_CONCURRENT_PROGRAMS — Referenced via PROGRAM_APPLICATION_ID and CONCURRENT_PROGRAM_ID; supplies the deferred request's program definition.
• FND_USER — Referenced twice, via CREATED_BY and LAST_UPDATED_BY, for who-column audit lineage.
• FND_CONCURRENT_REQUESTS — The natural parent of REQUEST_ID, providing request lifecycle status and phase information.
• FND_CONCURRENT_PROGRAMS_TL — Provides translated program names for reporting.
• FND_CONCURRENT_PROGRAM_SERIAL — Relates to program execution sequencing alongside deferred submissions.