Wednesday

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 frmcmp_batch.sh. For details see Note: 130686.1.

However, when I executed frmcmp_batch.sh I received an error:


[applmgr@myserver VIS]$ frmcmp_batch.sh 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 10.1.2.0.2 (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.0.2 - 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



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 frmcmp_batch.sh 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.

6 comments:

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

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.