Results for “ic_phys_cnt”

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

Overview

IC_PHYS_CNT is a table in the GMI schema (Process Manufacturing Inventory) that stores physical inventory and cycle count records in Oracle EBS 12.1.1 and 12.2.2. It records the results of counting on-hand inventory by item, warehouse, lot, and location, capturing counted quantities, count personnel, and reconciliation indicators. The table is central to inventory accuracy processes, providing the transactional evidence used to adjust on-hand balances when physical counts differ from system quantities.

Under a heuristic Data Vault classification derived from its foreign key structure, IC_PHYS_CNT is best modeled as a link entity. It sits at the intersection of several reference and master entities — items, warehouses, lots, locations, grades, reason codes, and text headers — and records the association between a count event and those dimensions. This classification is a modeling suggestion only; the physical implementation is a conventional relational table with a composite primary key.

Key Information Stored

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

• CYCLE_ID — Identifier of the cycle count or physical inventory cycle to which the record belongs.
• COUNT_NO — Sequence number of the count within the cycle, supporting multiple counts per item.
• ITEM_ID — The inventory item being counted.
• WHSE_CODE — Warehouse in which the count occurred.
• LOT_ID — Lot or batch associated with the counted material.
• LOCATION — Storage location within the warehouse.
• GRADE_CODE — Quality grade assigned to the counted material.
• COUNT_DATE — Date the physical count was performed.
• PERPQTY_1 / PERPQTY_2 — Counted perpetual quantities, typically supporting primary and secondary units of measure.
• COUNT_PERSON — The individual who performed the count.
• FINALCOUNT_IND — Indicates whether the record represents the final, reconciling count.
• REASON_CODE — Reason for a count variance or adjustment.
• TRANS_CNT — Transaction count or reference used in reconciliation.
• TEXT_CODE — Link to associated text or remarks via IC_TEXT_HDR.
• FOUND_ITEM_INDICATOR — Flags items discovered but not expected at the location.

The surrogate primary key is IC_PHYS_CNT_PK, composed of CYCLE_ID, COUNT_NO, ITEM_ID, WHSE_CODE, LOT_ID, LOCATION. This composite uniquely identifies a count line and also serves as the principal business-key candidate. Standard audit columns (CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, DELETE_MARK) are also present.

Common Use Cases and Queries

Typical scenarios include reconciling counted quantities against perpetual balances, reporting count variances by warehouse or item, and auditing who performed counts and when. A representative query joining counts to items and warehouses:

• Variance reporting: compare PERPQTY_1 against on-hand quantity for a given CYCLE_ID and FINALCOUNT_IND = 'Y'.
• Grade analysis: join GRADE_CODE to GMD_GRADES_B to review graded material by lot.
• Operator productivity: aggregate COUNT_PERSON by COUNT_DATE.
• Reason-code trending: group REASON_CODE joins to SY_REAS_CDS_B for adjustment root-cause analysis.
• Unexpected-item review: filter FOUND_ITEM_INDICATOR for found items not on the expected list.

Related Objects

The documented foreign keys reference the following objects:

• GMD_GRADES_B — joined via IC_PHYS_CNT.GRADE_CODE; supplies grade definitions.
• QC_GRAD_MST — also joined via GRADE_CODE, providing quality grade master data.
• IC_TEXT_HDR — joined via TEXT_CODE; supplies text/note headers for count remarks.
• SY_REAS_CDS_B and SY_REAS_CDS — joined via REASON_CODE; supply reason-code descriptions and translations.

These relationships make IC_PHYS_CNT a hub for reconciling count transactions against item, warehouse, grade, and reason-code master data within Process Manufacturing Inventory.