DBA can view users who are trying to access the production database through oracle script where they can able to view who are presently logged in / accessed the database....
/ Posted by KapilFind all the assets list through given script. SELECT DISTINCT a.asset_number, a.description, a.asset_type, d.segment1 asset_key, c.segment1 major_category, c.segment2 minor_category, c.segment3 sub_minor_category, b.deprn_method_code, b.life_in_months/12 life, b.book_type_code, b.date_placed_in_service, b.depreciate_flag, b.cost, h.units_assigned UNITS,...
/ Posted by KapilFollowing API can replace username of specific workflow type through one execution which reduce the manual updating work of workflow. Sometimes some users are end dated for any reason during...
/ Posted by KapilFind out the status of concurrent request which is pending in oracle EBS. select fcr.REQUEST_ID, fu.user_name, fcr.PHASE_CODE, fcr.STATUS_CODE, (fcr.ACTUAL_COMPLETION_DATE - fcr.ACTUAL_START_DATE) * 24 * 60 TIME_MINS, fcpt.USER_CONCURRENT_PROGRAM_NAME, fcp.CONCURRENT_PROGRAM_NAME, fcr.ACTUAL_START_DATE, fcr.ACTUAL_COMPLETION_DATE,...
/ Posted by Kapil