Search Results get_datatype_id

Overview

WMS_UT_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that serves as the unit-testing framework for the Warehouse Management System (WMS) modules. The suffix "UT" denotes "unit test," and the package provides the utility infrastructure required to build, populate, execute, and tear down automated test flows against WMS and Inventory data structures. It is not a business-facing API; rather, it is an internal engineering and quality-assurance utility used by Oracle development and by implementation teams performing regression testing of WMS logic. The package is documented with 21 procedures and functions and is classified under API classification OTHER, indicating it is not an open public interface. It references the SYS.STANDARD package, confirming only foundational PL/SQL dependencies. The package status is VALID in both Oracle EBS 12.1.1 and 12.2.2. It is not referenced by any other packaged object, reinforcing its role as a self-contained test harness rather than a shared service.

Key Procedures and Functions

The 21 documented subprograms fall into several functional groups:

• Lifecycle control: INITIALIZE, GATHER_AND_SETUP, and DROP_UT_TABLES prepare the test environment and release resources afterward.
• DDL generation: CREATE_UT_TABLES, CREATE_UT_SEQ, CREATE_UT_DATATYPES, and CREATE_WMS_UT123_PKG dynamically generate temporary tables, sequences, datatype definitions, and a numbered test package.
• Cleanup: DROP_UT_TABLES, DROP_UT_SEQ, and DROP_UT_PKG remove the generated objects.
• Metadata lookup: GET_FLOW_MASK, GET_MASK, GET_DATATYPE_ID, GET_VALUE, and PARSE_TEXT resolve flow identifiers, masks, datatype identifiers, and textual values required to drive test cases.
• Execution and reporting: EXECUTE_UT_TEST_FLOW, IMPORT_TEST_CASES, WRITE_TO_OUTPUT, WRITE_UT_TEST_OUTPUT, PRINT_DEBUG, and INDT drive the flow execution and produce diagnostic output.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect purpose only.

Tables Accessed

The package operates against a broad set of Inventory tables accessed through APPS synonyms, which is consistent with a WMS test harness that must simulate receiving, put-away, reservation, and transaction flows. Referenced tables include MTL_SYSTEM_ITEMS and MTL_PARAMETERS for item and organization setup; MTL_SECONDARY_INVENTORIES and MTL_ITEM_LOCATIONS for storage location context; MTL_ONHAND_QUANTITIES_DETAIL and MTL_ONHAND_QUANTITIES_S for inventory balances; MTL_MATERIAL_TRANSACTIONS_S, MTL_MATERIAL_TRANSACTIONS_TEMP, and MTL_GEN_OBJECT_ID_S for transaction staging and ID generation; MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS (with MTL_SERIAL_NUMBERS_TEMP) for lot and serial control; MTL_RESERVATIONS for allocation testing; MTL_MATERIAL_STATUSES for status validation; and MTL_SALES_ORDERS for sales-order-driven movement. These reads and writes support end-to-end verification of WMS transactional logic.

Usage Notes

WMS_UT_PKG is invoked from custom test harnesses and internal Oracle regression suites rather than from standard application forms or concurrent programs. Because it generates and drops database objects, it should be executed only in non-production environments under controlled conditions. Its function names such as PRINT_DEBUG and WRITE_UT_TEST_OUTPUT indicate reliance on DBMS_OUTPUT, so callers should enable server output when diagnosing failures. As the package is unreferenced by other APPS packages, changes to it carry minimal risk to standard WMS functionality, but any modifications should still be validated against the full regression flow in both 12.1.1 and 12.2.2.