My Oracle Support Banner

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 AUGUST 02, 2022

Applies to:

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


On : 12.2.8 version, Batches

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.

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

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.

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.




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.