RVTTH-010: Subroutine rvtthins() returned error When Receiving in Inventory Organizations
(Doc ID 1098680.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Inventory Management - Version 11.5.10.0 to 12.2.4 [Release 11.5.10 to 12.2]Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Symptoms
Unable to receive in inventory organizations and the following error occurs when navigating to Enter Receipts form.
Form error:
-----------------------
RVTTH-010: Subroutine rvtthins() returned error:
Cause: Subroutine rvtthins() returned an internal error:
Action: Note this error number and the actions you are trying to perform. Your inventory organization is not properly set up with the accounting information.
-----------------------
RVTTH-010: Subroutine rvtthins() returned error:
Cause: Subroutine rvtthins() returned an internal error:
Action: Note this error number and the actions you are trying to perform. Your inventory organization is not properly set up with the accounting information.
Debug error:
----------------------
RCV_TRANSACTION_PROC begin: v--------Procedure Started-----------v
RVTTHIns(p_rti_id: XXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure: XXXX, p_source_doc_quantity: XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
RCV_TRANSACTION_PROC XXX: RVTTHIns(p_rti_id:XXXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure: XXXX, p_source_doc_quantity:XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
[] RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC: RVTTHIns(p_rti_id:XXXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure:XXXX, p_source_doc_quantity: XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
Constructing filepath. Appl=PO, name=US, type_name=MESG, write_flag=0
/data1/MAINT/apps/apps_st/appl/po/12.0.0/mesg/US.msb
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
" RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
"
"[] rvtpt 3871: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
"
----------------------
RCV_TRANSACTION_PROC begin: v--------Procedure Started-----------v
RVTTHIns(p_rti_id: XXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure: XXXX, p_source_doc_quantity: XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
RCV_TRANSACTION_PROC XXX: RVTTHIns(p_rti_id:XXXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure: XXXX, p_source_doc_quantity:XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
[] RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC: RVTTHIns(p_rti_id:XXXX, p_transaction_type: RECEIVE, p_shipment_header_id: XXXX, p_shipment_line_id: XXXX, p_primary_unit_of_measure: XXXX, p_primary_quantity: XXXX, p_source_doc_unit_of_measure:XXXX, p_source_doc_quantity: XXXX, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
Constructing filepath. Appl=PO, name=US, type_name=MESG, write_flag=0
/data1/MAINT/apps/apps_st/appl/po/12.0.0/mesg/US.msb
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
^--------Implicit Procedure Exit-----^
[] RCV_TRANSACTION_PROC end_i: ^--------Implicit Procedure Exit-----^
" RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
"
"[] rvtpt 3871: RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
"
Trace file shows following query is returning 0:
----------------------
SELECT COUNT(*) FROM HR_ORGANIZATION_INFORMATION HOI ,
GL_SETS_OF_BOOKS GSOB , FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE HOI.ORGANIZATION_ID = :B1
AND HOI.ORG_INFORMATION_CONTEXT||'' = 'Accounting Information'
AND (FSP.ORG_ID IS NULL OR HOI.ORG_INFORMATION3 = TO_CHAR(FSP.ORG_ID))
AND FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
----------------------
SELECT COUNT(*) FROM HR_ORGANIZATION_INFORMATION HOI ,
GL_SETS_OF_BOOKS GSOB , FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE HOI.ORGANIZATION_ID = :B1
AND HOI.ORG_INFORMATION_CONTEXT||'' = 'Accounting Information'
AND (FSP.ORG_ID IS NULL OR HOI.ORG_INFORMATION3 = TO_CHAR(FSP.ORG_ID))
AND FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
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 |