Best practice for clearing the object reservations
Hi,
We want to clear the Object reservations in table F00095 on periodic basis. As of now, we see that some of the transactions are locked (may be because of some technical networking issue etc).
We clear these locked transactions (based on logic that date of locking should be prior by 2 days to the system date).
We are planning to create a script which will execute every day and clear F00095 data based on above logic.
Before we implement this process, I want to hear if there is any standard practice recomended by Oracle to handle / clear object reservations.
Or if there is some setup/ inbuilt functionality where in the data is cleared from F00095 by itself.