How to check Package version in EBS R12

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 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 below 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 

And you can again check the version in both the Database and file system

I hope you find this article on How to check Package version in EBS R12 useful. Please do 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.