Correct Txn ROI Error: RCV_CORRECT_QTY_OVER_TOLERANCE

(Doc ID 1955702.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

When inserting CORRECT records via ROI RVCTP completes in error


Steps
The issue can be reproduced at will with the following steps:

. Receipt Transaction Summary  form
For specific Receipt / PO
See Receive / Deliver transactions for 8 EACH / Destination type Receiving / Expense

. Purchase Order Shipments for PO  9006 / Line 1 / Shipment 1
Quantity Received = 8

. Run insert script into RCV_TRANSACTIONS_INTERFACE with TRANSACTION_TYPE CORRECT for quantity -1 and run Receiving Transaction Processor RVCTP

. See in  RCV_TRANSACTIONS_INTERFACE 
INTERFACE_TRANSACTION_ID 3345140
TRANSACTION_TYPE CORRECT
PROCESSING_STATUS_CODE ERROR
PROCESSING_MODE_CODE BATCH
TRANSACTION_STATUS_CODE PENDING
QUANTITY -1
UNIT_OF_MEASURE EACH
INTERFACE_SOURCE_CODE RCV
UOM_CODE EA
AUTO_TRANSACT_CODE DELIVER
SHIPMENT_HEADER_ID 1548847
SHIPMENT_LINE_ID 2047609
RECEIPT_SOURCE_CODE VENDOR
TO_ORGANIZATION_ID 2840
SOURCE_DOCUMENT_CODE PO
PARENT_TRANSACTION_ID 4042869
PO_HEADER_ID 811185
DESTINATION_TYPE_CODE EXPENSE
DOCUMENT_NUM 9006
DOCUMENT_LINE_NUM 1
DOCUMENT_SHIPMENT_LINE_NUM 1
DOCUMENT_DISTRIBUTION_NUM 1
VALIDATION_FLAG Y
ORG_ID 2838


. See in PO_INTERFACE_ERRORS table a record with
COLUMN_NAME QUANTITY
ERROR_MESSAGE "Error: The correction quantity -1 is larger than the total available quantity 0
Cause: Cannot correct quantities for more than that which is available.
Action: Reduce the quantity to correct.
ERROR_MESSAGE_NAME RCV_CORRECT_QTY_OVER_TOLERANCE
TABLE_NAME RCV_TRANSACTIONS_INTERFACE 

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