Search Results mtl_onhand_quantities_s




Overview
Explore in AI Chat

Overview

WMS_UT_PKG is a utility package body in the APPS schema that supports the Oracle Warehouse Management (WMS) unit-testing framework. Its name derives from "Warehouse Management System Unit Test." Rather than implementing core warehouse business logic, the package provides the orchestration, data-setup, data-teardown, and output-formatting infrastructure used to execute repeatable unit tests against WMS and Inventory APIs within an Oracle E-Business Suite environment. It is classified as an OTHER API in ETRM and is documented as VALID in both 12.1.1 and 12.2.2.

Because it depends on a broad set of transactional, reservation, shipping, and order-management packages, WMS_UT_PKG is able to construct realistic test scenarios — building on-hand quantities, reservations, move orders, and license plates — and then exercise the public APIs that manipulate them. The metadata confirms the package is referenced by zero other packages, indicating it is a terminal (leaf) utility rather than a reusable library invoked by production code.

Key Procedures and Functions

The documented entry points fall into several functional groups. Initialization and registry routines include INDT and INITIALIZE, which prepare the test harness. Case and flow management are handled by IMPORT_TEST_CASES, GET_FLOW_MASK, GET_MASK, GATHER_AND_SETUP, and EXECUTE_UT_TEST_FLOW, which together load test definitions and drive their execution.

Object-creation and cleanup routines include CREATE_UT_TABLES, CREATE_UT_SEQ, CREATE_UT_DATATYPES, and CREATE_WMS_UT123_PKG, forming the setup side; DROP_UT_TABLES, DROP_UT_SEQ, and DROP_UT_PKG provide the corresponding teardown. Data-type and value helpers GET_DATATYPE_ID and GET_VALUE resolve metadata used to parameterize generated test cases. Output utilities WRITE_TO_OUTPUT, WRITE_UT_TEST_OUTPUT, PARSE_TEXT, and PRINT_DEBUG format results and diagnostic messages for review. The list totals twenty-one documented procedures/functions; parameter lists are not published in the metadata and are therefore not restated here.

Tables Accessed

WMS_UT_PKG reads and writes inventory and warehouse tables through APPS synonyms. Quantity and transaction context come from MTL_ONHAND_QUANTITIES_S, MTL_ONHAND_QUANTITIES_DETAIL, MTL_MATERIAL_TRANSACTIONS_S, MTL_MATERIAL_TRANSACTIONS_TEMP, and MTL_GEN_OBJECT_ID_S. Item and location context come from MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, MTL_PARAMETERS, MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, and MTL_MATERIAL_STATUSES. Reservation and order fixtures use MTL_RESERVATIONS and MTL_SALES_ORDERS.

Usage Notes

This package is not typically called from standard EBS forms or concurrent programs. It is invoked directly by developers and QA engineers running the WMS unit-test harness, usually from SQL*Plus or a test driver, to assemble fixtures from the inventory tables above, execute API test flows, and emit formatted output to UTL_FILE targets. Because the metadata records no downstream referencing packages, its use should remain confined to controlled test cycles, and any schema objects created by CREATE_UT_TABLES or CREATE_UT_SEQ should be removed via the matching DROP routines.