Conversions in Oracle Apps
This article concentrates on Data Conversion and Data Migration, and Interfaces. Data conversion/migration/interfaces are the mechanisms we use to load data to/from Oracle apps. When we need to enter data…
the corresponding $SRS$. is not compiled
issue: -------- Sometimes Oracle Apps throws an error saying, the corresponding $SRS$.<concurrent program short name> is not compiled, please contact support administratorroot cause: There will be a DFF created automatically…
Resolve Oracle Jinitiator 1.1.8.2 or higher error
At times we come across this error, while working on EBS R12 instances. Cause: incompatible Jre version Solution: While launching Forms from the Windows desktop clients which are running on…
SOA for dummies
I have been searching for tutorials, blog articles over internet, about SOA. I came across this great link which explains SOA in pure and plain english. Go through this link…
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…