My Oracle Support Banner

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 NOVEMBER 12, 2021

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.5 and later
Information in this document applies to any platform.

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

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.