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 AUGUST 02, 2016

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

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