RVTTH-445:Subroutine ORA-1403 :No Data found in package RCV_AccEvents_PVT (Doc ID 404273.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI


Symptoms

On 11.5.10, when saving a receipt the following error occurs:

  Rvtptcontrol Failed
  RVTTH-445:Subroutine ORA-1403 :No Data found in package RCT_AccEvents_PVT
  Procedure Create_ReceiveEventsStatement -50 returned error.
  or
  Procedure Create_ReceiveEventsStatement -20 returned error

RCV: Processing Mode is set to 'Online'
iProcurement, ROI and Desktop receipts fail with same error.

When debugging you will find the last entry in table fnd_log_messages as:
SUBSTR(MESSAGE_TEXT,1,300) SUBSTR(MODULE,1,50)
DOCMGR-RVSRQ-180 After Maintain Res po.src.xit.pouer.pouerdebug.online-
"ORA-01405: fetched column value is NULL " po.src.xit.pouer.pouerdebug.online-
Create_ReceivingEvents : 50 : ORA-01403: no data found po.plsql.RCV_AccEvents_PVT.Create_ReceivingEvent50
Create_AccountingEvents : 120 : Error creating event po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEven

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