Receiving Open Interface Fails with Message: A SQL Error Has Occurred In Derive_vendor_rcv_line_qty-098: -1422 (Doc ID 1121294.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

When trying to perform receiving transactions for PO using the Receiving Open Interface, the following error message occurs:

ERROR
-----------------------
derive_vendor_rcv_line_qty-098: -1422

Cause: A SQL error has occurred in derive_vendor_rcv_line_qty. The SQL error is ORA-01422: exact fetch returns more than requested number of rows."

STEPS
-----------------------
1)  Populate RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE for an approved Purchase Order.
2) Run the "Receving Transaction Processor" concurrent with the group ID populated in 1.

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