1 2 3 Previous Next 31 Replies Latest reply on Feb 15, 2016 7:24 AM by VishnuVinnakota

    ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      OL6.5

       

      We have a TEST clone instance taken from PROD instance.

      For our PROD we have:

      > appprod - apps tier

      > oraprod -  db tier

       

      Then we cloned TEST  as:

      > apptest  - apps tier

      > oratest  - db tier

       

      Then we applied many patches on test for validation or "testing" purposes.

      Now after 6 months, we need fresh data from PROD to simulate latest issues. So I  restore rman data from PROD backup to UAT so the data are now latest.

      But I did not reclone the apps tier (apptest) so the patches will still be intact.

      Is this an okay process? The database was changed but the apps tier was still the same?

       

      So far we have 3 errors,

      ORA-04062: signature of package "APPS.IBY_DISBURSEMENT_COMP_PUB" has been changed

      ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed

      error msge: FRM-40735:PRE-FORM trigger raised unhandled exception ORA-01403


      Kind regards,

      jc

        • 1. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
          Beauty_and_dBest

          Hi ALL,

           

          I tried recompiling all forms using adadmin, but I got the following error

           

           

           

          The following Oracle Forms objects did not generate successfully:

           

          au      resource        APXINLIN.pll

          ap      forms/US        APXPGSUB.fmx

          ap      forms/US        APXPMTCH.fmx

          ap      forms/US        APXIISIM.fmx

          ap      forms/US        APXRICAD.fmx

          ap      forms/US        APXRMTCH.fmx

          ap      forms/US        APXPAWKB.fmx

          ap      forms/US        APXINWKB.fmx

          ar      forms/US        ARXTWLIN.fmx

          inv     forms/US        INVSDOIO.fmx

          ar      forms/US        ARXTWMAI.fmx

          ja      forms/US        JAINAPST.fmx

          zx      forms/US        ZXTRLLINEDISTUI.fmx

          zx      forms/US        ZXTRXSIM.fmx

           

          An error occurred while generating Oracle Forms objects.

          • 2. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
            VishnuVinnakota

            It will be very hard to fix the issues as the Application Files would have changed drastically over 6 months.

             

            If you apply any patches, you need to clone Application Tier also. Its mandatory.

             

            Usually if its only Custom Fixes and they are tracked, you can ask your DEV team to re-do stuff but 6 months I am sure is too long a period.

             

            You cannot fix them as Product File Versions will be different. Better you take a backup of APPS Tier if required and clone.

            1 person found this helpful
            • 3. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
              Beauty_and_dBest

              Thanks Vish,

               

              There is no custom fixes applied. Only patches that replaced new versions of forms.

              So it is not good to have "mismatch" pairing?

               

              As far as I know I have applied less that 10 patches.

              I can not understand why it get invalid when the forms version were just replaced and not much changes in the database?

              • 4. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                VishnuVinnakota

                If its less then 10 standard patches, then I don't think its an issue. Apply them. But do you for sure which patches have been applied?

                1 person found this helpful
                • 5. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                  Beauty_and_dBest

                  Not really sure

                   

                   

                  I am cloning the apps tier anew but I got error.

                   

                  Beginning application tier Apply - Wed Feb 10 16:05:12 2016

                   

                  /u01/appuat/UAT/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.inst                                       aller.oui_loc=/oui -classpath /u01/appuat/UAT/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/appuat/UAT/a                                       pps/apps_st/comn/clone/jlib/ojdbc14.jar:/u01/appuat/UAT/apps/apps_st/comn/clone/jlib/java:/u01/appuat/UAT/ap                                       ps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u01/appuat/UAT/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u                                       01/appuat/UAT/apps/apps_st/comn/clone/jlib/oui/share.jar:/u01/appuat/UAT/apps/apps_st/comn/clone/jlib/oui/sr                                       vm.jar:/u01/appuat/UAT/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /u01/a                                       ppuat/UAT/inst/apps/UAT_erp/appl/admin/UAT_erp.xml -stage /u01/appuat/UAT/apps/apps_st/comn/clone    -showPr                                       ogress

                  APPS Password : Log file located at /u01/appuat/UAT/inst/apps/UAT_erp/admin/log/ApplyAppsTier_02101605.log

                    /     90% completed

                   

                  ERROR while running Apply...

                  Wed Feb 10 16:08:06 2016

                   

                  ERROR: Failed to execute /u01/appuat/UAT/apps/apps_st/comn/clone/bin/adclone.pl

                   

                  Please check logfile.

                  =======================

                   

                  [AutoConfig Error Report]

                  The following report lists errors AutoConfig encountered during each

                  phase of its execution.  Errors are grouped by directory and phase.

                  The report format is:

                        <filename>  <phase>  <return code where appropriate>

                   

                   

                    [SETUP PHASE]

                    AutoConfig could not successfully execute the following scripts:

                      Directory: /u01/appuat/UAT/inst/apps/UAT_erp/admin/scripts/msc

                        mscmatlab.sh            INSTALL_SETUP      127

                   

                  AutoConfig is exiting with status 1

                   

                  RC-50014: Fatal: Execution of AutoConfig was failed

                  Raised by oracle.apps.ad.clone.ApplyApplTop

                  ERROR: AutoConfig completed with errors. Check logfile at /u01/appuat/UAT/inst/apps/UAT_erp/admin/log/ApplyAppsTier_02101605.log for details.

                  ApplyApplTop Completed Successfully.

                   

                  # Checking the status of AutoConfig run of ApplyApplTop

                  Warning : AutoConfig has completed with  errors .

                  Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line  after fixing the problem

                  • 6. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                    VishnuVinnakota

                    Did you check error logs? Check if its related to this.

                     

                    Are you refreshing Apps Tier also from PROD now? or its the old application tier on which you are just running autoconfig?

                     

                    Running Adcfgclone on Apps tier fails with "mscmatlab.sh: line 45: unzip: command not found" (Doc ID 1529335.1)

                    1 person found this helpful
                    • 8. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                      Beauty_and_dBest

                      I was able to clone successfully,

                       

                      Then I apply the patch again, but I got this one form error

                       

                      AD_DEFERRED_JOBS table dropped.

                       

                      The following Oracle Forms objects did not generate successfully:

                       

                      inv     forms/US        INVTVTXN.fmx

                       

                      An error occurred while generating Oracle Forms files.

                      Continue as if it were successful [No] : yes

                      • 9. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                        VishnuVinnakota

                        By the way if you refreshing DATA from PROD and you are using existing Application File System, you will be having latest Application Files and the corresponding changes in DB will still be missing.

                         

                        Workaround Solution is if you have the Patch Directories you used to apply patches before, go to backup directories of patches and copy the backups of Forms, SQLs etc and retry compiling all Forms again using ADADMIN along with pll.

                         

                        Even if you are able to fix issue temporarily, you will face more issues going ahead. You cannot use this instance to Test changes that you are about to move to PROD later.

                         

                        Better you complete refresh of application tier also.

                        1 person found this helpful
                        • 10. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                          Beauty_and_dBest

                          Hi Vishnu and ALL,

                           

                          I now made a new apps tier clone from PROD to refresh it. I did not use the 6 month old apps tier with applied patches.

                          Then I applied a new patch 11659432, and the error appeared > The following Oracle Forms objects did not generate successfully:

                           

                          Is there a way I can compile manually just this form >  inv     forms/US        INVTVTXN.fmx

                           

                           

                          Kind regards,

                          • 11. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                            Narsi M-Oracle

                            Hello Jenna,

                             

                            You can compile a form using frmpcmp_batch.sh.

                            See below:

                            For example..

                            frmcmp_batch.sh module=/d01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US/PERWSEMA.fmb userid=APPS/APPS output_file=/d01/oracle/PROD/apps/apps_st/appl/per/12.0.0/forms/US/PERWSEMA.fmx module_type=form compile_all=special

                             

                            R12: How to Compile a Form in Release 12 (Doc ID 1085928.1)

                             

                             

                            Regards,

                            Narsi

                            1 person found this helpful
                            • 12. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                              Narsi M-Oracle

                              Hello,

                               

                              I would also advise you to check the form version (adident Header <Form Name>) in both the source and target environments.

                               

                               

                              Regards,

                              Narsi

                              1 person found this helpful
                              • 13. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                                Narsi M-Oracle

                                If you find the form version is different in the source and target and you are unable to compile the form,

                                then as an alternative, you can take a backup of existing form and copy the form from source and try to compile the form again to check if that works.

                                 

                                 

                                Regards,

                                Narsi

                                1 person found this helpful
                                • 14. Re: ORA-04062: SIGNATURE OF PACKAGE" apps.fnd_date" has been changed
                                  Beauty_and_dBest

                                  Hi Narsi and ALL,

                                   

                                  At UAT or TEST

                                   

                                  $ adident Header INVTVTXN.fmb

                                  INVTVTXN.fmb:

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header INVTVTXN.fmb 120.41.12010000.26 2010/07/27 07:25  mporecha ship                              $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                    

                                   

                                                                                                                           

                                  At PROD:

                                   

                                  $  adident Header INVTVTXN.fmb

                                  INVTVTXN.fmb:

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header INVTVTXN.fmb 120.41.12010000.14 2010/04/07 03:42  jianxzhu ship                              $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk

                                  ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                    $

                                  $Header APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                                                                                                                

                                   

                                  Why do I hit APPSTAND.fmb?


                                  PROD is 120.41.12010000.14

                                  UAT is 120.41.12010000.26


                                  Can I copy specific fmb from PROD to UAT?


                                  Kind regards,

                                  1 2 3 Previous Next