My Oracle Support Banner

API gme_api_pub.create_material_txn Returns Out of Deviation Error When Passing Negative Quantity for WIP Issue (Doc ID 2384048.1)

Last updated on JANUARY 23, 2020

Applies to:

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


On : 12.1.3 version, API Issues

The gme_api_pub.create_material_txn API always returns an out of deviation error for dual UOM items if the quantities passed for a WIP Issue are negative. The API in general doesn't seem to care whether you pass positive or negative quantities for a WIP issue, it seems to work fine either way if you pass only the transaction qty and let the secondary qty be calculated by the system, and presumably for non-dual items. However, if you pass both transaction qty and secondary qty as negative, you get an error even when the quantities are within deviation.

The quantity entered is lower than the allowed deviation for the item.

The issue can be reproduced at will with the following steps:
1. Call the gme_api_pub.create_material_txn API for a dual UOM item, trying to create a WIP Issue, and passing a negative quantity for both transaction qty and secondary qty

The issue has the following business impact:
Due to this issue, the API fails.


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.