WIP Issue Through API Disallows Quantities That Are Allowed Through Form (Doc ID 2273669.1)

Last updated on JUNE 05, 2017

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, Batches

Unable to consume entire available quantity in WIP Issue through API when using item primary UOM as transaction UOM but batch line uses different UOM.

Item's primary UOM is LB. Batch line uses KG.
Onhand and available for a lot is .79198 LB
Using gme_api_pub.Create_material_txn, and passing transaction UOM as LB and transaction quantity as .79198
Gives error:
Quantity must be less than or equal to Available to transact

Doing the same thing on a batch line where the UOM is LB works, both through the API and the form.

Conversion is 1 KG = 2.20462262 LB


ERROR
-----------------------
Quantity must be less than or equal to Available to transact


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create batch with ingredient that has primary UOM of LB, but enter KG as the UOM on the batch
2. Using a lot that has .79198 LB onhand and available, attempt to create WIP Issue for .79198 LB using gme_api_pub.Create_material_txn

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot consume the onhand inventory.

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