My Oracle Support Banner

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

Last updated on JANUARY 23, 2020

Applies to:

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


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

Quantity must be less than or equal to Available to transact

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

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


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.