My Oracle Support Banner

Receipt Inspection Errors With RVTTH-065: RVSIT-045: SQL-02112 (Doc ID 559743.1)

Last updated on MAY 25, 2019

Applies to:

Oracle Inventory Management - Version 11.5.7 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.
FORM:RCVTXERT.FMB - Enter Receiving Transactions
EXECUTABLE:RVCTP - Receiving Transaction Processor

Symptoms

Attempting to perform Receipt Inspection, the following error occurs (per Receiving Transaction Processor log):

RVTTH-065: Subroutine rvsit_inspect_transfer_supply() returned error
Cause: Subroutine rvsit_inspect_transfer_supply() returned an internal error.
Action: Note this error number and the actions you are trying to perform.

RVSIT-045: SQL-02112: SELECT..INTO returns too many rows
Cause: A SQL error has occurred in RVSIT. The SQL error is &LSQL_ERR.
Action: Take note of both this error number and the actions you were t

RVTPT-041: ORA-01403: no data found
Cause: A SQL error has occurred in RVTPT. The SQL error is &LSQL_ERR.
Action: Take note of both this error number and the actions you were t...

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
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.