My Oracle Support Banner

Receiving Against Purchase Order Fails With RVTTH-192.rvtthins: ORA-06502:PL/SQL: Numeric Or Value Error Returned (Doc ID 2167525.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

Attempting to enter receipt against PO and Receiving Transaction Processor fails with error message:

RVTTH-192.rvtthins: ORA-06502: PL/SQL: sayısal veya değer hatası altyordamından dönen hata
Nedeni: ORA-06502: PL/SQL: sayısal veya değer hatası altyordamı bir dahili hata döndürdü.

Error message in English language:

RVTTH-192.rvtthins: ORA-06502:PL/SQL: numeric or value error returned from the subroutine error
Reason: ORA-06502 : PL/SQL: numeric or value error subroutine returned an internal error


Steps:
====
PO Resp > Receiving > Receipts > Save Receipt (Immediate mode) > Navigate to Transaction Status Summary and see the error above.

Other symptoms:
===========

Querying the same PO in Purchase Order Summary form (then clicking Open button) errors with:

FRM-40831: Truncation occurred: Value too long for field ZIP

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.