Useful SQL queries in Oracle Apps
To know the database version : select * from v$version; The below query displays all the locked tables in the given session: SELECT owner || '.'…
Person Deletion
Person Deletion in EBS HRMS: -------------------------------- If you mistakenly save information in the People window, you can remove the person by selecting Delete Record ( the one with a penil…