ITS Completing In Warning "For this Transaction Row the Serial Records are Missing" When Using API For Processing Pick Release, Allocation And Pick Confirm
Last updated on SEPTEMBER 14, 2016
Applies to:Oracle Inventory Management - Version 184.108.40.206 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
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
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