My Oracle Support Banner

TO_MHE_IBLPN_INFO Interface Not Generated ORA-00001, ERROR 22654 ItemStruct (Doc ID 2656348.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 19.4 and later
Information in this document applies to any platform.


Need to send the TO_MHE_IBLPN_INFO which Sends information of the inbound LPN to be distributed by MHE system, but the file is not being generated (we could not see the XML on the OUTPUT INTERFACE screen).
Followed documentation OWM-InterfaceFormats-LogFire-WMS-v34_R19D.xls - Doc ID 2558210.1 open or click on 'Interface Specifications 19D' open this excel spread for "TO_MHE_IBLPN_INFO" in column G, configured as follows
RF Pick IBLPN - Message is sent after user close LPN. They must have : Facility Parameter MHE_ENABLED flag should be set to ""Yes"".
Allocations present on Inbound LPN should be of type ""Alloc type: Internal Bulk Pick/Task Type :INTERNAL-PICK"".
Open Allocations present on the LPN should have MHE system code populated- Go to Wave Inquiry UI - select button Allocations- look at field MHE System.
Go to MHE system configuration- Search for the MHE System - find the MHE Type. Go to MHE message configuration - search the MHE type and associated mhe message type for_LGF-Send IB LPN-info-Active Flag= yes
Verifed facility parameters looks good.

Above configuration looks good ;however, No xml file is generated to iblpn info.

Also clicking action option ' Generate MHE IB LPN Info Msg' on IBLPN UI does not generate file but give error:
ERROR 22654 - Exception in generate_iblpn_info_files: ItemStruct matching query does not exist.
Exception: Exception in generate_iblpn_info_files: ItemStruct matching query does not exist.


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

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