Search Results gl_acct_map




Overview
Explore in AI Chat

Overview

The OP_CGLD_CLS table is a core reference table 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 Customer General Ledger (GL) account classes. These classes are critical for financial accounting and reporting, as they categorize customers based on the GL accounts that should be used for posting transactions. The table enables the systematic mapping of customers to specific revenue, receivable, and other relevant GL accounts, ensuring accurate and automated financial integration between the logistics and general ledger subledgers.

Key Information Stored

The table's primary function is to define unique customer GL account class codes and their associated descriptions. The primary key column, CUSTGL_CLASS, stores the unique identifier for each account class. While the provided metadata does not list all columns, a typical structure for such a reference table would include a mandatory description column (e.g., DESCRIPTION) to define the class's purpose. The presence of a foreign key relationship to the OP_TEXT_HDR table via a TEXT_CODE column indicates the table supports extensive descriptive text or notes for each class, which can be stored in a separate flexfield or notes table.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the customer-to-GL account mapping framework. During customer creation or maintenance in OPM, a user assigns a Customer GL Account Class from this table. This class then determines the default GL accounts used for that customer's transactions. Common queries involve listing all defined classes for setup purposes or identifying which classes are assigned to customers. A sample query to retrieve all active classes might be:

  • SELECT custgl_class, description FROM gml.op_cgld_cls WHERE enabled_flag = 'Y' ORDER BY 1;

Another critical use case is troubleshooting financial posting errors by tracing the GL accounts assigned via this class through the related GL_ACCT_MAP table. Reports analyzing customer segmentation for financial reporting would also join customer master data to this table to group results by GL account class.

Related Objects

OP_CGLD_CLS is a central hub referenced by several key transactional and setup tables. As per the metadata, it has foreign key relationships with:

  • GL_ACCT_MAP: This table likely holds the specific GL account combinations mapped to each CUSTGL_CLASS, defining the actual accounting flexfields.
  • OP_CUST_MST_OPM and OP_CUST_MST: These customer master tables store the CUSTGL_CLASS assigned to each customer, linking the customer record to its financial accounting rules.
  • OP_TEXT_HDR: Provides additional descriptive text for the account class, supporting detailed documentation.

This structure confirms that OP_CGLD_CLS is a mandatory setup entity; its classes must be defined and mapped to GL accounts before customers can be fully configured for transaction processing in the GML module.