LCM Shipment Cannot Be Received Derive_vendor_rcv_line_qty-098 : 1 FRM-40212: Invalid Value (Doc ID 1958122.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

In LCM Pre Receiving Enabled Organization
Find the Shipment Number created in landed cost Management cannot be receipted in Oracle Inventory for some LCM Shipments.

Steps
The issue can be reproduced at will with the following steps:
1.  Receiving / Receipts
On Find Expected Receipts RCVRCERC form
Search for Purchase Order 1234
Get
FRM-40212: Invalid value for field PO_NUM.

2. Navigate to Transaction Statuses RCVTXVTX form
See Ship Transactions stuck with Errors

3. Output of Receiving Data Collection script for the purchase order shows

po_line_locations_all
LINE_LOCATION_ID 361854
PO_HEADER_ID 180192
PO_LINE_ID 394459
QUANTITY 176
QUANTITY_RECEIVED 0
QUANTITY_SHIPPED 0
SHIP_TO_ORGANIZATION_ID 167
SHIPMENT_NUM 1
ORG_ID 99
LCM_FLAG Y
MATCH_OPTION R

rcv_headers_interface
HEADER_INTERFACE_ID 24120
GROUP_ID 186919
PROCESSING_STATUS_CODE ERROR
RECEIPT_SOURCE_CODE VENDOR
ASN_TYPE LCM
SHIPMENT_NUM 21.1
SHIP_TO_ORGANIZATION_ID 167
VALIDATION_FLAG Y

rcv_transactions_interface
INTERFACE_TRANSACTION_ID 934492
GROUP_ID 186919
TRANSACTION_TYPE SHIP
TRANSACTION_DATE 22-DEC-2014 09:44:32
PROCESSING_STATUS_CODE ERROR
PROCESSING_MODE_CODE BATCH
TRANSACTION_STATUS_CODE PENDING
QUANTITY 176
INTERFACE_SOURCE_CODE LCM
RECEIPT_SOURCE_CODE VENDOR
TO_ORGANIZATION_ID 167
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 180192
PO_LINE_ID 394459
PO_LINE_LOCATION_ID 361854  
SHIPMENT_NUM 21.1
HEADER_INTERFACE_ID 24120
DOCUMENT_NUM 1234
VALIDATION_FLAG Y
ORG_ID 99
LCM_SHIPMENT_LINE_ID 30467

po_interface_errors
COLUMN_NAME INTERFACE_TRANSACTION_ID
ERROR_MESSAGE Error: derive_vendor_rcv_line_qty-098: 1 Cause: A SQL error has occurred in derive_vendor_rcv_line_qty. The SQL error is User-Defined Exception. Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
ERROR_MESSAGE_NAME PO_ALL_SQL_ERROR
TABLE_NAME RCV_TRANSACTIONS_INTERFACE
BATCH_ID 186919
INTERFACE_HEADER_ID 24120
INTERFACE_LINE_ID 934492

mtl_parameters
Organization_Id    167
Organization_Code    FLO
Lcm_Enabled_Flag    Y
    
rcv_parameters 
Organization_Id    167
Pre_Receive    Y

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