Results for “ic_phys_cnt”

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

Overview

SY_REAS_CDS is the Reason Code definition table within the Oracle EBS Process Manufacturing (GMA) module. It serves as the central repository for reason code definitions that describe and qualify increases or decreases in inventory. Reason codes are attached to transactions to flag why a particular inventory movement, order change, or receipt adjustment occurred, providing auditability and analytical context for material and order activity.

The table is not implemented in every Oracle EBS 12.1.1 or 12.2.2 database; its presence depends on whether Process Manufacturing and the associated inventory/order management flows are licensed and configured. From a Data Vault modeling perspective, the metadata's heuristic classification identifies SY_REAS_CDS as hub-leaning: it holds a relatively stable, unique set of business keys (reason codes) referenced by many surrounding transactional tables, which is the classic profile of a reference or hub entity.

Key Information Stored

The table is primarily a compact reference/lookup structure. Its documented columns center on the following:

• REASON_CODE — the surrogate primary key (SY_REAS_CDS_PK) and the principal business-key candidate. Every dependent table joins to SY_REAS_CDS through a column that ultimately resolves to this value, whether it is named REASON_CODE, RETURN_CODE, CANCELLATION_CODE, CLOSURE_CODE, POHOLD_CODE, BPOHOLD_CODE, or CHANGEREAS_CODE.
• TEXT_CODE — a foreign key to SY_TEXT_HDR, linking each reason code to descriptive text maintained centrally. This allows the meaning of a reason code to be stored and translated without embedding free text directly in SY_REAS_CDS.

Because the documented metadata lists only these two named columns explicitly, the table should be treated as a lean definition table: the reason code identifier, the associated text reference, and possibly additional descriptive or categorization attributes that are not enumerated in the excerpt. The REASON_CODE column is both the primary key and the primary business-key candidate, since no separate unique index is documented beyond SY_REAS_CDS_PK.

Common Use Cases and Queries

Typical usage involves decoding reason codes on inventory, transfer, and order transactions, and validating that a given reason code exists before attaching it to a transaction. A common pattern is to join SY_REAS_CDS to SY_TEXT_HDR to retrieve the human-readable description for reporting:

• Listing all defined reason codes: SELECT reason_code FROM sy_reas_cds;
• Resolving descriptions: SELECT r.reason_code, t.<text_column> FROM sy_reas_cds r, sy_text_hdr t WHERE r.text_code = t.text_code;
• Auditing inventory adjustments by reason: joining SY_REAS_CDS to IC_TRAN_CMP, IC_TRAN_PND, or IC_TRAN_ARC on REASON_CODE to aggregate movement quantities by reason.
• Validating reason-coded transfer activity: joining to IC_XFER_MST on RELEASE_REASON_CODE, RECEIVE_REASON_CODE, or CANCEL_REASON_CODE.
• Analyzing order changes and cancellations: joining to PO_ORDR_HDR/PO_ORDR_DTL on POHOLD_CODE or CANCELLATION_CODE, and to OP_ORDR_HDR/OP_ORDR_DTL on CHANGEREAS_CODE.

These queries are used in inventory reconciliation reports, audit trails, and reason-code usage analytics that reveal why stock levels or orders changed.

Related Objects

SY_REAS_CDS is referenced by a broad set of transactional and configuration tables. The most significant are:

• SY_TEXT_HDR — referenced by SY_REAS_CDS.TEXT_CODE; supplies the descriptive text for each reason code.
• IC_TRAN_ARC, IC_TRAN_CMP, IC_TRAN_PND — inventory transaction archive, complete, and pending tables, each referencing REASON_CODE.
• IC_ADJS_JNL (REASON_CODE) and IC_PHYS_CNT (REASON_CODE) — adjustment journals and physical count records.
• IC_XFER_MST — references REASON_CODE via RELEASE_REASON_CODE, RECEIVE_REASON_CODE, and CANCEL_REASON_CODE.
• PO_ORDR_HDR/PO_ORDR_DTL — reference POHOLD_CODE and CANCELLATION_CODE.
• PO_BPOS_HDR/PO_BPOS_DTL — reference BPOHOLD_CODE, CANCELLATION_CODE, and CLOSURE_CODE.
• PO_RECV_HDR (REASON_CODE) and PO_RTRN_DTL (RETURN_CODE) — receipts and returns.
• OP_ORDR_HDR/OP_ORDR_DTL (CHANGEREAS_CODE) and PC_TRAN_PND (REASON_CODE) — process orders and pending process transactions.
• GL_ACCT_MAP (REASON_CODE) — accounting mapping configuration.

These relationships confirm the table's role as a shared reference hub feeding inventory, purchasing, and process order submodules.