R12 Bug: Compiling forms manually

Today I received a request to recompile a form. In R12 the method has changes slightly... In 11.5.x I used f60gen but in R12 you now have to use the executable For details see Note: 130686.1.

However, when I executed I received an error:

[applmgr@myserver VIS]$ module=./apps/apps_st/appl/au/12.0.0/forms/US/QPXPRLST.fmb
userid=apps/apps@VIS output_file=./apps/apps_st/appl/qp/12.0.0/forms/US/QPXPRLST.fmx
module_type=form compile_all=special

Forms 10.1 (Form Compiler) Version (Production)

Forms 10.1 (Form Compiler): Release - Production

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

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

Form not created

I checked my environment and everything seemed ok. Sqlplus worked fine, etc. A Metalink search turned up Note: 431324.1 Manual forms compilation In R12 fails. Even tho the error isn't the same, it shows that is also affected.

I haven't applied the patch yet because I could still use adadmin to recompile the form. But if I start receiving alot of requests then I will put it in.


JoelEugenio said...

what patch do you need to fix this? same with my fusion middleware. When I compile from an 11g db no problem but it occurs in 10gr2

IHM said...

don't use .sh with FRMCMP_BATCH ...

i also got the same err - but after removing it, the err got resolved ...

jramb said...

This is know issue, please see

Manual forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1]

Anonymous said...

Thanks a lot IHM... was struggling for a couple or hrs but you gave me the ans...

Anonymous said...

Thanks a lot. It worked for me as well.

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.