1 person found this helpful
Requisition Import clears the table of successfully imported records. You could turn on auditing on the table, but if you have a high volume of records, that could have a performance impact. Another idea is to write an alert to copy the requisitions to a custom backup table (test for possible performance impacts on this as well)
In of the instance,PO_REQUISITIONS_INTERFACE_ALL table is getting purged in every 5 minutes.
Any idea what could be the reason?
If its being cleared every 5 minutes, chances are there's a concurrent request that's running, and restarting itself every 5 minutes. In your concurrent manager, query for %Purge% to check for all purges that may be out there. If you find one running or pending, check the parameters for repeating itself. Purge Purchasing Open Interface Processed Data is one you can check for, but if there's one purge out there, other modules may have similar things running, so I like to check in general.
Similarly, if Requisition Import is set to run every 5 minutes, it would clear the table after importing.
Another to check for is Requisition Import Exceptions Report -- this one has a parameter for clearing the interface tables.
If none of that works, have your sys admin check for anything that's running every 2-10 minutes. They can check for requests set to repeat themselves a few minutes after they start, after they finish, based on clock time, etc. If you have Inventory, Cost Manager may be running every few minutes, and that's fine, its costing your inventory transactions and you want that to be frequent. There can be other things that you want to run that often, but the list of things that do run that often shouldn't be very long. Review everything on the list, and see if you find what's clearing your interface.