Search Results qc_actn_mst




Overview
Explore in AI Chat

Overview

The QC_ACTN_MST table is a core master data table within the Oracle E-Business Suite (EBS) Process Manufacturing (GMD) module, specifically under Product Development. It serves as the central repository for defining and managing Quality Control (QC) action codes. These standardized codes are critical for enforcing business rules and workflows related to the disposition of materials—such as raw ingredients, intermediates, or finished goods—based on the results of quality tests and inspections. The table's role is to provide a controlled list of valid actions (e.g., Accept, Reject, Rework, Hold for Review) that can be assigned throughout the quality management lifecycle, ensuring consistency and traceability in manufacturing operations.

Key Information Stored

The primary data stored in QC_ACTN_MST revolves around the action code definition. The key column is ACTION_CODE, which is the unique identifier and primary key for the table. This column holds the short code representing the specific quality disposition action. While the provided ETRM excerpt does not list all columns, typical supporting columns in such master tables would include a description field (e.g., ACTION_DESC), an enabled flag, creation and last update dates, and who created and last updated the record. The table also maintains a relationship to the QC_TEXT_HDR table via the TEXT_CODE foreign key, which allows for storing extensive descriptive text or instructions associated with each action code.

Common Use Cases and Queries

This table is primarily referenced in transactional and configuration contexts. A fundamental use case is the setup and maintenance of action codes via the application's user interface, which behind the scenes performs INSERT, UPDATE, or DELETE operations on QC_ACTN_MST. These codes are then applied when defining quality specifications (QC_SPEC_MST.OUTACTION_CODE) or when setting default expiration actions on items (IC_ITEM_MST.EXPACTION_CODE) and lots. Common reporting and validation queries include listing all active action codes or verifying the code used in a specific transaction. A typical sample query would be:

  • SELECT action_code, text_code FROM gmd.qc_actn_mst WHERE enabled_flag = 'Y' ORDER BY action_code;

Another critical use case is in lot control and expiration management, where the system references the action code to determine the automatic status of a lot when its shelf life expires.

Related Objects

As indicated by the foreign key relationships, QC_ACTN_MST is integrated with several key tables across the Inventory and Quality modules. It is referenced by:

  • QC_SPEC_MST: Defines the output action for a quality specification.
  • IC_ITEM_MST_B and IC_ITEM_MST: Store the default expiration action code for an item.
  • IC_LOTS_MST: Stores the expiration action code for a specific lot.
  • QC_TEXT_HDR: Stores additional descriptive text for the action code via the TEXT_CODE foreign key from QC_ACTN_MST.

These relationships highlight that QC_ACTN_MST is a shared reference point, ensuring that action codes used in item master data, lot master data, and quality specifications are all valid and centrally maintained.