My Oracle Support Banner

RVTTH-010 : RVTTH-192 rvtthins: Subroutine PO_INVALID_REL_SHIPMENT_STATUS Returned Error While Performing PO Receipt. (Doc ID 2883477.1)

Last updated on MARCH 08, 2023

Applies to:

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


Following error is thrown while performing PO receipt.

Error RVTTH-010: Subroutine rvtthins() Returned Error.
Cause: Subroutine rvtthiins returned an internal error.

Action: Note this error number and action you are trying to perform

RVTTH-192 rvtthins: Subroutine PO_INVALID_REL_SHIPMENT_STATUS returned error

Cause subroutine PO_INVALID_REL_SHIPMENT_STATUS returned an internal error

The issue can be reproduced at will with the following steps:
1. Choose Purchasing responsibility
2. Perform receipt
  Navigation: Receiving > Receipts > Search with PO > Perform receipt

Debug Log Shows Following Messages:


[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.245:           l_po_auth_status :REQUIRES REAPPROVAL
[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.246:           l_po_approved_flag :R
[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.247:           l_po_unit_price :-1
[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.end_implicit:         ^--------Implicit Procedure Exit-----^
[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RVTTH.C.end_implicit:       ^--------Implicit Procedure Exit-----^
[19-JUN-22 09:25:58] po.plsql.RCV_TRANSACTION_PROCESSOR.RVTPA.C.end_implicit:     ^--------Implicit Procedure Exit-----^
[19-JUN-22 09:25:58] po.src.rvtp.rvtpt.RVTPT.C.4032:     RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint 

[19-JUN-22 09:25:58] po.src.rvtp.rvtpt.RVTPT.C.4032:     ORA-01405: fetched column value is NULL

[19-JUN-22 09:25:58] po.src.rvtp.rvtpt.RVTPT.C.4057:     RVTPT:054 

[19-JUN-22 09:25:58] po.src.rvtp.rvtpt.RVTPT.C.5862:     RVTPT:040 In rvtptupdate_status 4159844 

[19-JUN-22 09:25:58] po.src.rvtp.rvtpt.RVTPT.C.5868:     RVTPT:040 Status is Error 





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.