R12 Form compilation with error ORA-12154

R12 Form compilation failed with following error.


frmcmp_batch.sh Module=XXXQRMST.fmb Userid=apps/g#apps@GFA
Module_Type=FORM Output_File=$FND_TOP/forms/US/XXXQRMST.fmx Compile_All=YES
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




Solution ->




REPLACE:




TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN


WITH:


TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN
#TWO_TASK=; export TWO_TASK
#ORACLE_SID=< ORACLE SID >; export ORACLE_SID


in the following files:


frmbld.sh
frmcmp.sh
frmcmp_batch.sh
frmplsqlconv.sh
frmplsqlconv.bat