RVCTP Errors When Receiving PO Release RVTTH-448: Subroutine Returned error (Doc ID 1302599.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.2.4 [Release 12.1 to 12.2]
Oracle Purchasing - Version 12.1.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Form:POXPOERL.FMB - Enter Release
Form:RCVRCERC.FMB - Enter Receipts
Form:POXPOEPO.FMB - Enter Purchase Orders

***Checked for relevance on 05-JUL-2015 ***

Symptoms

When attempting to receive one Blanket Purchase Release the following errors occur

Error
In Online Mode

rvtptcontrol failed
RVTTH-448 Subroutine returned Error


In Immediate or batch mode
RVCTP module: Receiving Transaction Processor completes with error

RVTTH-448: Subroutine  returned error
Cause:        Subroutine  returned an internal error. 
Action:        Note this error number and the actions you are trying to perform. Contact your system administrator for assistance.
Concurrent program RVCTP returned error


Steps
The issue can be reproduced at will with the following steps:
1. Receiving / Receipts: Create a receipt for Blanket Release.
2. Save. See the error.
 

After setting debug profile options per <Note 299497.1>
fnd_log_messages show it fails in RCV_SeedEvents_PVT.Seed_RAEEvent :

po.plsql.RCV_AccEvents_PVT.Create_ReceiveEvents140                            
Create_ReceiveEvents : 140 : Error creating event                             
po.plsql.RCV_AccEvents_PVT.Create_ReceivingEvent80                            
Create_ReceivingEvents : 80 : Error creating event                            
po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEvents120                       
Create_AccountingEvents : 120 : Error creating event                          
...
po.src.rvtp.rvtth.RVTTH.C.6694                                                
        ORA-01405: fetched column value is NULL   
...                         
po.src.rvtp.rvtth.RVTTH.C.6704                                                
        RVTTH:445 error in  Create_AccountingEvents              

Creating Receive Events : po_distribution_id : 4442046 destination_type_code : INVENTORY project_id :                                                          
..



RVCTP trace shows
  value="Seed_RAEEvent : 120 : Transaction Quantity is 0. Returning without seeding event."
..
  value="po.plsql.RCV_AccEvents_PVT.Create_ReceiveEvents140"
...                                                                      
  value="Create_ReceiveEvents : 140 : Error creating event"
ROLLBACK TO CREATE_RECEIVEEVENTS_PVT

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