Results for “ece_dsno_packed_quantity_v”

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

Overview

The view ECE_DSNO_PACKED_QUANTITY_V belongs to the Oracle e-Commerce Gateway product (module code EC) and is documented in Oracle ETRM as "No longer used." It was historically associated with outbound e-Commerce Gateway processing that required aggregated packed quantities for delivery and container information exchanged with external trading partners, typically in a standard EDI or flat-file dispatch advice message. The view consolidates shipped quantities from picking activity into a single packed quantity value per departure, delivery, container, inventory item, order line, and picking line combination.

Although the object retains a formal definition in the ETRM repository, the metadata records that it is "Not implemented in this database," meaning that in the Oracle EBS 12.1.1 and 12.2.2 environments covered by the reference documentation, the view is not created in the database schema. Consequently, it should not be queried or referenced by custom code, reports, or integrations, as doing so will produce an ORA-00942 (table or view does not exist) error at runtime.

Underlying Base Objects

The documented view text is defined over two Oracle Shipping execution tables:

• SO_PICKING_LINES_ALL — aliased as SPL in the view text; supplies item, order line, and picking line identifiers.
• SO_PICKING_LINE_DETAILS — aliased as SPLD; supplies departure, delivery, container, and shipped quantity detail.

The two tables are joined on PICKING_LINE_ID. The definition filters rows where NVL(SPLD.SHIPPED_QUANTITY, 0) > 0 and aggregates using SUM over the shipped quantity, grouping by DEPARTURE_ID, DELIVERY_ID, CONTAINER_ID, INVENTORY_ITEM_ID, ORDER_LINE_ID, and SPL.PICKING_LINE_ID. ETRM documentation for release 12.2.2 lists no additional referenced base objects and records the owner as blank, consistent with the view not being deployed.

Key Columns

• DEPARTURE_ID — Identifier of the shipping departure associated with the packed goods.
• DELIVERY_ID — Identifier of the delivery to which the packed quantity relates.
• CONTAINER_ID — Identifier of the container (LPN or carton) holding the packed items.
• INVENTORY_ITEM_ID — Internal identifier of the inventory item being shipped.
• ORDER_LINE_ID — Identifier of the originating sales order line.
• PICKING_LINE_ID — Identifier of the picking line from which the packed quantity was derived.
• PACKED_QUANTITY — The aggregated shipped quantity, computed as SUM(NVL(SPLD.SHIPPED_QUANTITY, 0)), representing the total units packed for the given grouping.

Common Use Cases and Queries

In earlier Oracle EBS releases, this view supported e-Commerce Gateway outbound transactions that reported packed shipment quantities by delivery and container, such as dispatch advice or shipment notification messages. Reporting teams occasionally reference it when investigating legacy shipping quantity aggregation logic.

Because the object is documented as no longer used and not implemented, the correct operational guidance is to avoid reliance on it entirely. If equivalent packed quantity data is required in EBS 12.1.1 or 12.2.2, the recommendation is to query the underlying Shipping execution tables directly, replicating the documented aggregation logic. A representative query mirroring the original view definition is shown below:

SELECT SPLD.DEPARTURE_ID, SPLD.DELIVERY_ID, SPLD.CONTAINER_ID,
  SPL.INVENTORY_ITEM_ID, SPL.ORDER_LINE_ID, SPL.PICKING_LINE_ID,
  SUM(NVL(SPLD.SHIPPED_QUANTITY, 0)) PACKED_QUANTITY
FROM SO_PICKING_LINES_ALL SPL, SO_PICKING_LINE_DETAILS SPLD
WHERE SPL.PICKING_LINE_ID = SPLD.PICKING_LINE_ID
  AND NVL(SPLD.SHIPPED_QUANTITY, 0) > 0
GROUP BY SPLD.DEPARTURE_ID, SPLD.DELIVERY_ID, SPLD.CONTAINER_ID,
  SPL.INVENTORY_ITEM_ID, SPL.ORDER_LINE_ID, SPL.PICKING_LINE_ID;

Any custom report or interface that references ECE_DSNO_PACKED_QUANTITY_V should be remediated to use this direct query pattern or an officially supported shipping data source instead.