Results for “wsh_packed_container_interface”

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

Overview

WSH_PACKED_CONTAINER_INTERFACE is a staging (open interface) table owned by the OE schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to hold packed container information prior to validation and import into the operational packing tables. External systems, mobile scanning devices, warehouse automation, and custom integrations write rows into this table, and the Oracle Warehouse Management / Shipping transaction interface programs consume them, validate them, and transfer the surviving records into the permanent packed container tables. The table is a transactional work table, not an operational master, and rows are conventionally purged or archived after a successful import run.

Modeled through Data Vault heuristics derived from its foreign key structure, this object leans toward a satellite classification. It carries descriptive and state attributes about containers within the context of a delivery interface transaction, rather than acting as an independent hub or as a pure many-to-many link. Treating it as a satellite keyed to its parent interface transaction and its container is a reasonable modeling suggestion.

Key Information Stored

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

• TRANSACTION_ID — foreign key to WSH_DELIVERIES_INTERFACE; binds each container row to the parent delivery interface transaction and is effectively the primary grouping key for the record.
• CONTAINER_ID — foreign key to WSH_PACKED_CONTAINERS; the business identifier of the container being staged.
• SEQUENCE_NUMBER and PARENT_SEQUENCE_NUMBER — define row ordering and the parent-child nesting of containers within the packing hierarchy.
• PARENT_CONTAINER_ID and MASTER_CONTAINER_ID — establish container structure, including the top-level master container.
• CONTAINER_INVENTORY_ITEM_ID and CONTAINER_INVENTORY_ITEM_NAME — identify the container as an inventory item.
• QUANTITY — quantity contained or packed.
• GROSS_WEIGHT, NET_WEIGHT, WEIGHT_UOM_CODE, VOLUME, VOLUME_UOM_CODE, and FILL_PERCENT — physical measurements used in packing and freight calculation.
• MASTER_SERIAL_NUMBER and SERIAL_NUMBER — serial control for the container and its contents.
• ORGANIZATION_ID and ORGANIZATION_CODE — the owning inventory organization.
• ERROR_CODE and ERROR_EXPLANATION — populated by the import program to record rows rejected during validation.

The metadata does not document unique indexes, so no confirmed business key can be asserted; however, the combination of TRANSACTION_ID, CONTAINER_ID, and SEQUENCE_NUMBER is the practical candidate for row uniqueness. Because the table has no described surrogate key column, no single documented column serves as a designated surrogate primary key.

Common Use Cases and Queries

Typical scenarios include bulk staging of container hierarchy from external warehouse systems, mobile packing verification, and pre-import error triage. A common operational query identifies rows that failed validation:

• SELECT TRANSACTION_ID, CONTAINER_ID, SEQUENCE_NUMBER, ERROR_CODE, ERROR_EXPLANATION FROM WSH_PACKED_CONTAINER_INTERFACE WHERE ERROR_CODE IS NOT NULL;

Reporting queries join to the parent delivery interface to reconcile staged containers against expected shipments, and join to WSH_PACKED_CONTAINERS to compare staged values with the eventual imported records:

• SELECT d.DELIVERY_ID, i.CONTAINER_ID, i.QUANTITY, i.GROSS_WEIGHT FROM WSH_PACKED_CONTAINER_INTERFACE i JOIN WSH_DELIVERIES_INTERFACE d ON i.TRANSACTION_ID = d.TRANSACTION_ID;
• SELECT i.CONTAINER_ID, i.QUANTITY AS STAGED_QTY, c.QUANTITY AS IMPORTED_QTY FROM WSH_PACKED_CONTAINER_INTERFACE i JOIN WSH_PACKED_CONTAINERS c ON i.CONTAINER_ID = c.CONTAINER_ID;

Related Objects

The following objects are the most significant for interaction with this interface table:

• WSH_DELIVERIES_INTERFACE — referenced by TRANSACTION_ID; supplies the parent delivery transaction context.
• WSH_PACKED_CONTAINERS — referenced by CONTAINER_ID; the operational table receiving imported container records.
• WSH_CONTAINERS_INTERFACE and related WSH interface tables — commonly processed in the same import run.
• WSH_PACKING_INTERFACE and the shipping transaction interface concurrent programs — the consumers that read this table.
• WSH_PACKED_CONTAINER_CONTENTS — operational contents table associated with packed containers.
• WSH_DELIVERY_DETAILS — delivery line detail used for reconciliation and packing validation.

Together these objects form the shipping packing interface pipeline within the OE and WSH modules.