10 Replies Latest reply on Jun 1, 2015 6:58 AM by Mohammed Abdul Muqeet

    Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4

    Mohammed Abdul Muqeet

      Dear Experts,

       

      I am getting the following error message when i am trying to restart the adop 12.2.4 patch. Please advise.

       

      SQL>  select object_type,status from dba_objects where object_name = 'AD_TRACKABLE_ENTITIES_PKG' and owner = 'APPS';

       

       

      OBJECT_TYPE         STATUS

      ------------------- -------

      PACKAGE             VALID

      PACKAGE BODY        INVALID

       

       

      SQL> alter package apps.AD_TRACKABLE_ENTITIES_PKG compile body;

       

       

      Warning: Package Body altered with compilation errors.

       

       

      SQL> show errors

      Errors for PACKAGE BODY APPS.AD_TRACKABLE_ENTITIES_PKG:

       

       

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      38/13    PLS-00323: subprogram or cursor 'RESET_USED_FLAG' is declared in a package specification and must be defined in the package body

       

       

      SQL>

       

      regards

      Mohammed Abdul Muqeet

        • 1. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
          2846585

          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.

           

          Arizuddin

          • 2. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
            Mohammed Abdul Muqeet

            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.

             

            Complete Error

             

            ************* 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] : 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

            "Development_2".

             

            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]

             

             

            AutoPatch error:

            adpcdlvlGetTeInfoFromDB(): Unexpected Database Error

             

             

            AutoPatch 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

             

             

            AutoPatch error:

            Error getting information from database in adpcdlvlGetTeInfoFromDB().

             

             

            AutoPatch error:

            --------

            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

            /app/u01/d02/fs_ne/EBSapps/log/adop/2/apply_20150529_163032/DPROD_ghorizon/17919161/log/u17919161.log

             

            for errors.

            • 3. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
              2846585

              This patch # 17919161 is 'ORACLE E-BUSINESS SUITE 12.2.4 RELEASE UPDATE PACK', did you apply the below mentioned two pre-requisites patches?

               

              R12.AD.C.delta.5

              R12.TXK.C.delta.5

               

              Thx,

              Arizuddin

              • 4. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                Mohammed Abdul Muqeet

                I have applied this patches

                 

                17204589
                19197270
                19330775
                • 5. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                  Mohammed Abdul Muqeet

                  The latest RUPs are R12.AD.C.Delta.6 (Patch 19197270) and R12.TXK.C.Delta.6 (Patch 19330775).


                  We have applied this latest patches

                  • 7. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                    Mohammed Abdul Muqeet

                    OS : OEL 6.6 64-bit

                     

                    EBS : R12.2.0  currently upgrading R12.2.4

                     

                    OS : 11.2.0.3

                     

                    Regards

                    Mohammed

                    • 8. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                      2846585

                      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.

                       

                      Regards

                      Arizuddin

                      • 9. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                        Mohammed Abdul Muqeet

                        This has resolved the error.

                         

                        sqlplus apps/...

                        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;

                        show errors

                          

                        note:

                        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

                        cd rda

                        $ ./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

                        select

                        NODE_NAME,

                        to_char(CREATION_DATE, 'DD-MON-RR HH24:MI') creation_date,

                        PLATFORM_CODE,

                        decode(STATUS,'Y','ACTIVE','INACTIVE') Status,

                        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,

                        NODE_MODE,

                        SERVER_ADDRESS,

                        HOST,

                        DOMAIN,

                        WEBHOST,

                        VIRTUAL_IP,

                        SERVER_ID

                        from fnd_nodes

                        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)) =

                        upper(substr(f.applications_system_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';

                         

                        Regards

                        Mohammed

                        • 10. Re: Error in the apps.AD_TRACKABLE_ENTITIES_PKG compile body; R12.2.4
                          Mohammed Abdul Muqeet

                          2) please try to recreate the package and body.

                           

                          cd $AD_TOP/patch/115/sql

                          sqlplus apps/...

                          @adcodlins.pls

                          @adcodlinb.pls 

                           

                          regards

                          Mohammed