Search Results fnd_product_groups

The FND_PRODUCT_GROUPS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a foundational data structure within the Applications Object Library (FND) that plays a critical role in managing product licensing, module dependencies, and application groupings. This table stores metadata about Oracle EBS products, their hierarchical relationships, and licensing constraints, ensuring proper system functionality and compliance with Oracle's licensing policies. Below is a detailed analysis of its structure, purpose, and significance in Oracle EBS implementations.

Structure of FND_PRODUCT_GROUPS

The FND_PRODUCT_GROUPS table consists of key columns that define product groupings and their attributes:

PRODUCT_GROUP_ID: A unique identifier for each product group.
APPLICATION_ID: References the FND_APPLICATION table to associate a product with an EBS module (e.g., GL, AP, AR).
PRODUCT_GROUP_NAME: The descriptive name of the product group (e.g., "Financials," "Supply Chain").
BASE_PRODUCT_GROUP_ID: Indicates parent-child relationships between product groups, enabling hierarchical categorization.
STATUS: Tracks whether the product group is active (I) or inactive (S).
START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period for licensing.
LICENSED_FLAG: Specifies whether the product requires a license (Y/N).

Functional Role in Oracle EBS

FND_PRODUCT_GROUPS serves multiple purposes:

Licensing Enforcement: Oracle EBS uses this table to validate license entitlements during installation, patching, and user access. The LICENSED_FLAG ensures only authorized modules are activated.
Dependency Management: It defines prerequisites for product installations (e.g., requiring "General Ledger" before "Accounts Payable").
Patch and Upgrade Coordination: During upgrades, the table helps identify impacted products by mapping dependencies.
User Access Control: Integrated with FND_USER and FND_RESPONSIBILITY, it restricts functionality based on licensed products.

Integration with Other Modules

The table interacts with core EBS components:

FND_APPLICATION: Links product groups to specific applications (e.g., "Payables" to application ID 200).
AD_PATCHED_PRODUCTS: Tracks patched products using PRODUCT_GROUP_ID.
License Manager: Validates compliance during system startups via LICENSED_FLAG checks.

Example Use Case

When installing Oracle EBS 12.2.2, the system queries FND_PRODUCT_GROUPS to:

Verify if "Human Resources" (APPLICATION_ID=800) is licensed.
Check dependencies (e.g., "HRMS" requiring "Core HR").
Enable/disable menu options in the UI based on STATUS and LICENSED_FLAG.

Customization Considerations

While Oracle discourages direct modifications to FND_PRODUCT_GROUPS, admins can:

Extend functionality via custom views or APIs (e.g., FND_PROFILE).
Leverage AD_ZD utilities for zero-downtime patches affecting product groups.

Conclusion

The FND_PRODUCT_GROUPS table is a pivotal component in Oracle EBS 12.1.1 and 12.2.2, governing licensing, dependencies, and system behavior. Its structured hierarchy and integration with core modules ensure compliance and operational efficiency, making it indispensable for administrators and developers.

Table: FND_PRODUCT_GROUPS 12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:AD.FND_PRODUCT_GROUPS, object_name:FND_PRODUCT_GROUPS, status:VALID, product: AD - Applications DBA , description: Site specific information used by AD utilities , implementation_dba_data: APPLSYS.FND_PRODUCT_GROUPS ,
Table: FND_PRODUCT_GROUPS 12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:AD.FND_PRODUCT_GROUPS, object_name:FND_PRODUCT_GROUPS, status:VALID, product: AD - Applications DBA , description: Site specific information used by AutoInstall , implementation_dba_data: APPLSYS.FND_PRODUCT_GROUPS ,