Search Results ic_whse_sts




Overview
Explore in AI Chat

Overview

The IC_WHSE_STS table is a core data object within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for tracking the period-end closing status of warehouses. Its primary role is to enforce financial and operational control by recording whether a specific warehouse has been closed for a given accounting period, thereby preventing further transactional activity in a closed period and ensuring the integrity of inventory period balances. This table is essential for the period-end closing procedures in Process Manufacturing environments.

Key Information Stored

The table's structure is defined by its primary keys and foreign key relationships. The primary data points stored are the warehouse code, the period identifier, and the fiscal accounting details. Key columns include:

  • WHSE_CODE: Identifies the specific warehouse, linked to the IC_WHSE_MST master table.
  • PERIOD_ID: A unique identifier for the accounting period, linked to the IC_CLDR_DTL (Calendar Detail) table.
  • FISCAL_YEAR and PERIOD: Represent the fiscal year and period number, forming an alternate unique key for the record.

The presence of a record for a given PERIOD_ID and WHSE_CODE combination typically indicates that the warehouse is closed for that period, controlling the flow of inventory transactions.

Common Use Cases and Queries

The primary use case is validating warehouse status during transaction posting and generating period-close reports. A common operational query checks if a warehouse is open for a specific item transaction. For example:

SELECT 'CLOSED' FROM ic_whse_sts WHERE whse_code = :p_whse AND period_id = :p_period_id;

For reporting, a join to the warehouse master and calendar tables provides a readable status list:

SELECT w.whse_code, w.whse_desc, c.period_code, s.fiscal_year, s.period FROM ic_whse_sts s, ic_whse_mst w, ic_cldr_dtl c WHERE s.whse_code = w.whse_code AND s.period_id = c.period_id ORDER BY s.fiscal_year, s.period, w.whse_code;

This is critical for financial controllers and inventory managers overseeing the closing cycle.

Related Objects

IC_WHSE_STS is centrally connected to several key GMI tables. Its integrity is maintained through defined foreign key relationships:

  • IC_WHSE_MST: Provides the valid warehouse master data referenced by WHSE_CODE.
  • IC_CLDR_DTL: Provides the valid accounting period definitions referenced by PERIOD_ID.
  • IC_PERD_BAL: The period balance table has a foreign key relationship referencing IC_WHSE_STS, indicating that period balances are maintained for warehouses in a specific closing status.

This network of relationships ensures that closing status is consistently applied across inventory transactions, balances, and financial reporting within the Process Manufacturing suite.