Results for “count_class”

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

Overview

IC_CRUL_CLS is a configuration table owned by the GMI schema within the Oracle E-Business Suite Process Manufacturing Inventory module (OPM Inventory). It serves as the count class definition table, holding the master list of count classes used during physical inventory counting and cycle count activities in process manufacturing environments. Count classes provide a classification mechanism that groups inventory items or warehouses for counting purposes, allowing organizations to define counting rules such as whether items with zero balances or negative balances should be included in a count, and whether transactions are permitted during the count window.

The table is registered in ETRM with status VALID and contains 12 documented columns in the 12.2.2 physical schema. Under the heuristic Data Vault classification mined from its foreign key structure, IC_CRUL_CLS is characterized as satellite-leaning. This suggests that, in a dimensional or Data Vault model, the table is best treated as descriptive context attached to a business key rather than as a standalone hub or a pure transactional link. The business key is COUNT_CLASS, enforced by the unique index IC_CRUL_CLS_PK.

Key Information Stored

The most significant columns in this table are:

• COUNT_CLASS — The primary key and business key candidate, uniquely identifying each count class. Enforced by unique index IC_CRUL_CLS_PK.
• COUNT_DESC — The descriptive name or label for the count class, used in user-facing lists and reports.
• ZEROBAL_IND — Indicator controlling whether items with a zero on-hand balance are included when the count class is applied.
• NEGATIVEBAL_IND — Indicator governing whether items with negative balances are eligible for counting under this class.
• TRANS_CNT — Transaction count or related transaction control value associated with the count class.
• TEXT_CODE — Foreign key referencing IC_TEXT_HDR, linking the count class to descriptive text stored in the text header table.
• DELETE_MARK — Standard soft-delete flag used across GMI tables.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns tracking record creation and modification.

The primary key is the surrogate-style COUNT_CLASS column; there is no separately documented numeric surrogate, so COUNT_CLASS doubles as both the business key and the physical key. The remaining columns provide the descriptive attributes that justify the satellite-leaning classification.

Common Use Cases and Queries

Count classes are consumed during physical inventory and cycle count setup. A typical query retrieves all active count classes with their balance-handling rules:

• SELECT COUNT_CLASS, COUNT_DESC, ZEROBAL_IND, NEGATIVEBAL_IND FROM IC_CRUL_CLS WHERE DELETE_MARK = 0;
• Joining to IC_WHSE_INV to list warehouses assigned to a given count class: SELECT W.WHSE_CODE, C.COUNT_DESC FROM IC_WHSE_INV W, IC_CRUL_CLS C WHERE W.COUNT_CLASS = C.COUNT_CLASS;
• Retrieving descriptive text via the text header: SELECT C.COUNT_CLASS, T.TEXT FROM IC_CRUL_CLS C, IC_TEXT_HDR T WHERE C.TEXT_CODE = T.TEXT_CODE;
• Reporting on count classes configured to include zero or negative balances for audit purposes.

These patterns support count sheet generation, warehouse count configuration validation, and reconciliation reporting.

Related Objects

• IC_TEXT_HDR — Referenced by IC_CRUL_CLS.TEXT_CODE; supplies long descriptive text for a count class.
• IC_WHSE_INV — References IC_CRUL_CLS through its COUNT_CLASS column, assigning count classes to warehouse inventory records. This is the principal dependent table.
• IC_CRUL_CLS_PK — The unique index enforcing the COUNT_CLASS business key.
• Physical inventory count and cycle count processing logic within OPM Inventory, which reads count class rules when building count requests.
• GMI inventory inquiry and setup forms that present count class definitions to users.