Search Results ps_plng_cls_pk

Overview

The PS_PLNG_CLS table is a core data definition table within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It serves as the master repository for planning class definitions. A planning class is a critical classification used to group items and operations for production planning and scheduling purposes within a process manufacturing environment. Its primary role is to establish a logical framework that dictates how materials and resources are planned, enabling consistent scheduling rules, capacity requirements, and reporting across similar products or processes. The table's existence is fundamental to the configuration and execution of manufacturing planning workflows in EBS releases 12.1.1 and 12.2.2.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships indicate the essential attributes stored. The central column is PLANNING_CLASS, which is the table's primary key (PS_PLNG_CLS_PK) and holds the unique identifier for each planning class definition. Other significant columns include TEXT_CODE, which links to descriptive text in the IC_TEXT_HDR table, and REPORTING_UOM, which specifies the default unit of measure for reporting purposes, linked to the SY_UOMS_MST table. The table likely contains additional descriptive and control fields to define the behavior and properties of the planning class within the planning engine.

Common Use Cases and Queries

A primary use case is the setup and maintenance of planning parameters for new or existing items and operations. Analysts use this data to ensure items are assigned to the correct planning class to inherit appropriate scheduling and capacity rules. Common reporting involves listing all defined planning classes with their descriptions. A typical query would join PS_PLNG_CLS to the text and UOM tables for a comprehensive view:

• SELECT pc.PLANNING_CLASS, txt.TEXT, uom.UOM_CODE FROM PS_PLNG_CLS pc, IC_TEXT_HDR txt, SY_UOMS_MST uom WHERE pc.TEXT_CODE = txt.TEXT_CODE(+) AND pc.REPORTING_UOM = uom.UOM_CODE(+);

Another critical use case is troubleshooting planning output by validating the planning class assignments on items (IC_ITEM_MST) and operations (PS_OPER_PCL) against the master definitions in PS_PLNG_CLS.

Related Objects

PS_PLNG_CLS has defined relationships with several key EBS tables, as per the provided foreign key metadata. It is referenced as a parent table by:

• IC_ITEM_MST: The item master table, where the PLANNING_CLASS column links an item to its planning definition.
• PS_OPER_PCL: The operations planning class table, which associates specific manufacturing operations with a planning class.

Furthermore, PS_PLNG_CLS itself references two other tables via foreign keys:

• IC_TEXT_HDR: To store descriptive, translatable text for the planning class via the TEXT_CODE.
• SY_UOMS_MST: To define the standard reporting unit of measure via the REPORTING_UOM column.

These relationships underscore its central role as a master configuration entity within the manufacturing planning data model.