Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see How to check Package version in EBS R12
Sometimes, we have different versions between the Database and the filesystem and that could be causing an invalid in the database. Let’s see how to find the version on both the database and Filesystem
How to check the version in the Database
we can find this using the sql
select text from dba_source where name ='&package' and text like '%Header:%';
Example
select text from dba_source where name ='AD_ZD_PREP' and text like '%Header:%'; ------------------------------------------------------------------- /* $Header: ADZDPRPS.pls 120.11.12020000.10 2022/06/13 04:39:28 rsatyava ship $ */ /* $Header: ADZDPRPB.pls 120.16.12020000.38 2022/06/13 04:38:52 rsatyava ship $ */
Here ADZDPRPS.pls is the package spec file and ADZDPRPB.pls stands for the Package Body
How to check the version on the filesystem
Now that we know about the files for the package, we can check the version on the filesystem using adident
Login to Application node
Source the EBS environment
cd $AD_TOP/patch/115/sql
adident Header ADZDPRPS.pls
adident Header ADZDPRPB.pls
We should be having the same version between the database and the filesystem
How to make it the same in both the places
You can compile it from the filesystem
sqlplus apps/<apps pass>
@ADZDPRPS.pls
sqlplus apps/<apps pass>
@ADZDPRPB.pls
You can again check the version in both the Database and file system
I hope you find this article on How to check the Package version in EBS R12 useful. Please provide your feedback
Related Articles
Oracle apps queries for APPS DBA: This page contains the very useful and practical Top 30 Useful oracle apps queries for APPS DBA to help in administration activities
How to change apps password in EBS R12.2 : Check out this post on how to change apps password in EBS R12.2 with detailed steps. Apps password change need to be done in Weblogic also
Workflow Notification Mailer Configuration in Oracle EBS
How to run autoconfig in oracle apps R12: Check out this post for the steps on How to run autoconfig in oracle apps R12 both the Database and Application Tier.