Records stuck in rcv_transactions_interface [message #409549] |
Tue, 23 June 2009 01:41 |
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 #412708 is a reply to message #412238] |
Fri, 10 July 2009 14:09 |
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
|
|
|