I think, this is a system seeded package. Did somebody edited the package recently? Error shown is very much clear, fix the error and recompile it.
thanks for the update. Actually we have not made any changes to this package. We were applying the adop R12.2.4 patch.
Due to this my patch is not able to proceed.
************* Start of AutoPatch session *************
AutoPatch version: 12.2.0
AutoPatch started at: Fri May 29 2015 16:30:59
APPL_TOP is set to /app/u01/d02/fs1/EBSapps/appl
Defaults Feature Enabled = YES.
Non-Interactive Mode = YES.
Num Workers = 16.
Options = "hotpatch".
Patch Top = "/app/u01/d02/fs_ne/EBSapps/patch/17919161".
Patch Driver File = "u17919161.drv".
NLS_LANG value from the environment is : American_America.US7ASCII
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.US7ASCII
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? No *
Please enter the batchsize  : 1000 *
Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
Applications System Name [DPROD] : DPROD *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle E-Business Suite forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [ghorizon] : ghorizon *
You are about to apply a patch to the installation of Oracle E-Business Suite
in your ORACLE database 'DPROD'
using ORACLE executables in '/app/u01/d02/fs1/EBSapps/10.1.2'.
Is this the correct database [Yes] ? Yes *
AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: *****
Connecting to SYSTEM......Connected successfully.
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : *****
AutoPatch is verifying your username/password.
Connecting to APPS......Connected successfully.
The status of various features in this run of AutoPatch is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Identifier for the current session is 33796
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [C.6]
You chose to abandon your previous AutoPatch session
and to continue as a new session.
Beginning database cleanup for previous session ...
Dropping FND_INSTALL_PROCESSES table...
DROP TABLE APPLSYS.fnd_install_processes PURGE
DELETE FROM ad_timestamps WHERE TYPE = 'FND_INSTALL_PROCESSES'
FND_INSTALL_PROCESSES table dropped.
Dropping AD_DEFERRED_JOBS table...
DROP TABLE AD_DEFERRED_JOBS PURGE
AD_DEFERRED_JOBS table dropped.
Completed database cleanup for previous session.
*** Patching the Run File System (in Hotpatch mode) ***
STRT_TASK: [AutoPatch startup after aimini]  [Fri May 29 2015 16:31:08]
Not checking the system maintenance mode.
STRT_TASK: [Validate schema passwords]  [Fri May 29 2015 16:31:08]
STOP_TASK: [Validate schema passwords]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Upload Patch History information from filesystem]  [Fri May 29 2015 16:31:08]
Trying to obtain a lock...
About to attempt instantiating the current-view snapshot: Fri May 29 2015 16:31:08
Attempting to instantiate the current-view snapshot...
Was already instantiated. So no instantiation done this time.
Done attempting to instantiate the current-view snapshot: Fri May 29 2015 16:31:08
**************** S T A R T O F U P L O A D ****************
Start date: Fri May 29 2015 16:31:08
0 "left over" javaupdates.txt files uploaded to DB: Fri May 29 2015 16:31:08
0 patches uploaded from the ADPSV format patch history files: Fri May 29 2015 16:31:08
0 patches uploaded from the ADPSV format preinstall patch history files: Fri May 29 2015 16:31:08
Uploading information about files copied during the previous runs ...
0 "left over" filescopied_<session_id>.txt files uploaded to DB: Fri May 29 2015 16:31:08
****************** E N D O F U P L O A D ******************
End date: Fri May 29 2015 16:31:08
STOP_TASK: [Upload Patch History information from filesystem]  [Fri May 29 2015 16:31:08]
You have specified /app/u01/d02/fs_ne/EBSapps/patch/17919161
as the directory where your Oracle E-Business Suite patch has been unloaded.
STOP_TASK: [AutoPatch startup after aimini]  [Fri May 29 2015 16:31:08]
You have specified u17919161.drv
as the name of your patchdriver file.
STRT_TASK: [Run a single patch driver file]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Steps before copy portion]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Initial driver processing steps]  [Fri May 29 2015 16:31:08]
Start time for driver file is: Fri May 29 2015 16:31:08
STOP_TASK: [Initial driver processing steps]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Get Oracle E-Business Suite Release and read driver file]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Get Oracle E-Business Suite Release]  [Fri May 29 2015 16:31:08]
Getting Oracle E-Business Suite Release...
Current installed release is 12.2.0
STOP_TASK: [Get Oracle E-Business Suite Release]  [Fri May 29 2015 16:31:08]
STRT_TASK: [Process patch driver file]  [Fri May 29 2015 16:31:08]
Reading patch driver file...
STRT_TASK: [Parse and load patch driver file]  [Fri May 29 2015 16:31:08]
Parsing and loading patch driver file...
Processing line 10000.
Processing line 20000.
Processing line 30000.
Processing line 40000.
Processing line 50000.
Processing line 60000.
Processing line 70000.
Processing line 80000.
Processing line 90000.
Processing line 100000.
Processing line 110000.
Processing line 120000.
Processing line 130000.
Processing line 140000.
Processing line 150000.
Processing line 160000.
Processing line 170000.
Processing line 180000.
Processing line 190000.
Processing line 200000.
Processing line 210000.
Processing line 220000.
Processing line 230000.
Processing line 240000.
Processing line 250000.
Processing line 260000.
Processing line 270000.
Processing line 280000.
Processing line 290000.
Processing line 300000.
Processing line 310000.
315178 lines processed.
STOP_TASK: [Parse and load patch driver file]  [Fri May 29 2015 16:31:11]
STRT_TASK: [Check patch integrity]  [Fri May 29 2015 16:31:11]
Not checking patch integrity as integrity checking flag is turned off.
STOP_TASK: [Check patch integrity]  [Fri May 29 2015 16:31:11]
Successfully read patch driver file.
STOP_TASK: [Process patch driver file]  [Fri May 29 2015 16:31:11]
STRT_TASK: [Other driver and release-related logic]  [Fri May 29 2015 16:31:11]
Determining target release...
Current target release is 12.2.0
STOP_TASK: [Other driver and release-related logic]  [Fri May 29 2015 16:31:12]
STOP_TASK: [Get Oracle E-Business Suite Release and read driver file]  [Fri May 29 2015 16:31:12]
STRT_TASK: [Prereq checking logic]  [Fri May 29 2015 16:31:12]
adpcdlvlGetTeInfoFromDB(): Unexpected Database Error
ORA-04063: package body "APPS.AD_TRACKABLE_ENTITIES_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_TRACKABLE_ENTITIES_PKG"
ORA-06512: at line 3
Error getting information from database in adpcdlvlGetTeInfoFromDB().
A fatal error related to codelines or codelevels has occurred.
See messages above for details.
Freeing includes hash table
Freeing fixes hash table
Freeing basedons hash table
Freeing entities hash table
You should check the file
This patch # 17919161 is 'ORACLE E-BUSINESS SUITE 12.2.4 RELEASE UPDATE PACK', did you apply the below mentioned two pre-requisites patches?
I have applied this patches
17204589 19197270 19330775
What is your DB/Apps version?
OS : OEL 6.6 64-bit
EBS : R12.2.0 currently upgrading R12.2.4
OS : 184.108.40.206
Is EBS: R12.2.0 freshly installed or upgraded from previous release? If upgraded, please go through this document 'Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1) 'and apply the database patches.
This has resolved the error.
select text from all_source where name = 'AD_TRACKABLE_ENTITIES_PKG' and line <10 and text like '%Header%';
alter package AD_TRACKABLE_ENTITIES_PKG compile body;
If the above packeg is valid , then retest your issue
3) Please run the EBS Database Codelevel Checker.
See Note 2008451.1 - How To Run The EBS Technology Codelevel Checker (ETCC)
Downloaded the database checker from Patch 17537119.
Instructions to run the Database checker utility (checkDBpatch.sh or checkDBpatch.cmd for Windows) are available in the patch's readme.
Upload the checkDBpatch_xxxxx.log file.
4) please run the RDA in HCVE mode as described in Note 250262.1 (RDA 4 - Health Check / Validation Engine Guide)
- download rda.zip
- unzip rda.zip
$ ./rda.sh -T hcve
Select the following test :
Oracle E-Business Suite Release 12 (12.2.0)
The generated report will show us if you have some missing OS prerequisites or setup on the server
5) please provide an exact list of all the patches (technology & EBS) you have applied after the fresh installation and the exact order of the application of these patches
6) Please run the following scripts and upload the results:
sqplus apps/<apps password>
set pages 1000
col PLATFORM_CODE form a5
col HOST form a20
col DOMAIN form a30
col WEBHOST form a30
col VIRTUAL_IP form a20
col status form a20
col ConcMgr form a8
col Forms form a8
col WebServer form a8
col Admin form a8
col Database form a8
col last_monitored form a40
to_char(CREATION_DATE, 'DD-MON-RR HH24:MI') creation_date,
decode(SUPPORT_CP,'Y', 'ConcMgr','No') ConcMgr,
decode(SUPPORT_FORMS,'Y','Forms', 'No') Forms,
decode(SUPPORT_WEB,'Y','Web', 'No') WebServer,
decode(SUPPORT_ADMIN, 'Y','Admin', 'No') Admin,
decode(SUPPORT_DB, 'Y','Rdbms', 'No') Database,
to_char(LAST_MONITORED_TIME, 'DD-MON-RR HH24:MI:SS') last_monitored,
where node_name != 'AUTHENTICATION';
select i.instance_name NAME, i.host_name HOST,
f.release_name RELEASE, i.version VERSION
from v$instance i,fnd_product_groups f
where upper(substr(i.instance_name,1,4)) =
SELECT abbreviation, codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');
select USERNAME, EDITIONS_ENABLED from dba_users where USERNAME = 'APPS';
select dba.USERNAME, dba.EDITIONS_ENABLED from DBA_USERS dba, FND_ORACLE_USERID fnd
where dba.USERNAME = fnd.ORACLE_USERNAME and dba.EDITIONS_ENABLED = 'N' and fnd.ORACLE_USERNAME not in ('MTR','APPS_NE','CTXSYS','ODM');
select * from dba_errors where type not like 'JAVA%';
select owner, object_name , object_type, status from dba_objects where status = 'INVALID';
2) please try to recreate the package and body.