Search Results fnd_dm_product_parm_syntax




Overview
Explore in AI Chat

Overview

FND_DM_PRODUCT_PARM_SYNTAX is a table owned by the APPLSYS schema within the FND — Application Object Library product of Oracle E-Business Suite, and is documented as VALID in both release 12.1.1 and 12.2.2. The table stores the syntax definitions for function parameters belonging to document management system products. In practical terms, it acts as the mapping layer that binds an individual document management function (a product-level function definition) to a specific parameter and describes exactly how that parameter must be expressed in the calling syntax — including its positional placement and its expected format. This makes the table a configuration registry used by the document management framework when constructing or parsing product function invocations.

The heuristic Data Vault classification mined from the foreign key structure is link. This is a reasonable modeling suggestion: the table resolves a many-to-many association between product function syntax records and reusable function parameter definitions, carrying its own descriptive attributes (parameter syntax and format) as link-level payload rather than as a standalone hub of business entities.

Key Information Stored

The ETRM-documented physical schema records five columns in APPLSYS. The most significant are:

Together, PRODUCT_FUNCTION_ID and PARAMETER_ID form the effective composite business relationship, while PRODUCT_PARAMETER_ID serves purely as the technical surrogate.

Common Use Cases and Queries

The table is primarily interrogated during diagnostics and integration work involving the document management framework, such as verifying which parameters a given product function exposes and in what syntax.

  • Retrieving all parameters for a specific product function:

    SELECT p.PRODUCT_PARAMETER_ID, p.PARAMETER_SYNTAX, p.FORMAT, f.PARAMETER_NAME
    FROM FND_DM_PRODUCT_PARM_SYNTAX p, FND_DM_FUNCTION_PARAMETERS f
    WHERE p.PARAMETER_ID = f.PARAMETER_ID
    AND p.PRODUCT_FUNCTION_ID = :product_function_id;

  • Identifying how a reusable parameter is reused across multiple product functions — a join from FND_DM_FUNCTION_PARAMETERS through this link table to FND_DM_PRODUCT_FUNCTION_SYNTAX.
  • Validating migration or configuration data by comparing PARAMETER_SYNTAX and FORMAT values across environments.
  • Reporting on parameter coverage to confirm that every required parameter of a product function has been defined before activation.

Related Objects

The documented foreign keys identify the two principal related tables, with these exact join columns:

  • FND_DM_PRODUCT_FUNCTION_SYNTAX — joined via FND_DM_PRODUCT_PARM_SYNTAX.PRODUCT_FUNCTION_ID; the parent product function syntax definition.
  • FND_DM_FUNCTION_PARAMETERS — joined via FND_DM_PRODUCT_PARM_SYNTAX.PARAMETER_ID; the master parameter definition.
  • FND_DM_PRODUCT_FUNCTION_SYNTAX_PK — the primary key constraint on the parent object referenced by PRODUCT_FUNCTION_ID.
  • FND_DM_FUNCTION_PARAMETERS primary key — referenced by PARAMETER_ID.
  • FND_DM_PRODUCT_PARM_SYNTAX_PK and FND_DM_PRODUCT_PARM_SYNTAX_U1 — the primary key and unique index enforcing PRODUCT_PARAMETER_ID uniqueness.

Related document management objects in the same family (such as product function and parameter definition tables) should be consulted when reconstructing the full syntax model, as the ETRM excerpt documents only these two foreign key relationships directly.