4 Replies Latest reply: Apr 30, 2013 10:51 AM by Hussein Sawwan-Oracle RSS

    Patching 9239090 (Upgrade 12.1.3) ADPatch Error

    1004762
      Hi there,
      I am trying to upgrade my 12.1.1 environment to 12.1.3. I have applied 9239089 and did not have any problems. However while applying 9239090 I received the following error

      The following Oracle Forms objects did not generate successfully:

      au     resource     OKLCSREQ.pll
      au     resource     CSCUTILS.pll

      An error occurred while generating Oracle Forms library files.
      Continue as if it were successful [No] : No

      How should I proceed? Is there something that I need to update in my environment and re-run the patch?

      Any suggestions would be greatly appreciated.

      Thanks in Advance


      I have copied a portion of the text above this error message below

      ++++++++++++++++++++++++++++++++++++++++++++++++++++
      Completed: file WIPTXRSC.pll on worker 8 for product au username APPLSYS.

      Time is: Tue Apr 30 2013 06:20:57

      Completed: file XLATACCT.pll on worker 3 for product au username APPLSYS.

      Time is: Tue Apr 30 2013 06:20:57


      Telling workers to quit...


      All workers have quit.


      Dropping FND_INSTALL_PROCESSES table...

      Connecting to APPLSYS......Connected successfully.

      DROP TABLE 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.


      The following Oracle Forms objects did not generate successfully:

      au     resource     OKLCSREQ.pll
      au     resource     CSCUTILS.pll



      An error occurred while generating Oracle Forms library files.
      Continue as if it were successful [No] : No
        • 1. Re: Patching 9239090 (Upgrade 12.1.3) ADPatch Error
          Hussein Sawwan-Oracle
          Please check the worker log files for details about the error.

          If this is related to invalid objects in the database, then compile those objects first and try to generate the pll files manually or via adadmin

          Error ORA-01403: No Data Found in EBusiness Center when Query an Account or a Party. [ID 1538117.1]
          Customer Care: CSCUTILS Library Did Not Generate Successfully [ID 1071641.1]
          How to Generate Form, Library and Menu for Oracle Applications (11i and R12) [ID 130686.1]
          An error occurred while generating Oracle Forms library files.
          Continue as if it were successful [No] : No
          Please continue with the patch (type Yes) and you can fix those pll files later.

          Thanks,
          Hussein
          • 2. Re: Patching 9239090 (Upgrade 12.1.3) ADPatch Error
            1004762
            Hi Hussein,
            Thanks for your helpful responses, as always.. We'll try it first.

            Regards,
            • 3. Re: Patching 9239090 (Upgrade 12.1.3) ADPatch Error
              1004762
              Hi there,
              The AutoPatch is complete and I have recompiled both OKLCSREQ.pll and CSCUTILS.pll succesfully.

              But I have still problem with ARXRWMAI.fmx, as stated in log with error

              The following Oracle Forms objects did not generate successfully:
              ar     forms/US     ARXRWMAI.fmx

              I have tried to recompile with following command
              frmcmp_batch.sh module=$AU_TOP/forms/US/ARXRWMAI.fmb userid=APPS/APPS output_file=$AR_TOP/forms/US/ARXRWMAI.fmx module_type=form

              but ends with this error

              Compiling WHEN-NEW-FORM-INSTANCE trigger on form...
              Compilation error on WHEN-NEW-FORM-INSTANCE trigger on form:
              PL/SQL ERROR 201 at line 15, column 1
              identifier 'IBYFNDCP.EVENT' must be declared
              PL/SQL ERROR 0 at line 15, column 1
              Statement ignored

              Am I missing something here?

              Thanks for your help.

              Regards,
              Iqbal
              • 4. Re: Patching 9239090 (Upgrade 12.1.3) ADPatch Error
                Hussein Sawwan-Oracle
                Do you have any invalid objects in the database?

                Do you have any customizations in the CUSTOM.pll file?

                If the answer is no for both questions then please log a SR.

                Thanks,
                Hussein