• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » How to check Package version in EBS R12

How to check Package version in EBS R12

March 4, 2023 by techgoeasy Leave a Comment

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

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 database and filesytem

How to make it 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 the check the version in both the Database and file system

I hope you find this article useful

Related Articles
Oracle apps queries for APPS DBA

Filed Under: Oracle, Oracle Ebuisness Suite

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us