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 laterInformation in this document applies to any platform.
Symptoms
Following error is thrown while performing PO receipt.
ERROR
-----------------------
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
STEPS TO REPRODUCE
-----------------------
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
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 |