RVTTH-010: Subroutine rvtthins() returned error When Receiving in Inventory Organizations (Doc ID 1098680.1)

Last updated on SEPTEMBER 01, 2016

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:
----------------------
[28-APR-10 09:17:40] RCV_TRANSACTION_PROC begin: v--------Procedure Started-----------v
RVTTHIns(p_rti_id:9027, p_transaction_type: RECEIVE, p_shipment_header_id: 9020, p_shipment_line_id: 9016, p_primary_unit_of_measure: Adet, p_primary_quantity: 120, p_source_doc_unit_of_measure: Adet, p_source_doc_quantity: 120, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
[28-APR-10 09:17:40] RCV_TRANSACTION_PROC 171: RVTTHIns(p_rti_id:9027, p_transaction_type: RECEIVE, p_shipment_header_id: 9020, p_shipment_line_id: 9016, p_primary_unit_of_measure: Adet, p_primary_quantity: 120, p_source_doc_unit_of_measure: Adet, p_source_doc_quantity: 120, 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:9027, p_transaction_type: RECEIVE, p_shipment_header_id: 9020, p_shipment_line_id: 9016, p_primary_unit_of_measure: Adet, p_primary_quantity: 120, p_source_doc_unit_of_measure: Adet, p_source_doc_quantity: 120, 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 organization_id 641 is returning 0:
----------------------
PARSING IN CURSOR #127 len=324 dep=1 uid=44 oct=3 lid=44 tim=1600938708763 hv=1638934994 ad='976fa460'
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
END OF STMT
PARSE #127:c=0,e=1163,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1600938708755
BINDS #127:
kkscoacd
Bind#0
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=ffffffff7a305f30 bln=22 avl=03 flg=05
value=641
EXEC #127:c=20000,e=18705,p=0,cr=2,cu=0,mis=1,r=0,dep=1,og=4,tim=1600938727660

 

RCV11i ouput from <NOTE.423279.1> How Can The Receiving Data Collection Script Be Run From Within The Oracle Application?
PO belongs org_id = 83
ship to org on the po organization_id = 641 which is pointing to org_id = 621

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