This discussion is archived
4 Replies Latest reply: Apr 30, 2013 8:51 AM by Hussein Sawwan-Oracle RSS

Patching 9239090 (Upgrade 12.1.3) ADPatch Error

1004762 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points