The gme_api_pub.create_material_txn API Allows Creation of WIP Return Without Prior WIP Issue (or if Prior WIP Issue was for Lower Quantity) (Doc ID 2702189.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

On : 12.2.8 version, Batches

ACTUAL BEHAVIOR
---------------
The gme_api_pub.create_material_txn API allows you to create a WIP Return in a batch for an ingredient even if there had been no WIP Issues created for that ingredient in the batch.
On the batch Material Transactions screen, the Transaction Type field does not allow you to select anything other than WIP Issue if there is prior transaction, but such validation seems to be missing from the API.

EXPECTED BEHAVIOR
-----------------------
User should not be able to create a WIP Return if there was no previous WIP Issue.
User should also not be allowed to create WIP Returns for quantity greater than previous WIP Issues.
WIP Returns should be validated for lot and qty against previous WIP Issues - should not be able to return something that wasn't issued, or more than was issued, and should not be allowed to return twice against one WIP Issue.
Same validations should be in place for WIP Completion Returns / WIP Completions

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using gme_api_pub.create_material_txn API, create a WIP Return for an ingredient that has not yet been transacted.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the batch becomes corrupted, the actual quantity is set to the quantity returned instead of the quantity issued, and subsequent WIP Issues decrease the actual qty and subsequent returns increase the actual qty.

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.