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
