My Oracle Support Banner

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.

 

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
"

 

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

 

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


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