Error Reprocessing Stuck LCM Ship Transactions The Value Specified 1 Is Invalid. (COLUMN=LINE_NUM) RCVRCERC FRM-40212 SHIPMENT_NUM (Doc ID 1931673.1)

Last updated on SEPTEMBER 18, 2016

Applies to:

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

Symptoms

In LCM Pre Receiving enabled organization

When reprocessing per <Note 605300.1> Stuck LCM Shipment number 298 for multiple purchase orders the following error occurs in Receiving Transaction Processor RVCTP:

The value specified 1 is invalid. (COLUMN=LINE_NUM)

Also the following error may occur

Warning: Shipment Num must have a unique value.298.1 already exists.
PO_PDOI_SHIPMENT_NUM_UNIQUE


Steps

1. Navigate to Enter Receipts form RCVRCERC org VMR
2. Select 'LCM' as source type
3. Enter Shipment Number 298
4. Tab from field, error FRM-40212: INVALID VALUE FOR FIELD SHIPMENT_NUM occurs
5. Records are stuck in rcv_transactions_interface table

Output of Receiving Data Collection Script for the Purchase Order number 58420 shows

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