Oracle Apps – Hustlers

Useful SQL queries in Oracle Apps

Post author:Aruna Malla
Post published:October 8, 2013
Post category:SQL
Post comments:2 Comments

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

Post author:Aruna Malla
Post published:October 8, 2013
Post category:Uncategorized
Post comments:0 Comments

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…