Results for “gl_category_id”

50+ results




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

Overview

IC_GLED_CLS_VW is a read-only compatibility view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the GMI (Process Manufacturing Inventory) product family and exists to preserve backward compatibility for General Ledger (GL) classes. In the Process Manufacturing data model, GL classes are stored as OPM categories assigned to a category set flagged as GL_CLASS in GMI_CATEGORY_SETS. Older OPM code paths and interfaces expected a dedicated GL class table; this view reconstitutes that legacy presentation from the standard Oracle Inventory category tables, allowing dependent forms, reports, and integrations to continue functioning without schema changes.

The view is frequently referenced when users or developers search for gl_category_id, since the identifier for a GL class must be resolved through this view or its underlying category tables rather than a standalone GL class entity.

Underlying Base Objects

The ETRM metadata documents four referenced objects:

  • MTL_CATEGORIES_V — the category view supplying the concatenated segment string, description, and audit columns.
  • MTL_CATEGORY_SETS — the inventory category set header, providing STRUCTURE_ID and VALIDATE_FLAG.
  • GMI_CATEGORY_SETS — the OPM extension table that identifies which category sets represent GL classes via OPM_CLASS = 'GL_CLASS'.
  • MTL_CATEGORY_SET_VALID_CATS — the valid category assignments, used only when the category set enforces validation (VALIDATE_FLAG = 'Y').

The view is a UNION ALL of two branches. The first branch handles category sets where VALIDATE_FLAG is not 'Y'; the second branch joins MTL_CATEGORY_SET_VALID_CATS to restrict results to actively validated categories when VALIDATE_FLAG = 'Y'. Both branches join category set to structure to category on STRUCTURE_ID, and both filter on C.CATEGORY_CONCAT_SEGS = UPPER(SUBSTRB(C.CATEGORY_CONCAT_SEGS, 1, 8)), restricting output to concatenated GL class names of eight characters or fewer that are already uppercase.

Key Columns

Common Use Cases and Queries

Typical scenarios include resolving a GL class name to its category ID, listing all enabled GL classes for a subledger interface, and validating that a GL class referenced by a process manufacturing transaction still exists and is active.

To locate a GL class by identifier:

SELECT gl_category_id, icgl_class, icgl_class_desc
FROM   apps.ic_gled_cls_vw
WHERE  gl_category_id = :p_category_id;

To list all active GL classes:

SELECT icgl_class, gl_category_id, icgl_class_desc
FROM   apps.ic_gled_cls_vw
WHERE  delete_mark = 0
ORDER BY icgl_class;

Because the view filters to uppercase, eight-character class names, rows outside that convention are excluded; integrations relying on longer or mixed-case GL class names should query MTL_CATEGORIES_V and GMI_CATEGORY_SETS directly.