My Oracle Support Banner

Interface Trip Stop For Internal Order Shipment Fails With Error 'NO RECORDS FOUND FOR LOT &Lot_number' (Doc ID 2867255.1)

Last updated on MAY 06, 2022

Applies to:

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

Symptoms

On : 12.2.11 version, Inventory Transactions

Unable to interface internal order shipments to Inventory due to error when running Interface trip stop

ERROR
-----------------------
Debug log shows -

      Exiting WSH_EXTERNAL_INTERFACE_SV.GET_WAREHOUSE_TYPE 
       l_org_type ==>
       l_source_code ==> ORDER ENTRY
       l_interface_serial ==> FALSE
       l_mtl_txn_if_rec.transaction_temp_id(l_index)  ==> is NULL
       ITEM IS UNDER LOT CTRL .INSERTING LOT NUMBER LOT01 INTO MTLI.
       Populating Lot attribute values
       ERROR: NO RECORDS FOUND FOR LOT LOT01
       Error at line ==> 6913412


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order management > Shipping > Ship confirm sales order
2. Run interfaces
3. Run the Order Management Interface-SRS and the Inventory Interface-SRS for each delivery
4. Request completes in warning, Request log shows error above.

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.