Using the gme_api_pub.create_material_txn API to Create a WIP Completion Transaction in an LPN That has not been Used, Get Error "|Failed to Pack/Unpack item|The item was not found at the specified location" (Doc ID 2821286.1)

Last updated on APRIL 12, 2023

Applies to:

Symptoms

On : 12.2.5 version, API Issues

When attempting to use the gme_api_pub.create_material_txn API to create a WIP Completion transaction in an LPN that has not been used and is not in inventory,
the following error is returned onscreen in SQL Developer or whatever tool is being used to call the API.

ERROR
-----------------------
x_return_status = E
x_message_count = 2
x_message_list = |Failed to Pack/Unpack item|The item was not found at the specified location.
Message 1 Transaction processor error
|Failed to Pack/Unpack item|The item was not found at the specified location.
Message 2 |Failed to Pack/Unpack item|The item was not found at the specified location.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Add the following line to the wrapper used to call this API (note that a sample wrapper to call this API can be found in note 2278106.1, "Sample Wrapper Code for Calling GME_API_PUB Process Execution APIs").

p_mmti_rec.lpn_id := XXXX;

2. Run the wrapper in SQL Developer

3. These errors display onscreen

Changes

Cause

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