Results for “autocreate_consol_delivery”

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

Overview

WSH_DELIVERY_AUTOCREATE is a PL/SQL package body owned by APPS in Oracle E-Business Suite. Its principal business function is the automatic creation and consolidation of shipping deliveries from eligible order and trip data, a process commonly referred to as "delivery auto-create" or, in user search terms, "wsh_tpa" (trip and delivery planning assistant context). The package evaluates order release lines and delivery details against a set of grouping and matching rules, selects candidates that satisfy shipping-date and requirement-date criteria, and then constructs deliveries and delivery legs in a controlled, set-based manner. It is a foundational technical component behind the Delivery Auto-Create concurrent program and related shipping execution infrastructure.

The package implements internal grouping and matching logic to prevent redundant or fragmented deliveries. A hash-based temporary grouping mechanism is used to consolidate comparable order lines so that matching groups can be identified efficiently before deliveries are generated. This design reflects the performance demands of high-volume order-to-shipment flows in Release 12.1.1 and 12.2.2.

Key Procedures and Functions

• AUTOCREATE_DELIVERIES — The primary driver that builds deliveries from eligible detail lines for a given organization, applying the configured grouping attributes.
• AUTOCREATE_DEL_ACROSS_ORGS — Extends auto-create processing across multiple inventory organizations in a single run.
• AUTOCREATE_CONSOL_DELIVERY — Creates or consolidates deliveries, grouping lines into existing or new delivery structures.
• GET_GROUP_BY_ATTR — Retrieves the group-by attribute flags for a delivery organization and stores them for subsequent comparisons during the auto-create run.
• CHECK_SCH_DATE_MATCH — Validates whether scheduled dates align for candidate lines eligible for grouping.
• CHECK_REQ_DATE_MATCH — Validates whether requirement dates align for candidate lines, supporting date-driven grouping rules.
• CREATE_HASH — Generates a hash key for delivery detail records used to bucket comparable lines.
• CREATE_UPDATE_HASH — Creates or updates hash entries as grouping information is refined.
• FIND_MATCHING_GROUPS — Identifies groups of detail lines that satisfy the matching criteria for delivery creation.
• RESET_WSH_TMP — Clears the WSH_TMP working area between processing cycles to avoid stale groupings.
• DELETE_EMPTY_DELIVERIES — Removes deliveries that contain no assigned details after processing.
• UNASSIGN_EMPTY_CONTAINERS — Releases containers left without delivery assignments.

Tables Accessed

The package reads and writes the core shipping execution tables. WSH_DELIVERY_DETAILS and WSH_DELIVERY_ASSIGNMENTS are the primary sources and targets for line-to-delivery relationships. WSH_NEW_DELIVERIES and WSH_DELIVERY_LEGS hold the newly created deliveries and their legs. WSH_TRIPS and WSH_TRIP_STOPS supply trip context, explaining the "wsh_tpa"-style search linkage. WSH_MATCH_GROUP_S, WSH_TMP, and PLITBLM support temporary grouping and hash storage. MTL_CLIENT_PARAMETERS supplies profile-style configuration, and MTL_SYSTEM_PARAMETERS-related shipping parameters are read through WSH_SHIPPING_PARAMS_PVT. DBMS_LOCK, DBMS_UTILITY, and DUAL are used for concurrency control and utility evaluation.

Usage Notes

WSH_DELIVERY_AUTOCREATE is typically invoked by the Delivery Auto-Create concurrent program and by Shipping Execution forms that trigger automatic delivery generation. It is referenced by 23 other packages, indicating its role as a shared service within the WSH module. Debug tracing is supported through WSH_DEBUG_SV and WSH_DEBUG_INTERFACE, enabling diagnostics during execution. Custom code should call the documented public procedures rather than internal hash or grouping routines, and should respect the organization and grouping-attribute parameters established for the shipping organization.