Interface Trip Stop Errors With 'For This Transaction Row The Serial Records Are Missing' (Doc ID 555484.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

On 11.5.10.2:
Interface Trip Stop errors with 'For this transaction row the serial records are missing'.
Applied patch 5018917. It fixed the problem for quantity > 1, but the problem
still existed when quantity = 1.
Applied patch 5254736 (replacement for 5183514),
the problem is still present for quantity = 1.
This is only a problem when using the API as indicated in patches.
inv_trx_util_pub.insert_ser_trx is the api using to enter the serial numbers for pick confirm.

ERROR
'For this transaction row the serial records are missing'

STEPS
1. Create sales order with serialized items.
2. For this specific test, I am using at receipt items and entering the serial numbers during
    Pick Confirm using the API.
3. After ship confirm in shipping transactions form, the interface trip stop errors with 'For this
    transaction row the serial records are missing.'

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