Results for “source_whse”

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

Overview

IC_WHSE_REL is a table owned by the GMI schema within Oracle E-Business Suite, belonging to the Process Manufacturing Inventory module. It functions as the warehouse transfer rules table, storing the definitions that govern how inventory items may be transferred between warehouses. The records it holds are consumed by the MRP (Material Requirements Planning) engine, which uses the transfer rules to determine valid sourcing relationships, replenishment behavior, and lead-time expectations when planning material movement across the warehouse network.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is link. IC_WHSE_REL sits at the intersection of warehouse and item master entities, resolving a many-to-many relationship between sources, destinations, and items while carrying its own descriptive attributes. This classification should be treated as a modeling suggestion rather than a documented architectural fact.

Key Information Stored

IC_WHSE_REL is documented with 22 columns in the ETRM 12.2.2 physical schema. The most significant are:

• WHSEREL_ID — surrogate primary key, defined by index IC_WHSE_REL_PK.
• SOURCE_WHSE and DEST_WHSE — the originating and receiving warehouses, both foreign keys to IC_WHSE_MST. Together with ITEM_ID they form the business-key candidate index IC_WHSE_REL_U1.
• ITEM_ID — the inventory item governed by the rule, referencing IC_ITEM_MST and IC_ITEM_MST_B.
• FIXED_LEADTIME and VARIABLE_LEADTIME — transfer lead-time components used in planning calculations.
• INNER_TIMEFENCE and OUTER_TIMEFENCE — time-fence boundaries controlling when transfer suggestions are generated.
• MIN_QTY, MAX_QTY, and STD_QTY — minimum, maximum, and standard transfer quantities.
• RULE_TYPE and PREFERENCE — the category of transfer rule and its ranking priority among competing sources.
• TRANSFER_TYPE — classifies the nature of the transfer.
• TEXT_CODE — foreign key to IC_TEXT_HDR, linking supplemental text notes.
• TRANS_CNT — transaction counter used for concurrency control.
• DELETE_MARK — soft-delete flag indicating logically removed rules.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical scenarios include auditing the transfer network for a given item, troubleshooting MRP sourcing suggestions, and reporting on lead times and quantity thresholds.

Rules for a specific item and warehouse pair:

• SELECT WHSEREL_ID, SOURCE_WHSE, DEST_WHSE, FIXED_LEADTIME, VARIABLE_LEADTIME, MIN_QTY, MAX_QTY, STD_QTY FROM GMI.IC_WHSE_REL WHERE ITEM_ID = :item_id AND DEST_WHSE = :whse AND DELETE_MARK = 0;

All outbound transfers from a source warehouse:

• SELECT SOURCE_WHSE, DEST_WHSE, ITEM_ID, RULE_TYPE, PREFERENCE FROM GMI.IC_WHSE_REL WHERE SOURCE_WHSE = :whse AND DELETE_MARK = 0 ORDER BY PREFERENCE;

Join to warehouse names for reporting:

• SELECT s.WHSE_NAME AS src, d.WHSE_NAME AS dest, r.ITEM_ID, r.TRANSFER_TYPE FROM GMI.IC_WHSE_REL r JOIN GMI.IC_WHSE_MST s ON r.SOURCE_WHSE = s.WHSE_CODE JOIN GMI.IC_WHSE_MST d ON r.DEST_WHSE = d.WHSE_CODE;

Related Objects

• IC_WHSE_MST — master warehouse table; referenced twice by SOURCE_WHSE and DEST_WHSE.
• IC_ITEM_MST and IC_ITEM_MST_B — item masters referenced via ITEM_ID.
• IC_TEXT_HDR — text header referenced via TEXT_CODE for rule notes.
• MRP planning processes — consume these rules to generate transfer suggestions.

Proper indexing on ITEM_ID, SOURCE_WHSE, and DEST_WHSE is essential given the table's role in high-volume planning execution.