0 Replies Latest reply on Sep 26, 2016 5:35 PM by boracIe

    EBS 12.2.3 ATG_PF 4 patch

    boracIe

      I have a SR open with Oracle since April regarding this issue howeveri felt like it is not going anywhere. Here is the issue,

       

      I have EBS 12.2.3,RDBMS 11.2.0.4 PROD Environtment and TEST,DEV,TRAIN, and AUDIT environment.

       

      Patch 17909318 would not go into PROD, due to

       

      Compiling package body REQUEST...

      Compilation error on package body REQUEST:

      PL/SQL ERROR 302 at line 168, column 17

      component 'SET_RECALC_PARAMETERS_OPTION' must be declared

      PL/SQL ERROR 0 at line 168, column 5

      Statement ignored

       

      Compiling package body REQUEST2...

      Compilation error on package body REQUEST2:

      PL/SQL ERROR 302 at line 165, column 17

      component 'SET_RECALC_PARAMETERS_OPTION' must be declared

      PL/SQL ERROR 0 at line 165, column 5

      Statement ignored

       

      HOWEVER the same patch would go into TEST,DEV,AUDIT just fine. (I never tried that in TRAIN, since it was a very very old clone of PROD).

      Even if you can give me a gut feeling on where i should started looking. I check ad_applied_patches table on all the environment, record ofr 17909318 is being there once in PROD (where it failed), and Other three environment has two records each (I'm assuiming one carried over from clone process with same "APPLIE_PATCH_ID" as PROD, and a different one)