Search Results fm_fmct_cls




Overview
Explore in AI Chat

Overview

The FM_FMCT_CLS table, owned by the GMD (Process Manufacturing Product Development) schema, is a reference table designed to store formula control classes within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary role is to categorize and enforce business rules or validation controls for formulas in the Process Manufacturing module. However, a critical detail from the official documentation is its explicit description as "-NOT USED-". This indicates that while the table structure exists within the database schema and maintains defined relationships with core formula tables, its functional implementation for storing active control class data may be deprecated or reserved for future use. Its presence is primarily architectural, supporting referential integrity through its foreign key constraints.

Key Information Stored

The table's structure is centered on the control class identifier. The primary column is FMCONTROL_CLASS, which serves as the unique key (Primary Key: FM_FMCT_CLS_PK) for identifying a specific formula control class. Based on standard Oracle EBS design patterns for reference tables with descriptive text, it likely includes a TEXT_CODE column. This column would typically be a foreign key to the FND_TEXT_HDR table (represented as FM_TEXT_HDR in the metadata), enabling the storage of translatable descriptions and long text for the control class. The "-NOT USED-" status suggests that any records present may be seed data or placeholders rather than actively maintained application data.

Common Use Cases and Queries

Given its documented status, direct operational use cases are minimal. Its primary utility is for technical analysis, data integrity checks, and understanding the application's schema. Common queries would involve investigating its relationships or verifying the absence of active data. A sample query to list all defined control classes and their descriptions would be:

  • SELECT fct.fmcontrol_class, tl.description FROM gmd.fm_fmct_cls fct, fnd_text_tl tl WHERE fct.text_code = tl.text_id AND tl.language = USERENV('LANG');

Another critical query would be to confirm its unused status by checking for any references in the main formula tables: SELECT DISTINCT fmcontrol_class FROM gmd.fm_form_mst_b WHERE fmcontrol_class IS NOT NULL;

Related Objects

The FM_FMCT_CLS table is structurally integrated into the Process Manufacturing formula foundation through several foreign key relationships, as documented in the ETRM. The key related objects are:

  • FM_FORM_MST_B and FM_FORM_MST: The primary formula master tables. They reference FM_FMCT_CLS via their FMCONTROL_CLASS column, linking a formula to a potential control class.
  • LM_FORM_MST: The formula master table for laboratory management, which also references this control class table.
  • FM_TEXT_HDR: The table that stores the header for descriptive text entities, linked via the TEXT_CODE column in FM_FMCT_CLS.

These relationships underscore the table's intended role in the data model, even if its business logic is currently inactive.