Search Results fnd_dm_products_u1

Overview

APPLSYS.FND_DM_PRODUCTS is a seed data table in the Oracle E-Business Suite Applications Object Library (AOL) that stores information about the Document Management (DM) software products supported through the Open Interface. Each row captures the name, vendor, and version of a DM software product that Oracle Applications can integrate with, allowing multiple versions of the same product to coexist within a single DM community by maintaining a separate row per version. The table resides in the APPS_TS_SEED tablespace with a PCT Free of 25, and is owned by APPLSYS with the FND design data reference FND.FND_DM_PRODUCTS. Its status is VALID. In EBS 12.1.1 and 12.2.2, it forms part of the Document Management infrastructure that brokers storage and retrieval of attachments through third-party or Oracle-provided DM systems. From a Data Vault modeling perspective, the heuristic classification of this object is hub-leaning: PRODUCT_ID serves as a durable, unique business key that anchors references from many downstream tables, making it a natural candidate for a hub entity around which links and satellites could be organized.

Key Information Stored

The table contains five documented columns. The surrogate and primary key is PRODUCT_ID (NUMBER), which uniquely identifies each Document Management software product and is the column behind the unique index FND_DM_PRODUCTS_U1. The remaining attributes describe the product and are the practical business-key candidates for identifying a specific DM integration:

• PRODUCT_ID — Numeric identifier and primary key for the DM software product.
• PRODUCT_NAME — VARCHAR2(80); the name of the document management system product.
• VENDOR_NAME — VARCHAR2(80); the name of the software vendor that created the product.
• VERSION — VARCHAR2(20); the version of the software that is supported.
• PROTOCOL — VARCHAR2(30); the protocol used to communicate with the DM product.

The combination of PRODUCT_NAME, VENDOR_NAME, and VERSION provides the logical business identity, while FND_DM_PRODUCTS_U1 enforces uniqueness on PRODUCT_ID. The PRODUCT_ID column is the reference point used throughout EBS wherever a transaction or configuration row needs to identify the governing DM product.

Common Use Cases and Queries

The primary use case is determining which DM software products are registered for a given EBS instance and which version or protocol applies to each. Administrators and integration developers query this table when troubleshooting attachment storage, reconciling DM configuration, or validating that the correct product row exists before mapping nodes or functions. A typical lookup joins this table to FND_DM_NODES to trace DM community topology:

• List all supported DM products: SELECT PRODUCT_ID, PRODUCT_NAME, VENDOR_NAME, VERSION, PROTOCOL FROM APPLSYS.FND_DM_PRODUCTS;
• Find a specific vendor's product by version: SELECT * FROM APPLSYS.FND_DM_PRODUCTS WHERE VENDOR_NAME = :vendor AND VERSION = :version;
• Trace nodes associated with a product: SELECT n.NODE_ID, p.PRODUCT_NAME FROM APPLSYS.FND_DM_NODES n JOIN APPLSYS.FND_DM_PRODUCTS p ON n.PRODUCT_ID = p.PRODUCT_ID;

Because PRODUCT_ID is referenced widely as a foreign key across modules such as Order Management, Advanced Pricing, Trade Management, Financials, and Lease Management, reporting extracts often need to resolve PRODUCT_ID back to a readable product name for cross-module analytics.

Related Objects

FND_DM_PRODUCTS is a referenced parent to a large set of child tables, which reinforces its role as a hub. The most significant documented relationships include:

• FND_DM_NODES — references FND_DM_PRODUCTS.PRODUCT_ID; defines DM nodes configured per product.
• FND_DM_PRODUCT_FUNCTION_SYNTAX — references PRODUCT_ID; stores function syntax rules per DM product.
• FND_DM_PRODUCTS_TL — references PRODUCT_ID; holds translated product descriptions.
• AMS_OFFER_PRODUCTS and AMS_FORECAST_PRODUCTS — reference PRODUCT_ID for marketing offer and forecast product context.
• OZF_OFFER_PRODUCTS and OZF_FORECAST_PRODUCTS — reference PRODUCT_ID for pricing and offer management.
• ZX_TRANSACTION_LINES and ZX_LINES_DET_FACTORS — reference PRODUCT_ID for tax calculation lines and factors.
• OKL_LEASE_QUOTES_B and OKL_HEADER_INTERFACE — reference PRODUCT_ID in lease management.
• CSP_PRODUCT_POPULATIONS and CSP_PRODUCT_TASKS — reference PRODUCT_ID for service product populations and tasks.

These relationships confirm that, although FND_DM_PRODUCTS is itself a small seed table, its PRODUCT_ID key propagates into a broad array of transactional and analytical objects, making it a foundational reference for product-aware queries across the EBS data model.