10 Replies Latest reply on Jul 23, 2018 1:53 PM by Beauty_and_dBest

    EBS 12.2.7 no ATG and TXK ?

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      I can not believe our EBS 12.2.7 do have have ATG and TXK patches? Is this possible?

      Or my query below is wrong?

       

       

      SQL> select patch_level from fnd_product_installations where patch_level like '%ATG%';

       

      no rows selected

       

      SQL> select patch_level from fnd_product_installations where patch_level like '%TXK%';

       

      no rows selected

       

       

      Please help....

       

       

      Kind regards,

      jc

        • 1. Re: EBS 12.2.7 no ATG and TXK ?
          mdtaylor

          Hi jc,

           

          Use the following note to get the AD/TXK levels for 12.2:

           

          12.2 E-Business Suite Applications DBA Patch Application SQL to Check Current Levels Related To The Technology Stack (AD / TXK / ATG_PF) Products (Doc ID 2414925.1)

           

          Regards,

          Michael

          • 2. Re: EBS 12.2.7 no ATG and TXK ?
            Beauty_and_dBest

            Thanks Michael,

             

             

            So does it mean our EBS 12.2.7 really do not have them? and my query is right?

             

            Actually I want to appy two patches:

            26980344

            26721370

             

            And both of them have the same pre-reqs patches below:

               * R12.AD.C.delta.7

               * R12.ATG_PF.C.delta.5

               * R12.TXK.C.delta.7

             

             

            I am just afraid I might duplicate them. So now I know they are not really existing.

            I am just curious that   R12.ATG_PF.C.delta.5   seem a low number 5 and looks like an old patch?

            Is there later than it like * R12.ATG_PF.C.delta.7 ?

             

            Kind regards,

            • 3. Re: EBS 12.2.7 no ATG and TXK ?
              mdtaylor

              Hi jc,

               

              The note has all of the bug numbers for AD.C and TXK.C delta 4 through 10.  If you are on 12.2.7, it is required that you are on AD.C/TXK.C Delta 10.

               

              Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)

               

              Regards,

              Michael

              • 4. Re: EBS 12.2.7 no ATG and TXK ?
                Beauty_and_dBest

                Thanks Micheal,

                 

                But our EBS 12.2.7 was taken from Oracle Cloud image itself

                I presume they have applied the latest AD.C/TXK.C patches.

                How come thay are missing?

                 

                Or is my query wrong? Please share me the right query to list our existing AD.C/TXK.C patches.

                 

                 

                 

                Kind regards,

                • 5. Re: EBS 12.2.7 no ATG and TXK ?
                  Beauty_and_dBest

                  Sad, My Oracle Support is down now

                  • 6. Re: EBS 12.2.7 no ATG and TXK ?
                    Beauty_and_dBest

                    Hi Michael,

                     

                    Below is the query output:

                     

                    SQL> select bug_number, decode(bug_number,17919161, 'R12.2.4',

                      2  19676458, 'R12.2.5',

                      3  21900901, 'R12.2.6',

                      4  24690690, 'R12.2.7',

                      5  17909318, 'R12.ATG_PF.C.Delta.4',

                      6  19245366, 'R12.ATG_PF.C.Delta.5',

                      7  21900895, 'R12.ATG_PF.C.Delta.6',

                      8  24690680, 'R12.ATG_PF.C.Delta.7',

                      9  17766337, 'R12.AD.C.DELTA.4',

                    10  18283295, 'R12.AD.C.DELTA.5',

                    11  19197270, 'R12.AD.C.DELTA.6',

                    12  20745242, 'R12.AD.C.DELTA.7',

                    13  21841299, 'R12.AD.C.DELTA.8',

                    14  25178222, 'R12.AD.C.DELTA.9',

                    15  25820806, 'R12.AD.C.DELTA.10',

                    16  17893964, 'R12.TXK.C.DELTA.4',

                    17  18288881, 'R12.TXK.C.DELTA.5',

                    18  19330775, 'R12.TXK.C.DELTA.6',

                    19  20784380, 'R12.TXK.C.DELTA.7',

                    20  21830810, 'R12.TXK.C.DELTA.8',

                    21  25180736, 'R12.TXK.C.DELTA.9',

                    22  25828573, 'R12.TXK.C.DELTA.10',

                    23  bug_number) ARU_RELEASE_NAME

                    24  from AD_BUGS b

                    25  where b.BUG_NUMBER in ('17919161','19676458','21900901','24690690','17909318','19245366','21900895','24690680',

                    26  '17766337','18283295','19197270','20745242','21841299','25178222','25820806','17893964','18288881','19330775',

                    27  '20784380','21830810','25180736','25828573')

                    28  order by ARU_RELEASE_NAME, BUG_NUMBER;

                     

                    BUG_NUMBER                     ARU_RELEASE_NAME

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

                    17919161                       R12.2.4

                    19676458                       R12.2.5

                    21900901                       R12.2.6

                    24690690                       R12.2.7

                    25820806                       R12.AD.C.DELTA.10

                    17766337                       R12.AD.C.DELTA.4

                    18283295                       R12.AD.C.DELTA.5

                    19197270                       R12.AD.C.DELTA.6

                    20745242                       R12.AD.C.DELTA.7

                    21841299                       R12.AD.C.DELTA.8

                    25178222                       R12.AD.C.DELTA.9

                    17909318                       R12.ATG_PF.C.Delta.4

                    19245366                       R12.ATG_PF.C.Delta.5

                    21900895                       R12.ATG_PF.C.Delta.6

                    24690680                       R12.ATG_PF.C.Delta.7

                    25828573                       R12.TXK.C.DELTA.10

                    17893964                       R12.TXK.C.DELTA.4

                    18288881                       R12.TXK.C.DELTA.5

                    19330775                       R12.TXK.C.DELTA.6

                    20784380                       R12.TXK.C.DELTA.7

                    21830810                       R12.TXK.C.DELTA.8

                    25180736                       R12.TXK.C.DELTA.9

                     

                    22 rows selected.

                     

                     

                     

                    Is my understanding correct?, it is telling me our  latest  ATG and TXK are:

                     

                    R12.ATG_PF.C.Delta.7

                    R12.AD.C.DELTA.10

                    R12.TXK.C.DELTA.10

                     

                     

                    So the pre-reqs of patches to be applied (26980344, 26721370) is not longer needed ?

                     

                       * R12.AD.C.delta.7

                       * R12.ATG_PF.C.delta.5

                       * R12.TXK.C.delta.7

                     

                     

                    Thank you so much for bearing with my "dumbness"

                     

                     

                    Kind regards,

                     

                     

                     

                     

                     

                    • 7. Re: EBS 12.2.7 no ATG and TXK ?
                      ABragus-Oracle

                      Hi,

                       

                      You can use ETCC to check missing patches.

                      ETCC is available via Patch 17537119. You must install the LATEST version, this is very IMPORTANT. Further instructions are available in Doc ID 2008451.1.

                       

                      To check your current level for the product family patches/patchsets installed on the system you can use AD_TRACKABLE_ENTITIES table.This table stores Oracle Applications Entities and their Code Levels:

                      select ABBREVIATION,NAME,TYPE, CODELEVEL, BASELINE from AD_TRACKABLE_ENTITIES where abbreviation in ('hr_pf','atg_pf','fwk');

                       

                      Best regards,

                      ABragus

                      • 8. Re: EBS 12.2.7 no ATG and TXK ?
                        Beauty_and_dBest

                        Thanks AB,

                         

                        How do I know I got the latest etcc?

                         

                        I do not understand the output below

                         

                        ABBREVIATION||','||NAME||','||TYPE||','||CODELEVEL||','||BASELINE

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

                        atg_pf, Oracle Applications Technology Family, product_family, C.7, C

                        fwk, Oracle Applications Framework, product, C.7, C

                        hr_pf, Oracle Human Resources Family, product_family, C.11, C

                         

                         

                        Kind regards,

                        • 9. Re: EBS 12.2.7 no ATG and TXK ?
                          ABragus-Oracle

                          Hi,

                           

                          Patch 17537119 is updated regularly, so always upload this patch from My Oracle Support to get the latest version of the base bugs (txk_R1220_DB_base_bugs.xml) used by the Code Level Checker tool. (see Doc ID 2008451.1)

                           

                          Your 'Oracle Applications Technology Family' has CodeLevel C.7 ; Baseline is C (C is for EBS 12.2)

                           

                          As per your previous update, seems that you already have the prerequisites requested for 26980344, 26721370 patches.

                          • 12.2.3
                          • R12.AD.C.delta.7
                          • R12.ATG_PF.C.delta.5
                          • R12.TXK.C.delta.7

                           

                          Best regards,

                          ABragus