frmcmp.sh frmcmp_batch.sh FRM-91500: Unable to start/complete the build ORA-12154
                                                 Last update (2012-06-18 21:40:50)
                                                                                                                   Date added (2012-06-18 19:53:07)

Summary
I am trying to compile form FAXSUSTL.fmb due to error:
APP-OFA-48289 Unknown Error When Saving Data In System Controls Form FAXSUSTL. [ID 966382.1]

Navigate to Setup - Asset System - System Controls

When i try to save data at "System Controls" form FAXSUSTL, the following error occurs:
APP-OFA-48289 Unknown error

Solution: I have to compile form FAXSUSTL.fmb. The system is EBS R12.1.3

HOW TO COMPILE THE FORM:

Using frmcmp.sh or frmcmp_batch.sh when trying to compile the form i get the error:

FRM-91500: Unable to start/complete the build
or the error:
ORA-12154: TNS:could not resolve the connect identifier specified

For this problem the Oracle Support reports:
R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1] Applied for 10.1.2.3 : Patch 8528194 - SCRIPT CHANGES FROM 5456500 NOT INCLUDED IN 10.1.2.3
BUT STILL did not solved the problem of : ORA-12154: TNS:could not resolve the connect identifier specified

Workaround: Create the tnsnames alias myself.

0. open xterm
1. source the appsTier environment
export FORMS_PATH=$AU_TOP/resource:$AU_TOP/resource/stub:$AU_TOP/forms/US
export ORACLE_HOME=/u01/clone/apps/tech_st/10.1.2
2. export TNS_ADMIN=$ORACLE_HOME/network/admin
3. Create tnsnames.ora alias 
   cd $TNS_ADMIN
   cp tnsnames.ora tnsnames.ora.old
   vi tnsnames.ora
   add DB alias to tnsnames.ora

   CLONE=
        (DESCRIPTION= 
                (ADDRESS=(PROTOCOL=tcp)(HOST=ebs6.localdomain)(PORT=1571))
            (CONNECT_DATA=
                (SERVICE_NAME=CLONE)
                (INSTANCE_NAME=CLONE)
            )
        )

test database alias:
$ tnsping CLONE

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 18-JUN-2012 19:18:00

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ebs6.localdomain)
(PORT=1571)) (CONNECT_DATA= (SERVICE_NAME=CLONE) (INSTANCE_NAME=CLONE)))
OK (40 msec)
4. Compile the form
cd /u01/clone/apps/tech_st/10.1.2/bin

frmcmp.sh module=/u01/clone/apps/apps_st/appl/au/12.0.0/forms/US/FAXSUSTL.fmb userid=APPS/APPS@CLONE output_file=/u01/clone/apps/apps_st/appl/fa/12.0.0/forms/US/FAXSUSTL.fmx module_type=form compile_all=special
Reviews
Filters
Search