Search Results ps_oper_pcl




Overview
Explore in AI Chat

Overview

The PS_OPER_PCL table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for the Process Planning sub-module. Its primary function is to establish and maintain the association between operator codes and planning classes. This association is fundamental to the process planning and execution workflows in a manufacturing environment. By linking specific operators (or user IDs) to defined planning classes, the system can enforce operational responsibilities, route tasks appropriately, and control data access and visibility based on an operator's assigned class. The table's existence under the GMP schema and its VALID status confirm it is an active, production-ready component of the EBS architecture in both the 12.1.1 and 12.2.2 versions.

Key Information Stored

The table's structure, as indicated by its primary and foreign key constraints, centers on two critical pieces of information. The USER_ID column identifies the specific operator or system user. The PLANNING_CLASS column holds the code for the planning class to which that user is assigned. A composite primary key on these two columns (PS_OPER_PCL_PK) ensures a unique combination of user and planning class, preventing duplicate assignments. The table also includes a TEXT_CODE column, which is a foreign key to the PS_TEXT_HDR table. This allows for associating descriptive, long-text notes or instructions with the specific user-class association, providing context or operational guidelines.

Common Use Cases and Queries

The primary use case is the administration and validation of operator planning permissions. A common operational query would retrieve all operators authorized for a specific planning class to assign tasks or review responsibilities. Conversely, system logic frequently queries for all planning classes assigned to a given operator to determine their permissible actions within the Process Planning module.

  • Retrieve all operators for a planning class: SELECT USER_ID FROM GMP.PS_OPER_PCL WHERE PLANNING_CLASS = :1;
  • Retrieve all classes for an operator: SELECT PLANNING_CLASS FROM GMP.PS_OPER_PCL WHERE USER_ID = :1;
  • Validate operator-class assignment: This check is integral to process planning transactions, ensuring the initiating user has the correct authorization before creating or modifying a process plan.

Related Objects

PS_OPER_PCL is centrally connected to other key GMP tables via foreign key relationships. Its most direct relationship is with the PS_PLNG_CLS table, which defines the master list and attributes of all valid planning classes. The foreign key on PLANNING_CLASS ensures referential integrity, meaning an operator can only be assigned to a class that exists in this master table. The relationship to PS_TEXT_HDR via the TEXT_CODE column enables rich text descriptions. While not explicitly listed, this table is logically a parent to any transactional or planning tables that require a validated operator and planning class combination, serving as a control point for user authorization within the Process Planning domain.