Search Results wsh_fm_serialno_null

Overview

WSH_TRXSN_HANDLER is an Oracle E-Business Suite shipping execution package that manages the bulk staging of serial number transaction data during shipping confirmation. Its central responsibility is to move serial number attributes from the shipping transaction interface structures into the MTL_SERIAL_NUMBERS_INTERFACE staging table so that inventory serial number transaction processing can subsequently validate and post the affected serials. The package is owned by APPS and is classified in ETRM as an OTHER object, meaning it is an internal implementation package rather than a formal public API.

The relationship to the search term "wsh_fm_serialno_null" is direct and significant: the FM_SERIAL_NUMBER column targeted by this package's INSERT_ROW_BULK routine is the interface field that must be populated for downstream serial transaction processing. When that column is left null, serial numbers fail to be associated with the originating transaction line, producing the condition users encounter as wsh_fm_serialno_null. WSH_TRXSN_HANDLER is therefore the front end of the data path that populates FM_SERIAL_NUMBER.

Key Procedures and Functions

The package exposes five documented procedures. All operate against the serial number interface data set.

• INSERT_ROW — Inserts a single serial number transaction interface record, transferring the inbound serial attributes into MTL_SERIAL_NUMBERS_INTERFACE.
• INSERT_ROW_BULK — The bulk counterpart to INSERT_ROW. It iterates the collection of interface records supplied by the caller and performs a FORALL insert of the entire set in one pass. This is the routine whose column list includes FM_SERIAL_NUMBER, TO_SERIAL_NUMBER, SOURCE_CODE and SOURCE_LINE_ID, together with the standard WHO columns and fifteen descriptive flexfield attributes (attribute_category through attribute15). The presence of attribute_category reflects the Bug 3628620 fix carried in this source.
• UPDATE_ROW — Modifies an existing serial number interface record, used when the staged serial data must be corrected before processing.
• DELETE_ROW — Removes a serial number interface record, supporting cleanup of rows that should not proceed to the inventory interface.
• LOCK_ROW — Acquires a lock on the target interface row to serialize concurrent updates to the same serial transaction record.

INSERT_ROW_BULK also initializes x_return_status to WSH_UTIL_CORE.G_RET_STS_SUCCESS and retrieves the current user through FND_PROFILE.GET('USER_ID') into the package-level variable g_userid, which supplies the CREATED_BY and LAST_UPDATED_BY audit values. Extensive WSH_DEBUG_SV logging is wrapped in a debug-enabled check controlled by WSH_DEBUG_INTERFACE.g_debug.

Tables Accessed

Three objects are documented as accessed through APPS synonyms:

• MTL_SERIAL_NUMBERS_INTERFACE — The primary target. INSERT_ROW and INSERT_ROW_BULK write serial number, source code, source line, transaction interface ID, FM_SERIAL_NUMBER and TO_SERIAL_NUMBER values, plus audit and flexfield columns. UPDATE_ROW, DELETE_ROW and LOCK_ROW operate on the same table.
• MTL_MATERIAL_TRANSACTIONS_S — Referenced for the underlying material transaction serial information associated with the shipping transaction being confirmed.
• PLITBLM — The standard Oracle Forms table-handling package used for maintaining the interface block records within the EBS forms runtime.

Usage Notes

WSH_TRXSN_HANDLER is invoked indirectly during the shipping confirmation flow, when serial-controlled items are being confirmed and their serial numbers must be staged for inventory processing. It is called from shipping execution PL/SQL rather than directly by end users; one other package in the ETRM inventory references it. Because it is classified as OTHER, customers should treat it as an internal dependency and not call it from custom code. Diagnosing wsh_fm_serialno_null conditions typically involves verifying that shipping confirmation supplied non-null FM_SERIAL_NUMBER values into the interface collection before INSERT_ROW_BULK executed, since the package faithfully copies whatever the caller provides.