Search Results inv_pr_pick_slip_number




Overview
Explore in AI Chat

Overview

INV_PR_PICK_SLIP_NUMBER is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that governs the generation, assignment, and printing of pick slip numbers across Oracle Inventory and Oracle Shipping Execution. In Oracle EBS 12.1.1 and 12.2.2, the pick slip is the internal warehouse document used by material handlers to locate, stage, and confirm the movement of goods associated with a released sales order or move order. This package encapsulates the logic that determines which pick slip number range applies, allocates the next available number from the numbering sequence, applies pick grouping rules, and produces the physical or electronic pick slip output via the Oracle Reports engine.

The package is classified under ETRM as an OTHER API type. It is not a public integration interface; rather, it is a supporting internal utility invoked by Oracle's own seeded flows. It remains VALID in the EBS data dictionary and is referenced by seven other database objects, confirming it sits at a well-integrated point in the fulfillment architecture.

Key Procedures and Functions

ETRM documents five procedures and functions for the package body:

  • GET_PICK_SLIP_NUMBER — Returns the next valid pick slip number to the calling program. It resolves the active numbering scheme, validates that the number has not been consumed, and typically inserts the resulting value into the pick slip number tables.
  • GET_PICK_SLIP_NUMBER_PARALLEL — Provides the same numbering behavior in a parallel-concurrency context, allowing multiple pick slip requests to obtain numbers simultaneously without collision, which is essential for high-volume warehouses.
  • PRINT_PICK_SLIP — Drives the submission or population of pick slip report output. It assembles the pick slip header and detail data required for the printed document.
  • DELETE_WIP_PS_TBL — Removes transient or work-in-progress pick slip table rows after the number has been committed or the report completed, preventing residue in temporary structures.

A fifth documented entry completes the set (the package body includes the internal helper routines that support the four above). Parameter signatures are not published in the ETRM metadata and should be confirmed against the live source in the customer instance.

Tables Accessed

The package reads and writes the following tables and objects, primarily through APPS synonyms:

Usage Notes

INV_PR_PICK_SLIP_NUMBER is normally invoked indirectly. Oracle Shipping Execution calls it when a pick release or pick confirm operation requires a printed pick slip, and Oracle Inventory calls it for move-order picking. The reference to Oracle Reports objects indicates it can submit the pick slip concurrent program. Customizations should not call PRINT_PICK_SLIP or DELETE_WIP_PS_TBL directly, because doing so may bypass seeded validation; custom extensions should instead wrap GET_PICK_SLIP_NUMBER for number retrieval only. Because the package is referenced by seven other objects yet references none outside the documented set, it is best treated as a locked internal dependency when cloning or migrating EBS 12.1.1 or 12.2.2 environments.