Search Results op_cust_cls




Overview
Explore in AI Chat

Overview

The OP_CUST_CLS table is a core reference data object within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for defining and storing customer classes. In the context of Process Manufacturing, a customer class is a categorization mechanism used to group customers with similar characteristics, such as industry type, pricing agreements, or logistical requirements. This classification is fundamental for streamlining business rules, pricing strategies, and reporting across the supply chain and order management processes. The table's primary role is to provide a validated list of class codes that can be assigned to customer master records, ensuring data consistency and enabling operational policies to be applied at a group level.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the structure and relationships indicate the core data elements. The table's primary key is the CUST_CLASS column, which holds the unique identifier or code for each customer class. Given its role as a reference table, it likely includes descriptive columns such as a class name or description. A critical relational element is the TEXT_CODE column, which forms a foreign key relationship to the OP_TEXT_HDR table. This linkage is standard in Oracle EBS for attaching extensive descriptive text, notes, or terms and conditions to the customer class definition, allowing for rich textual information beyond a simple code and description.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting on customer segmentation. A common operational use case is the assignment of a class to a new customer in the OP_CUST_MST_OPM table, where the CUST_CLASS value must exist in OP_CUST_CLS. For reporting, analysts often join this table to customer transaction data to analyze sales, profitability, or compliance by customer class. A typical query to list all active classes with their descriptions might resemble:

  • SELECT cust_class, description FROM gml.op_cust_cls ORDER BY cust_class;

Another frequent pattern is validating or finding customers within a specific class for a targeted business action, such as a pricing update:

  • SELECT m.customer_id, m.customer_name FROM gml.op_cust_mst_opm m WHERE m.cust_class = '&CLASS_CODE';

Related Objects

The OP_CUST_CLS table has defined relationships with several key transactional and master tables, as per the provided metadata. The primary foreign key dependency is from the customer master tables in both the Process Manufacturing (OP_CUST_MST_OPM) and potentially other integrated schemas (OP_CUST_MST), where the CUST_CLASS column references OP_CUST_CLS. This enforces referential integrity for customer classifications. Furthermore, it is linked to the OP_TEXT_HDR table via the TEXT_CODE column, enabling the storage of extended text. These relationships position OP_CUST_CLS as a central lookup table that supports data integrity and consistent classification across the customer lifecycle within Process Manufacturing Logistics.