RVTTH-445:Subroutine ORA-1403 :No Data found in package RCV_AccEvents_PVT
(Doc ID 404273.1)
Last updated on SEPTEMBER 30, 2021
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
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
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 |
| References |