My Oracle Support Banner

Receipt Transaction Stucks With Status LC Interfaced Due To Invalid Item Error (Doc ID 2465955.1)

Last updated on OCTOBER 28, 2018

Applies to:

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

Symptoms

Problem Statement
Receipt transactions has been stuck in RCV_TRANSACTIONS_INTERFACE with Transaction status "LC_INTERFACED". When Resubmitting the records through Shipments Interface Import, the following message is shown.

Error
Table INL_SHIP_LINES_INT, Record 78463: The Inventory Item specified is invalid
Table INL_SHIP_HEADERS_INT, Record 78438: Failed on concurrent submission (Validation failed).

Steps to Reproduce

  1. See pending records in RCV_TRANSACTIONS_INTERFACE with PROCESSING_STATUS_CODE=LC_INTERFACED
  2. Enable DEBUG LOGGING as per Doc ID: 860747.1.
  3. Update the records in error to pending in LCM Interface table:
  4. Run Shipments Interface Import.
  5. On a request log file, the above error message is shown.

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


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