My Oracle Support Banner

Receive Global PO - Error: RVTTH-448: Subroutine ORA-01422: exact fetch returns more than requested number of rows in Package RCV_AccEvents_PVT Procedure Create ReceiveEventsStatement -35 returned error (Doc ID 1504439.1)

Last updated on APRIL 24, 2024

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Application version: 12.1.3

Problem Description
---------------------------------------------------
Unable to receive PO Created and Approved in US OU against another OU Requisition. System assigns receipt number but generates error in receiving log.

Customer is not able to query Purchase Order on receipt form when the org_id =0

Error Codes
---------------------------------------------------
RVTTH-448: Subroutine ORA-01422: exact fetch returns more than requested number of rows in Package RCV_AccEvents_PVT Procedure Create ReceiveEventsStatement -35 returned error

Trace file shows:
--------------------------

ROLLBACK TO CREATE_RECEIVEEVENTS_PVT

ORA-01422: exact fetch returns more than requested number of rows
error after entering RCV_ACCEVENTS_PVT package.
-------------------------------------

Changes

 

Cause

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
Symptoms
Changes
Cause
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.