Search Results add_container_wt_vol
Overview
The APPS.WSH_WV_UTILS package is a utility package within the Oracle E-Business Suite Shipping (WSH) module. Its primary business function is to support weight and volume (W/V) calculations for containers, deliveries, and delivery details throughout the outbound logistics and packing process. The package name itself—WSH (Shipping) and WV (Weight/Volume)—reflects its role as a supporting library for the weight and volume features that underpin container packing, delivery manifesting, and shipping documentation across Oracle EBS 12.1.1 and 12.2.2.
The package abstracts the complexity of unit-of-measure (UOM) conversion and weight/volume aggregation so that higher-level shipping flows—container packing, delivery confirmation, and post-processing of weight/volume data—can reliably compute the correct physical attributes of shipments. It is classified as an "OTHER" API, meaning it is not a public, formally supported interface but rather an internal utility invoked by other Shipping components, including the packing ECO introduced for OTM (Oracle Transportation Management) in R12.
Key Procedures and Functions
The package exposes twenty documented procedures and functions. The most commonly referenced is DELIVERY_WEIGHT_VOLUME, which computes and returns aggregate weight and volume figures for a delivery by consolidating its delivery details and containers. Supporting procedures include:
- CONVERT_UOM and CONVERT_UOM_CORE — convert a quantity from one UOM to another by invoking inventory conversion routines; CONVERT_UOM is pragma-restricted (WNDS) so it can be called within SQL statements.
- GET_DEFAULT_UOMS — retrieves the default weight and volume UOM codes defined for an organization from the shipping parameters.
- DETAIL_WEIGHT_VOLUME — calculates weight and volume at the delivery-detail level.
- ADD_CONTAINER_WT_VOL and UPDATE_CONTAINER_WT_VOL — insert and modify container weight and volume records.
- CONTAINER_WEIGHT_VOLUME and CONTAINER_TARE_WEIGHT_SELF — derive a container's gross/net weight and its own tare weight.
- CALC_CONT_FILL_PC and CHECK_FILL_PC — compute and validate container fill percentage.
- DD_WV_POST_PROCESS and DEL_WV_POST_PROCESS — post-process weight/volume data at the delivery-detail and delivery levels after packing or confirmation.
- ADJUST_PARENT_WV — cascades weight/volume adjustments from child to parent containers.
- WITHIN_DEVIATION — evaluates whether calculated values fall within an acceptable tolerance.
- PRORATE_WEIGHT — allocates weight proportionally across details or containers.
Tables Accessed
The package reads and writes several core Shipping and Inventory tables through APPS synonyms. WSH_SHIPPING_PARAMETERS supplies the default weight and volume UOMs. WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS, and WSH_TRIP_STOPS provide the delivery, assignment, routing, and stop context required to aggregate weight and volume. MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE support item-level weight/volume attributes and UOM conversion factors. The PLITBLM table is referenced as a PL/SQL table type used for internal collections. These tables are accessed to obtain physical item data, validate conversions, and persist computed container and delivery weight/volume values.
Usage Notes
WSH_WV_UTILS is not invoked directly by end users. It is called internally by Shipping forms (such as container packing and delivery confirmation), by concurrent programs that process weight and volume post-processing, and by other Shipping packages. The metadata indicates that it is referenced by 61 other packages, confirming its role as a shared utility. Customizations should invoke it only through the supported shipping flows; developers extending shipping logic may call DELIVERY_WEIGHT_VOLUME or the conversion routines, but must respect that parameter signatures are documented only in limited form and that the package is an "OTHER"-classified internal utility. The OTM R12 packing ECO flag (G_RESET_WV) governs reset behavior during packing, reflecting the package's integration with R12 transportation enhancements.