Search Results fnd_dm_product_function_syntax




Overview
Explore in AI Chat

Overview

FND_DM_PRODUCT_FUNCTION_SYNTAX is a repository table in the Oracle E-Business Suite Application Object Library (FND) schema APPLSYS. It stores the syntax definitions that bind a Document Management product to a specific function, describing how that function is rendered and resolved at runtime. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table forms part of the Document Management (DM) configuration layer, sitting between the product catalog and the individual parameter syntaxes that drive execution.

The table is owned by APPLSYS and carries four documented columns. Its primary key is the surrogate PRODUCT_FUNCTION_ID, enforced by the constraint FND_DM_PROD_FUNC_SYNTAX_PK and backed by the unique index FND_DM_PROD_FUNC_SYNTAX_U1 on the same column. In Data Vault modelling terms, the mined foreign-key structure suggests a satellite-leaning classification: the row carries descriptive attributes (the syntax text) attached to the combination of a product and a function, rather than acting as a pure hub or a connecting link. This is a heuristic suggestion only, derived from the FK topology, and should be validated against the customer's own modelling standards.

Key Information Stored

All four documented columns are significant, and no extraneous attributes are present:

  • PRODUCT_FUNCTION_ID — the surrogate primary key. This is the unique identifier for each product-function syntax record and is the column referenced by dependent child tables. It is the sole business-key candidate documented by the unique index.
  • PRODUCT_ID — foreign key to FND_DM_PRODUCTS. Identifies the Document Management product to which this syntax belongs.
  • FUNCTION_ID — foreign key to FND_DM_FUNCTIONS. Identifies the function being bound to the product.
  • FUNCTION_SYNTAX — the syntax definition itself. This is the descriptive payload of the record, holding the textual specification that governs how the product function is expressed or invoked.

Together, PRODUCT_ID and FUNCTION_ID form the natural composite reference from the parent tables, while PRODUCT_FUNCTION_ID serves as the stable surrogate used for joins throughout the module.

Common Use Cases and Queries

Typical usage centres on configuration auditing, dependency analysis, and troubleshooting of Document Management function resolution. A frequent pattern joins the table to both parents to resolve meaningful names:

SELECT pfs.product_function_id,
       p.product_name,
       f.function_name,
       pfs.function_syntax
FROM   applsys.fnd_dm_product_function_syntax pfs,
       applsys.fnd_dm_products p,
       applsys.fnd_dm_functions f
WHERE  pfs.product_id  = p.product_id
AND    pfs.function_id = f.function_id;

Administrators also use the table to enumerate every syntax registered for a given product, to verify that a required function has been configured, or to trace which parameter syntaxes hang beneath a product function by joining forward into FND_DM_PRODUCT_PARM_SYNTAX. Reporting extracts frequently feed migration and cloning activities, where the full set of product-function syntaxes is exported and re-imported between environments.

Related Objects

The table participates in a small, tightly scoped dependency graph:

  • FND_DM_PRODUCTS — referenced via PRODUCT_ID; supplies the product definition for each syntax row.
  • FND_DM_FUNCTIONS — referenced via FUNCTION_ID; supplies the function definition bound to the product.
  • FND_DM_PRODUCT_PARM_SYNTAX — child table, referencing PRODUCT_FUNCTION_ID. It holds the parameter-level syntaxes that extend each product-function syntax.
  • FND_DM_PROD_FUNC_SYNTAX_PK and FND_DM_PROD_FUNC_SYNTAX_U1 — the primary key constraint and unique index that enforce row identity on PRODUCT_FUNCTION_ID.

No other documented foreign-key relationships reference this object. Any query traversing the Document Management syntax hierarchy should begin here and descend into FND_DM_PRODUCT_PARM_SYNTAX to obtain the complete picture of product, function, and parameter syntax definitions for a given Oracle EBS instance.