Search Results ic_alot_prm




Overview
Explore in AI Chat

Overview

The IC_ALOT_PRM table is a GMI (Process Manufacturing Inventory) configuration table that stores automatic lot allocation parameters. It is owned by the GMI schema and holds the rules that determine how Oracle Process Manufacturing selects and allocates inventory lots when fulfilling an inventory transaction. Each row defines an allocation policy scoped to a specific allocation class and warehouse, giving the application the criteria (method, type, quantity limits, and time horizons) used to drive automated lot selection during picking, staging, and consumption.

Under the heuristic Data Vault classification derived from its foreign key structure, this table is best modeled as a link. It captures the association between an allocation class (IC_ALLC_CLS) and a warehouse (IC_WHSE_MST), acting as the intersection that binds those two reference entities to a set of operational parameters. In dimensional terms it behaves as a configuration/relationship entity rather than a transactional fact or a master hub.

Key Information Stored

The table's unique business key is defined by the composite primary key IC_ALOT_PRM_PK, spanning ALLOC_CLASS and WHSE_CODE. Together these two columns identify a single parameter row: the allocation class to which the rule applies and the warehouse in which it is enforced. This composite index is the documented unique business-key candidate; there is no separate single-column surrogate key.

  • ALLOC_CLASS — the allocation class this parameter set governs (FK to IC_ALLC_CLS).
  • WHSE_CODE — the warehouse within which the rule is active (FK to IC_WHSE_MST).
  • ALLOC_METHOD — the allocation method used to rank and select lots.
  • ALLOC_TYPE — the allocation type that further qualifies the rule behavior.
  • ALLOC_CATEGORY_ID — identifier linking the rule to an allocation category.
  • SHELF_DAYS — shelf-life threshold in days used to filter eligible lots.
  • ALLOC_HORIZON — the time horizon over which allocation eligibility is evaluated.
  • LOT_QTY — the lot quantity parameter applied during allocation.
  • TEXT_CODE — reference to descriptive text (FK to IC_TEXT_HDR).
  • TRANS_CNT — transaction counter maintained by the application.
  • DELETE_MARK — soft-delete / logical deletion indicator.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns.

Common Use Cases and Queries

Typical uses include reviewing which allocation policy applies to a given class/warehouse combination, auditing shelf-life and horizon settings across facilities, and supporting lot-selection troubleshooting when automated allocation returns unexpected results. A common lookup retrieves the full parameter set for one warehouse:

  • SELECT ALLOC_CLASS, ALLOC_METHOD, ALLOC_TYPE, SHELF_DAYS, ALLOC_HORIZON, LOT_QTY FROM IC_ALOT_PRM WHERE WHSE_CODE = :whse AND DELETE_MARK = 0;
  • Joining to the warehouse master to label rules: ... FROM IC_ALOT_PRM p, IC_WHSE_MST w WHERE p.WHSE_CODE = w.WHSE_CODE;
  • Reporting parameter coverage by allocation class across all warehouses, grouped by ALLOC_CLASS.

Because the table is configuration data, extract and comparison reports are frequently used to reconcile allocation settings between environments during implementations and upgrades.

Related Objects

  • IC_WHSE_MST — joined on IC_ALOT_PRM.WHSE_CODE = IC_WHSE_MST.WHSE_CODE; the warehouse master that scopes each rule.
  • IC_ALLC_CLS — joined on IC_ALOT_PRM.ALLOC_CLASS = IC_ALLC_CLS.ALLOC_CLASS; defines the allocation class.
  • IC_TEXT_HDR — joined on IC_ALOT_PRM.TEXT_CODE = IC_TEXT_HDR.TEXT_CODE; supplies descriptive text.
  • IC_ALOT_PRM_PK — the composite unique index enforcing the ALLOC_CLASS/WHSE_CODE business key.

These relationships establish IC_ALOT_PRM as a link between warehouse and allocation-class reference data, with descriptive text attached via a secondary foreign key.