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 APRIL 09, 2018

Applies to:

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

Symptoms

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.


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


STEPS
-----------------------
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

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

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms