Search Results fnd_dm_function_parameters_u1

Overview

APPLSYS.FND_DM_FUNCTION_PARAMETERS is a seed data table in the Oracle E-Business Suite Applications Object Library (FND) schema. It stores the possible parameters for all Document Management (DM) products supported for a given Document Management function. In practical terms, the table acts as the catalog of accepted parameters for each function exposed by the DM open API, holding one row per function parameter. Each row records the parameter name, its identifier, and the identifier of the function to which the parameter belongs. The table is owned by APPLSYS, carries the FND design data designation FND.FND_DM_FUNCTION_PARAMETERS, resides in the APPS_TS_SEED tablespace, and holds a VALID status in both 12.1.1 and 12.2.2. Because its contents are seeded rather than transactionally generated, it is stable reference data used to validate and route parameters passed into DM open API calls.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. FND_DM_FUNCTION_PARAMETERS depends on FND_DM_FUNCTIONS through the FUNCTION_ID foreign key, which positions it as a descriptive satellite of the DM function hub rather than an independent business hub. The uniqueness of PARAMETER_ID and the composite uniqueness of FUNCTION_ID with PARAMETER_NAME reinforce this interpretation.

Key Information Stored

The documented physical schema contains three columns. Two of these are business-key candidates captured by unique indexes, and one is the surrogate primary key.

• PARAMETER_ID (NUMBER) — The surrogate primary key of the table and the column enforced by the unique index FND_DM_FUNCTION_PARAMETERS_U1. It is the mandatory identifier for each DM function parameter and is the column most commonly used for joins from dependent tables.
• PARAMETER_NAME (VARCHAR2, 80) — The name of the parameter as accepted by the Document Management open API for the parent function. Together with FUNCTION_ID it forms the composite business key enforced by FND_DM_FUNCTION_PARAMETERS_U2, preventing duplicate parameter names within a single function.
• FUNCTION_ID (NUMBER) — The identifier of the DM function to which the parameter relates. This is the mandatory foreign key referencing FND_DM_FUNCTIONS and is the grouping attribute for all parameters belonging to a given function.

There are no additional documented columns beyond these three, so the table is intentionally narrow and purely referential in nature.

Common Use Cases and Queries

The principal use case is resolving which parameters a given Document Management function accepts, typically as part of validating or building DM open API invocations. A representative query lists all parameters for a known function identifier:

• SELECT PARAMETER_ID, PARAMETER_NAME, FUNCTION_ID FROM APPLSYS.FND_DM_FUNCTION_PARAMETERS WHERE FUNCTION_ID = :p_function_id;
• Joining to the parent function table to retrieve function context alongside parameter names, using FUNCTION_ID as the join key to FND_DM_FUNCTIONS.
• Reporting the parameter catalog per function for configuration review or documentation of DM integrations.
• Resolving a parameter name back to its identifier for use in dependent syntax or mapping tables.

The canonical query text published in the ETRM documentation is a straightforward three-column select against PARAMETER_ID, PARAMETER_NAME, and FUNCTION_ID, which reflects the table's role as a lookup source.

Related Objects

The table participates in a small, well-defined dependency graph.

• APPLSYS.FND_DM_FUNCTIONS — Parent of the FUNCTION_ID foreign key. Joins on FND_DM_FUNCTION_PARAMETERS.FUNCTION_ID = FND_DM_FUNCTIONS.FUNCTION_ID.
• APPLSYS.FND_DM_PRODUCT_PARM_SYNTAX — References this table through PARAMETER_ID, linking parameter definitions to product-specific syntax rules.
• APPLSYS.FND_DM_FUNCTION_PARAMETERS# — The editioning/upgrade companion object noted in the dependency listing as referencing this table.
• Unique indexes FND_DM_FUNCTION_PARAMETERS_U1 (PARAMETER_ID) and FND_DM_FUNCTION_PARAMETERS_U2 (FUNCTION_ID, PARAMETER_NAME) — Enforce the surrogate and composite business keys respectively.
• Primary key FND_DM_FUNCTION_PARAMETERS_PK (PARAMETER_ID) — The defining constraint for row identity.

No other database objects are directly referenced by this table according to the documented dependency metadata.