Search Results gmd_formula_class_b




Overview
Explore in AI Chat

Overview

The GMD_FORMULA_CLASS_B table is a core master data table within Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. It serves as the base table for defining and storing formula classes, which are hierarchical categories used to logically group and organize formulas. This classification is fundamental for managing the extensive library of manufacturing recipes, enabling efficient searching, reporting, and security assignment. The table's structure supports the definition of a classification hierarchy, allowing for a parent-child relationship between formula classes, which facilitates detailed and organized categorization of formulas based on product type, process, or other business criteria.

Key Information Stored

While the provided metadata does not list specific columns, the primary purpose of the table dictates the nature of its key attributes. The central column is FORMULA_CLASS, which serves as the unique identifier (Primary Key) for each classification entry. This table typically stores descriptive information for each class, such as a name and description. A critical structural column is likely PARENT_FORMULA_CLASS, which establishes the hierarchical relationship between classes, enabling the creation of multi-level classification trees. Other standard columns would include creation date, created by, last update date, and last updated by for auditing purposes. The TEXT_CODE column, referenced by a foreign key relationship, links to descriptive flexfield text for extended, user-defined descriptions.

Common Use Cases and Queries

The primary use case is the administration and application of formula classification. Users create and maintain the class hierarchy via the Oracle Forms interface, which then populates this table. A common reporting requirement is to list all formulas belonging to a specific class or its sub-classes. For example, to find all formulas within a given class hierarchy, a query would join GMD_FORMULA_CLASS_B with FM_FORM_MST_B. Another typical query retrieves the full classification tree structure using a hierarchical SQL CONNECT BY clause on the FORMULA_CLASS and its parent column. Formula classes are also integral to setting up and enforcing data security, where access to formulas can be restricted based on a user's authorized formula classes.

Related Objects

GMD_FORMULA_CLASS_B is centrally connected to several key tables in the Process Manufacturing schema, primarily through foreign key relationships as documented in the metadata.

  • FM_FORM_MST_B (Formula Master): This is the most critical relationship. The FM_FORM_MST_B.FORMULA_CLASS column is a foreign key referencing GMD_FORMULA_CLASS_B.FORMULA_CLASS. This links every formula to its assigned classification.
  • FM_TEXT_HDR (Text Header): The GMD_FORMULA_CLASS_B.TEXT_CODE column is a foreign key to FM_TEXT_HDR, enabling the storage of additional descriptive text for a formula class via descriptive flexfields.
  • Self-Referential Hierarchy: Although not explicitly listed in the provided foreign key list, the table typically contains a PARENT_FORMULA_CLASS column that references its own FORMULA_CLASS primary key to build the classification hierarchy.