My Oracle Support Banner

WIP Move Transactions Getting Processed By API Even If Required Quantity Is More Than On-hand Qty (Doc ID 2624855.1)

Last updated on JANUARY 06, 2020

Applies to:

Oracle Work in Process - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

As per Standard Functionality, if the required Component Quantity is more than on-hand Quantity, then Move Transaction will not be allowed from front end.

However for same scenario records are getting processed by "wip_movproc_pub.processinterface" API when accessing from custom program.
We can see error message - "04-05-7583:Quantity must be less than or equal to Available to transact" against that transaction_id in wip_txn_interface_errors table but still API performs the move transaction.

How to make such records not to be processed when accessing the API from custom program?

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.