My Oracle Support Banner

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 OCTOBER 17, 2022

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.