R12: Creating Receipts for Global Procurement For Projects Related Purchase Orders With Expense Destination ends in error RVTTH-448 ORA-1403 (Doc ID 1471420.1)

Last updated on AUGUST 18, 2015

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Purchasing - Version 12.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
FORM:POXBWVRP.FMB - AutoCreate Documents GUI

Symptoms

Attempting to create receipts against project related Puchase Orders with expense destination when receiving org_id does not match purchasing org_id (Global Procurement), the following error occurs:

ERROR
-----------------------
rvtptcontrol failed
RVTTH-448: Subroutine ORA-01403: no data found in Package
RCV_AccEvents_PVT Procedure Create_ReceiveEventsStatement
-100 returned error

While creating the Purcahse Order, in Autocreate form, the following warning appears:

"You are not permitted to charge your expenses to project
if there is an existing Inter-Org Transaction Flow defined
between the Purchasing Org and the Destination Org."

Nevertheless, the Purchase Order is getting created.The Purchase Order is created only while choosing Automatic during Autocreation process, while choosing Manual the warning appers and the Purchase Order cannot be created further.

 

Steps to reproduce:

1) Setup intercompany flow between OU1 and OU2
2) Create purchase requisition. Destination organization in OU1, destination = Expense, choose project/task in distributions
3) Create PO in OU2 in Autocreate form for requisition from step 2; Choose Automatic during autocreation process -> getting the following warning:

"You are not permitted to charge your expenses to project
if there is an existing Inter-Org Transaction Flow defined
between the Purchasin Org and the Destination Org."

4) Try to create receipt - > Error occurs:
RVTTH-448 ORA-1403 in rcv_accevents_pvt create_receiveevents statement 100

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