Understanding the Object Version Number (OVN)
Object Version Number is not a primary key, it indicates the version of a primary key row in a table. It certainly plays a major role in maintaining database concurrency and…
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…