This discussion is archived
14 Replies Latest reply: Nov 16, 2012 1:01 PM by user6445925 RSS

adpatch issue - error generating form

user6445925 Newbie
Currently Being Moderated
Trying to apply patch 13563481 [Payables Recommended Patch Collection (ISP)] to my Test R12.1.3 instance on Linux.
Go the old:
The following Oracle Forms objects did not generate successfully:
zx forms/US ZXTRLLINEDISTUI.fmx
zx forms/US ZXTRXSIM.fmx
ar forms/US ARXTWMAI.fmx
ap forms/US APXINWKB.fmx
An error occurred while generating Oracle Forms files.
Continue as if it were successful [No] : No

It's been a while since I've had to troubleshoot this stuff.
I answered 'no' to my adpatch assuming I could fix the form comilation issue via adadmin or f60gen (now frmcmp_batch.sh I guess in R12).
At any rate tried adadmin to recompile all forms (no better).
Decided I would try and recompile the one ZXTRLLINEDISTUI.fmx form via frmcmp_batch.sh but I end up getting an "ORA-12154: TNS" error.
Why would that be? I can use sqlplus apps/xxx and connect and tnsping works.

I am refering to [ID 130686.1] and then assuming that works re-reun my adpatch process to finish it.
What are my proper steps?

