Oracle User Cleanup
Database : 11.2.0.3.0
Oracle Applications : 12.1.3
Product/services we use: AP,AR,PA,CM,GL,service contract,WMS,OM,PO,isupplier,iexpense and iprocurement.
Dear All,
I have requirement to end date user who have not logged into Oracle application for more than say 60days, is there is standard program which we can use or any script to end date and also I have below doubts.
1. If we end date those users if any workflow or approval pending with those users will become as orphan record?
2. Any program or script to identify the activity pending with the user we are going to end date?