Results for “cr_gled_cls”

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

Overview

CR_GLED_CLS is a table owned by the GMP schema (Process Manufacturing Process Planning) in Oracle EBS 12.1.1 and 12.2.2. Its documented description is Capacity G/L Class Code Descriptions. The table stores the code-and-description pairs that classify capacity and general ledger (G/L) entries produced by process manufacturing planning activities. These class codes act as the accounting dictionary used when capacity consumption, resource usage, or planning cost records must be mapped to a general ledger class for downstream costing and posting. The table is registered as VALID in ETRM and is referenced primarily as a lookup or reference object rather than a high-volume transactional table.

Under the heuristic Data Vault classification provided in the metadata, CR_GLED_CLS is satellite-leaning. This classification is mined from its foreign key structure, in which the single foreign key points to CR_TEXT_HDR for descriptive text rather than linking two or more independent business entities. Such a shape is characteristic of a satellite or descriptive attribute table: it holds attributes and descriptive context around a business key rather than embodying a relationship between hubs.

Key Information Stored

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

• CRGL_CLASS — the G/L class code and the sole column of the primary key CR_GLED_CLS_PK. It is the business-key candidate and the value referenced elsewhere in the capacity/G/L model.
• CRGL_CLASS_DESC — the human-readable description of the class code, used in lookup lists and reporting.
• TEXT_CODE — foreign key to CR_TEXT_HDR, providing extended descriptive or translated text.
• TRANS_CNT — a transactional counter or usage count associated with the class code.
• DELETE_MARK — soft-delete flag indicating whether the class code remains logically active.
• Creation and audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture record audit lineage.

Of note, the unique index CR_GLED_CLS_PK governs CRGL_CLASS alone, so the business key and the primary key are effectively the same column; there is no separate surrogate sequence key documented.

Common Use Cases and Queries

Reporting and operations frequently require resolving G/L class codes to their descriptions. A typical lookup query is:

• SELECT CRGL_CLASS, CRGL_CLASS_DESC FROM GMP.CR_GLED_CLS WHERE DELETE_MARK = 0 ORDER BY CRGL_CLASS;

To join descriptive text from the text header table:

• SELECT c.CRGL_CLASS, c.CRGL_CLASS_DESC, t.TEXT_CODE FROM GMP.CR_GLED_CLS c, GMP.CR_TEXT_HDR t WHERE c.TEXT_CODE = t.TEXT_CODE(+);

Analysts validating configuration use the audit and counter columns to identify inactive or heavily used class codes, filtering on TRANS_CNT or LAST_UPDATE_DATE. Because the table is low-volume and reference-oriented, it is suitable for extract-to-reporting-layer loads and for population of parameter value sets that drive capacity and G/L class selection in planning worksheets.

Related Objects

The documented FK relationship links CR_GLED_CLS to the text header object. The principal related objects are:

• CR_TEXT_HDR — referenced via CR_GLED_CLS.TEXT_CODE, supplying descriptive or language-specific text.
• CR_GLED_CLS_PK — the unique index on CRGL_CLASS, enforcing uniqueness of the class code.
• Process manufacturing capacity and G/L class setup and lookup views within the GMP schema that consume CRGL_CLASS as a selection value.
• Planning and costing reports, plus any value set or concurrent program that validates class codes against this table.

Administrators should treat CR_GLED_CLS as the authoritative source for G/L class code definitions within Process Planning, and should preserve the FK to CR_TEXT_HDR when migrating or cloning configuration.