ITS Completing In Warning "For this Transaction Row the Serial Records are Missing" When Using API For Processing Pick Release, Allocation And Pick Confirm (Doc ID 1539623.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Pick Release => WSH_DELIVERIES_PUB.DELIVERY_ACTION

Allocate Move Order => INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB

Associate SN to Move Order => INV_TRX_UTIL_PUB.INSERT_SER_TRX

Transact Move Order => inv_pick_wave_pick_confirm_pub.pick_confirm

Symptoms

This issue only occurs when using API for processing Pick Release, Allocation and Pick Confirm, there is no issue when processing 100% using forms.

Problem occurs for:
Pick Release => WSH_DELIVERIES_PUB.delivery_action
Allocate Move Order => INV_REPLENISH_DETAIL_PUB.line_details_pub
Associate SN to Move Order => INV_TRX_UTIL_PUB.insert_ser_trx
Transact Move Order => INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm

ITS completing in Warning, records are stuck in MTI table.

Error "For this transaction row the Serial Records are missing" may also be seen along with error in ITS debug log file --  but this is not seen any more after running i2471362.sql

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms