Home » Applications » Oracle Fusion Apps & E-Business Suite » Records stuck in rcv_transactions_interface
Records stuck in rcv_transactions_interface [message #409549] Tue, 23 June 2009 01:41 Go to next message
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
Hi Team,

There are few transactions stuck in rcv_transactions_interface.I have to clear that.
Before I clear that I want to check if they are already there in final tables.
If not I will have to process it, how do i do that.

Regards,
Abbas.
Re: Records stuck in rcv_transactions_interface [message #412238 is a reply to message #409549] Wed, 08 July 2009 06:01 Go to previous messageGo to next message
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
Really appreciate if anyone can help me out.
Re: Records stuck in rcv_transactions_interface [message #412331 is a reply to message #412238] Wed, 08 July 2009 13:13 Go to previous messageGo to next message
sanjayapps
Messages: 49
Registered: May 2005
Location: Richmond
Member

You can write a query to check if the Invoice Id/Number is already existing in the Base tables.
Re: Records stuck in rcv_transactions_interface [message #412708 is a reply to message #412238] Fri, 10 July 2009 14:09 Go to previous message
dip_m1
Messages: 3
Registered: May 2007
Junior Member
First of all, I don' think that if any receipt is lying in RCV_TRANSACTIONS_INTERFACE as ERROR or PENDING, then it has been absorbed. If it has been absorbed then it will not be present in this interface table, Oracle will delete the transaction record after it has been absorbed. But if you still want to be absolutely sure of:

1. I don't recollect the exact column names but you can check PO_INTERFACE_ERRORS table for the transaction id for TYPE like 'RCV%'
2. If you are entering RECEIPT NUMBER as well in the interface then you can search by RECEIPT_NUM in RCV_SHIPMENT_HEADERS table
Previous Topic: Problem running forms in firefox
Next Topic: HRMS Applicant assignment
Goto Forum:
  


Current Time: Fri Dec 02 22:55:43 CST 2016

Total time taken to generate the page: 0.19703 seconds