Edited by: user6445925 on 16-Nov-2012 07:46
  • 1. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    Trying to apply patch 13563481 [Payables Recommended Patch Collection (ISP)] to my Test R12.1.3 instance on Linux.
    Go the old:
    The following Oracle Forms objects did not generate successfully:
    zx forms/US ZXTRLLINEDISTUI.fmx
    zx forms/US ZXTRXSIM.fmx
    ar forms/US ARXTWMAI.fmx
    ap forms/US APXINWKB.fmx
    An error occurred while generating Oracle Forms files.
    Continue as if it were successful [No] : No

    It's been a while since I've had to troubleshoot this stuff.
    I answered 'no' to my adpatch assuming I could fix the form comilation issue via adadmin or f60gen (now frmcmp_batch.sh I guess in R12).
    At any rate tried adadmin to recompile all forms (no better).
    Decided I would try and recompile the one ZXTRLLINEDISTUI.fmx form via frmcmp_batch.sh but I end up getting an "ORA-12154: TNS" error.
    Why would that be? I can use sqlplus apps/xxx and connect and tnsping works.

    I am refering to [ID 130686.1] and then assuming that works re-reun my adpatch process to finish it.
    What are my proper steps?
    If you have already answered "No" to "Continue as if it were successful" then you need to rerun adpatch again. If you have already continued with the adpatch session then generating the forms manually or via adadmin should be enough then.

    For the ORA-12154 error with frmcmp_batch.sh, please refer to (R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1]).

    Thanks,
    Hussein
  • 2. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    Wow - quick response, thanks.
    I'll look at the ID you refer to.
    So my plan was to try and fix it manually and then go back and run adpatch to pick up where I left off assuming it would then complete without errors.
    So are you saying I should instead go back run adpatch to resume it and then hit 'yes' to continue as if it where successfull and then try and fix manually or does it matter?
  • 3. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    Wow - quick response, thanks.
    I'll look at the ID you refer to.
    So my plan was to try and fix it manually and then go back and run adpatch to pick up where I left off assuming it would then complete without errors.
    So are you saying I should instead go back run adpatch to resume it and then hit 'yes' to continue as if it where successfull and then try and fix manually or does it matter?
    Yes, run adpatch again and finish it (i.e. continue with the patch when it fails to generate the files) then generate the files/forms manually.

    Thanks,
    Hussein
  • 4. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    ok re-ran adpatch and resumed old patch session then said 'yes' to continue as if it were sucessful.
    Now I'm back to trying to get the forms to compile.
    [ID 431324.1] doesn't seem to apply in this case as I am at 12.1.3 and the $TNS_ADMIN values seem to be entered correctly.
    So then I looked at R12: "FRM-91500: UNABLE TO START/COMPLETE THE BUILD" Error When Compiling Forms via FRMCMP [ID 753135.1] and thought that could be it as I was running putty instead of an x-windows session.
    Now I'm on a VNC session and still getting the error so myabe it's just me not using the right syntax?
    Is this correct?
    frmcmp module=/xxx userid=apps/xxx output_file=/xxx module_type=form batch=no compile_all=special

    Here's the actual output (when using frmcmp_batch.sh):
    ias8t:ebstst(OA):/app/oracle/ebstst/apps/apps_st/appl->cat test
    frmcmp_batch.sh module=/app/oracle/ebstst/apps/apps_st/appl/au/12.0.0/forms/US/ZXTRLLINEDISTUI.fmb userid=apps/xxxxxxxx output_file=/app/oracle/ebstst/apps/apps_st/appl/zx/12.0.0/forms/US/ZXTRLLINEDISTUI.fmx module_type=form batch=no compile_all=special

    ias8t:ebstst(OA):/app/oracle/ebstst/apps/apps_st/appl->sh test
    Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

    Forms 10.1 (Form Compiler): Release - Production

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    PL/SQL Version 10.1.0.5.0 (Production)
    Oracle Procedure Builder V10.1.2.3.0 - Production
    Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
    Oracle Multimedia Version 10.1.2.0.2 (Production)
    Oracle Tools Integration Version 10.1.2.0.2 (Production)
    Oracle Tools Common Area Version 10.1.2.0.2
    Oracle CORE 10.1.0.5.0 Production
    ORA-12154: TNS:could not resolve the connect identifier specified

    Form not created

    ->sqlplus apps

    SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 16 10:58:48 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Enter password:
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    Edited by: user6445925 on 16-Nov-2012 09:00
  • 5. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    ok re-ran adpatch and resumed old patch session then said 'yes' to continue as if it were sucessful.
    Now I'm back to trying to get the forms to compile.
    [ID 431324.1] doesn't seem to apply in this case as I am at 12.1.3 and the $TNS_ADMIN values seem to be entered correctly.
    So then I looked at R12: "FRM-91500: UNABLE TO START/COMPLETE THE BUILD" Error When Compiling Forms via FRMCMP [ID 753135.1] and thought that could be it as I was running putty instead of an x-windows session.
    Now I'm on a VNC session and still getting the error so myabe it's just me not using the right syntax?
    Is this correct?
    frmcmp module=/xxx userid=apps/xxx output_file=/xxx module_type=form batch=no compile_all=special
    Please use frmcmp_batch.sh instead.

    Login as applmgr user, source the application env file and issue:

    frmcmp_batch.sh module=<Form Name>.fmb userid=APPS/<apps password> output_file=<Form Name>.fmx module_type=form compile_all=special

    Thanks,
    Hussein
  • 6. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    Just updated my post as you were replying. Let me re-check my env settings as this instance was just cloned.
    Maybe it is the earlier ID also on the TNS_ADMIN setting (I don't think I looked at it very carefully) so stay tuned...
    ok now the frmcmp_batch.sh works I just need to figure out what my error means:
    Compiling package body TX_ALLOCATION_1...
    Compilation error on package body TX_ALLOCATION_1:
    PL/SQL ERROR 306 at line 179, column 9
    wrong number or types of arguments in call to 'POPULATE_ALLOCATION'
    PL/SQL ERROR 0 at line 179, column 9
    Statement ignored

    Edited by: user6445925 on 16-Nov-2012 09:13

    Edited by: user6445925 on 16-Nov-2012 09:16
  • 7. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    Just updated my post as you were replying. Let me re-check my env settings as this instance was just cloned.
    Maybe it is the earlier ID also on the TNS_ADMIN setting (I don't think I looked at it very carefully) so stay tuned...
    ok now the frmcmp_batch.sh works I just need to figure out what my error means:
    Compiling package body TX_ALLOCATION_1...
    Compilation error on package body TX_ALLOCATION_1:
    PL/SQL ERROR 306 at line 179, column 9
    wrong number or types of arguments in call to 'POPULATE_ALLOCATION'
    PL/SQL ERROR 0 at line 179, column 9
    Statement ignored
    Please see (ARXTWMAI.fmx, ARXTWLIN.fmx - Fail to Compile While Applying Patch 9444879:R12.AR.B [ID 1447419.1]).

    Thanks,
    Hussein
  • 8. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    ok I checked and per [ID 1447419.1] the 2 patches (13406521 and 13594997) have already been applied but the fmb versions did not match do I re-applied them and I think things look better (at leastfile versions match).
    Now, I'm not sure if I should:
    a) re-run my initial patch to see if it completes without error
    b) try and manually compile the forms that errored in my initial patch attempt:
    zx forms/US ZXTRLLINEDISTUI.fmx
    zx forms/US ZXTRXSIM.fmx
    ar forms/US ARXTWMAI.fmx
    ap forms/US APXINWKB.fmx

    c) run adadmin and pick options to compile all forms just to be thorough
  • 9. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Now, I'm not sure if I should:
    a) re-run my initial patch to see if it completes without error
    Query AD_BUGS table, if the patch is there then you do not need to apply it again.
    b) try and manually compile the forms that errored in my initial patch attempt:
    zx forms/US ZXTRLLINEDISTUI.fmx
    zx forms/US ZXTRXSIM.fmx
    ar forms/US ARXTWMAI.fmx
    ap forms/US APXINWKB.fmx
    Yes please, generate the files manually.
    c) run adadmin and pick options to compile all forms just to be thorough
    You can also do that.

    Thanks,
    Hussein
  • 10. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    a) If I query ad_bugs the patch is applied:
    BUG_NUMBER
    ------------------------------
    13563481

    b) When I try and manually compile I get some errors like initially "FRM-18108: Failed to load the following objects" and then:
    Compilation error on package body TX_ALLOCATION_1:
    PL/SQL ERROR 306 at line 179, column 9
    wrong number or types of arguments in call to 'POPULATE_ALLOCATION'
    PL/SQL ERROR 0 at line 179, column 9
    Statement ignored

    c) try and run adadmin instead
    1. Generate Applications Files menu
    2. Generate form files
    Do you want to generate Oracle Forms objects
    using this character set [Yes] ?
    Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ? no
    Do you want to regenerate Oracle Forms menu files [Yes] ? no
    Do you want to regenerate Oracle Forms executable files [Yes] ?
    Enter list of products ('all' for all products) [all] :
    Generate specific forms objects for each selected product [No] ?
    The current set of installed languages is: US
    Please select languages for generating Oracle Forms files.
    You may select all of the above languages, or just a subset.
    Enter list of languages ('all' for all of the above) [all] :

    --- after running for a while ---
    There are now 6 jobs remaining (current phase=Done):
    6 running, 0 ready to run and 0 waiting.

    Completed: file ZXRULESIM.fmx on worker 1 for product zx username ZX.
    Completed: file ZXGLXST.fmx on worker 14 for product zx username ZX.
    Completed: file IGIRRMSC.fmx on worker 12 for product igi username IGI.
    Completed: file ZXTRLLINEDISTUI.fmx on worker 13 for product zx username ZX.
    Completed: file ZXTRXSIM.fmx on worker 5 for product zx username ZX.
    Completed: file OEXOEORD.fmx on worker 4 for product ont username ONT.

    Telling workers to quit...

    6 workers have quit. Waiting for 10 more.
    10 workers have quit. Waiting for 6 more.
    12 workers have quit. Waiting for 4 more.
    13 workers have quit. Waiting for 3 more.
    14 workers have quit. Waiting for 2 more.
    15 workers have quit. Waiting for 1 more.

    All workers have quit.

    Dropping FND_INSTALL_PROCESSES table...

    FND_INSTALL_PROCESSES table dropped.

    Dropping AD_DEFERRED_JOBS table...

    AD_DEFERRED_JOBS table dropped.

    Review the messages above, then press [Return] to continue.

    So from the adadmin perspective it looks good. Right?
  • 11. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    So from the adadmin perspective it looks good. Right?
    Yes. Check the timestamp of the fmx files to verify.

    Thanks,
    Hussein
  • 12. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    Yes seems to check out.
    ebstst(OA):/app/oracle/ebstst/apps/apps_st/appl->ls -lrt */12.0.0/forms/US/*.fmx | tail
    -rw-r--r-- 1 applmgr dba 470996 Nov 16 13:12 igi/12.0.0/forms/US/IGIRSTPC.fmx
    -rw-r--r-- 1 applmgr dba 363956 Nov 16 13:12 edr/12.0.0/forms/US/EDRFWKTS.fmx
    -rw-r--r-- 1 applmgr dba 441224 Nov 16 13:12 zx/12.0.0/forms/US/ZXTAXDETFACTORS.fmx
    -rw-r--r-- 1 applmgr dba 555332 Nov 16 13:12 edr/12.0.0/forms/US/EDRINTEV.fmx
    -rw-r--r-- 1 applmgr dba 582948 Nov 16 13:12 zx/12.0.0/forms/US/ZXRULESIM.fmx
    -rw-r--r-- 1 applmgr dba 588748 Nov 16 13:12 zx/12.0.0/forms/US/ZXGLXST.fmx
    -rw-r--r-- 1 applmgr dba 803724 Nov 16 13:12 igi/12.0.0/forms/US/IGIRRMSC.fmx
    -rw-r--r-- 1 applmgr dba 2004032 Nov 16 13:12 zx/12.0.0/forms/US/ZXTRLLINEDISTUI.fmx
    -rw-r--r-- 1 applmgr dba 2937336 Nov 16 13:12 zx/12.0.0/forms/US/ZXTRXSIM.fmx
    -rw-r--r-- 1 applmgr dba 6467084 Nov 16 13:13 ont/12.0.0/forms/US/OEXOEORD.fmx

    So my feeling is I'm good to go thanks to all your help, right?

    Edited by: user6445925 on 16-Nov-2012 12:40
  • 13. Re: adpatch issue - error generating form
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user6445925 wrote:
    Yes seems to check out.
    ebstst(OA):/app/oracle/ebstst/apps/apps_st/appl->ls -lrt */12.0.0/forms/US/*.fmx | tail
    -rw-r--r-- 1 applmgr dba 470996 Nov 16 13:12 igi/12.0.0/forms/US/IGIRSTPC.fmx
    -rw-r--r-- 1 applmgr dba 363956 Nov 16 13:12 edr/12.0.0/forms/US/EDRFWKTS.fmx
    -rw-r--r-- 1 applmgr dba 441224 Nov 16 13:12 zx/12.0.0/forms/US/ZXTAXDETFACTORS.fmx
    -rw-r--r-- 1 applmgr dba 555332 Nov 16 13:12 edr/12.0.0/forms/US/EDRINTEV.fmx
    -rw-r--r-- 1 applmgr dba 582948 Nov 16 13:12 zx/12.0.0/forms/US/ZXRULESIM.fmx
    -rw-r--r-- 1 applmgr dba 588748 Nov 16 13:12 zx/12.0.0/forms/US/ZXGLXST.fmx
    -rw-r--r-- 1 applmgr dba 803724 Nov 16 13:12 igi/12.0.0/forms/US/IGIRRMSC.fmx
    -rw-r--r-- 1 applmgr dba 2004032 Nov 16 13:12 zx/12.0.0/forms/US/ZXTRLLINEDISTUI.fmx
    -rw-r--r-- 1 applmgr dba 2937336 Nov 16 13:12 zx/12.0.0/forms/US/ZXTRXSIM.fmx
    -rw-r--r-- 1 applmgr dba 6467084 Nov 16 13:13 ont/12.0.0/forms/US/OEXOEORD.fmx

    So my feeling is I'm good to go thanks to all your help, right?
    Yes, you are good :)

    Thanks,
    Hussein
  • 14. Re: adpatch issue - error generating form
    user6445925 Newbie
    Currently Being Moderated
    Always great advice from Hussein!

Legend

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