Error: Quantity XX Is Greater Than YY, Quantity Ordered Plus Tolerance While Trying Create New WC After Correction (Doc ID 2678164.1)

Last updated on FEBRUARY 20, 2023

Applies to:

Symptoms

On : 12.1.3 version, Services Procurement

While attempting to create new Work Confirmation after correction, the record remains stuck in error in RCV_TRANSACTIONS_INTERFACE table with
the following error :

ERROR
--------------
Error: Quantity 1 is greater than 0, quantity ordered plus tolerance. Cause: Quantity you wish to ship is greater than quantity ordered plus the over receipt tolerance. Action: Either reduce the quantity to ship or increase your quantity received tolerance on the Purchase Order.
Error: Quantity 7.992 is greater than 0, quantity ordered plus tolerance. Cause: Quantity you wish to ship is greater than quantity ordered plus the over receipt tolerance. Action: Either reduce the quantity to ship or increase your quantity received tolerance on the Purchase Order.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create complex PO, with two line qty 24 and 3, quantity tolerance 'REJECT'
2. Create work confirmation with amount 24 and 3 against the PO and approve it
3. Cancel the above WC with suggested data fix
4. Create new WC with amount 8 and Submit for Approval
5. Run Receiving Transaction Processor.
6. Receiving Transaction Processor completed with error  

Cause

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