Search Results fnd_product_groups_pk

Overview

APPLSYS.FND_PRODUCT_GROUPS is a site-specific configuration table maintained by the Applications DBA (AD) product. It stores the definition of each Oracle E-Business Suite product group installed at a given site, capturing identity, release level, and structural characteristics such as multi-organization, multi-lingual, and multi-currency support. AD utilities consult this table during installation, upgrade (AutoPatch), and maintenance operations to determine the product group context in which a file or patch applies. The table is classified under Data Vault modeling heuristics as standalone, suggesting that in a derived analytical model it functions most naturally as a reference or hub-style entity, since it anchors dependent fact and summary tables but is not itself a dependent child of another keyed parent.

Key Information Stored

The table exposes 16 documented columns. Foremost is the surrogate primary key PRODUCT_GROUP_ID, defined by constraint FND_PRODUCT_GROUPS_PK. A second unique constraint, FND_PRODUCT_GROUPS_UK1, is defined on PRODUCT_GROUP_NAME, making it the natural business-key candidate for external reference and human-readable lookup. Release identity is carried by RELEASE_NAME and ARU_RELEASE_NAME, with PRODUCT_GROUP_TYPE distinguishing group categories. The functional capability flags MULTI_ORG_FLAG, MULTI_LINGUAL_FLAG, and MULTI_CURRENCY_FLAG describe the operating characteristics of the group. APPLICATIONS_SYSTEM_NAME associates the group with an Applications system, while ARGUMENT1 and IS_NEW_TS_MODE support AD processing and tablespace-mode logic. Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) complete the row.

Common Use Cases and Queries

Typical usage includes confirming installed release levels prior to patching, auditing multi-org or multi-currency enablement, and reporting the product footprint for a site.

• Listing all product groups with their release names and capability flags:

SELECT product_group_id, product_group_name, release_name,
       multi_org_flag, multi_lingual_flag, multi_currency_flag
FROM   applsys.fnd_product_groups
ORDER  BY product_group_name;

• Resolving a business key to its surrogate for downstream joins:

SELECT product_group_id
FROM   applsys.fnd_product_groups
WHERE  product_group_name = :p_group_name;

• Correlating summary or interaction records with their owning product group:

SELECT g.product_group_name, s.*
FROM   applsys.fnd_product_groups g,
       applsys.bix_sum_info s
WHERE  g.product_group_id = s.product_group_id;

Related Objects

The table is referenced by foreign keys in several Business Intelligence/analytics extraction tables, which map their PRODUCT_GROUP_ID column back to FND_PRODUCT_GROUPS.PRODUCT_GROUP_ID:

• BIX_SUM_INFO — foreign key on PRODUCT_GROUP_ID.
• BIX_SUM_AGT_PRD — foreign key on PRODUCT_GROUP_ID.
• BIX_SUM_GRP_PRD_OUT — foreign key on PRODUCT_GROUP_ID.
• BIX_INTERACTIONS_INF — foreign key on PRODUCT_GROUP_ID.

These relationships make FND_PRODUCT_GROUPS the authoritative reference for product group identity across the associated BIX summary and interaction data sets, ensuring consistent grouping in downstream reporting and analytics queries.