Results for “op_cgld_cls”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_CGLD_CLS is a reference (setup) table in the Oracle E-Business Suite Process Manufacturing Logistics (GML) product, owned by the GML schema. It stores Customer GL Account Classes, which are user-defined classifications used to map customers to General Ledger account segments. In EBS 12.1.1 and 12.2.2, this table functions as a control point for customer-driven accounting derivation, allowing organizations to group customers into accounting classes rather than defining GL mappings for each individual customer.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as hub-leaning. Its single-column primary key, CUSTGL_CLASS, is referenced by several dependent tables as a foreign key, which is characteristic of a hub entity. Modelers should treat this as a heuristic suggestion: OP_CGLD_CLS behaves as a business-key hub whose descriptive attributes could be split into a satellite in a formal Data Vault design.

Key Information Stored

The table contains 10 documented columns. The most significant are:

• CUSTGL_CLASS — The primary key and the business-key candidate. This column uniquely identifies each Customer GL account class and is the column referenced by all downstream foreign keys.
• CUSTGL_CLASS_DESC — The descriptive name of the account class, used in setup forms and reports.
• TEXT_CODE — Foreign key to OP_TEXT_HDR, linking the class to a text header record for additional descriptive content.
• TRANS_CNT — A transaction or usage counter associated with the class record.
• DELETE_MARK — The standard soft-delete flag; records with this marker set are logically removed rather than physically deleted.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns capturing who created and last modified the record, and when.

The unique index OP_CGLD_CLS_PK is defined on CUSTGL_CLASS, confirming it as the sole business-key candidate. There is no separate surrogate key column documented; the business key itself serves as the primary key.

Common Use Cases and Queries

Typical usage centers on customer-to-GL account mapping, accounting setup validation, and reporting on customer accounting classifications. A common lookup joins the class to its text header:

SELECT c.CUSTGL_CLASS, c.CUSTGL_CLASS_DESC, t.TEXT_CODE
FROM GML.OP_CGLD_CLS c, GML.OP_TEXT_HDR t
WHERE c.TEXT_CODE = t.TEXT_CODE
AND c.DELETE_MARK = 0;

To identify customers assigned to each class, join to the customer master:

SELECT m.CUSTOMER_ID, m.CUSTGL_CLASS, c.CUSTGL_CLASS_DESC
FROM GML.OP_CUST_MST m, GML.OP_CGLD_CLS c
WHERE m.CUSTGL_CLASS = c.CUSTGL_CLASS;

Reporting use cases include auditing which GL account maps exist per class via GL_ACCT_MAP, and validating that every active customer references a valid, non-deleted class.

Related Objects

The following objects reference or depend on OP_CGLD_CLS through documented foreign key relationships:

• GL_ACCT_MAP — References OP_CGLD_CLS via GL_ACCT_MAP.CUSTGL_CLASS = OP_CGLD_CLS.CUSTGL_CLASS; holds the actual GL account mapping per class.
• OP_CUST_MST — References via OP_CUST_MST.CUSTGL_CLASS; the disposable customer master.
• OP_CUST_MST_OPM — References via OP_CUST_MST_OPM.CUSTGL_CLASS; the Process Manufacturing customer master.
• OP_TEXT_HDR — Referenced by OP_CGLD_CLS.TEXT_CODE, supplying descriptive text.

Together, these relationships establish OP_CGLD_CLS as the central hub linking customer records to their GL accounting treatment within Process Manufacturing Logistics.