Wednesday, February 17, 2016

Form compilation in oracle apps 11i and R12


Login to the Application server as applmgr and run .env file to set the applications environment

Oracle Application version


Oracle Application Version
Unix
Location
11.5.X
f60gen
/u02/app/erp11i/8.0.6/bin
12.X
frmcmp_batch
/u01/app/erpr12/test/apps/tech_st/10.1.2/bin

TO Generate a Form

Command line is:

<forms executable> module=<source form name> userid=APPS/<APPS password>
output_file=<executable form name> module_type=form batch=yes compile_all=special 


HOW TO Generate a Form in 11i

Change directory to $AU_TOP/forms/US

f60gen module=XXEXAMPLE.fmb userid=apps/(appspwd) module_type=form batch=no compile_all=special output_file=$ XXEXAMPLE _TOP/forms/US/ XXEXAMPLE.fmx

HOW TO Generate a Form in R12
$ORACLE_HOME/bin/frmcmp_batch module=$ XXEXAMPLE _TOP/forms/US/ XXEXAMPLE.fmb userid=apps/(appspwd) output_file=$ XXEXAMPLE _TOP/forms/US/ XXEXAMPLE.fmx module_type=form compile_all=special




Generate a Library

Command line is:

<forms executable>  <library name>  <APPS/<APPS password>
module_type =library  compile_all=special

HOW TO Generate a Library in 11i:

f60gen module=EXAMPLE.pll userid=apps/(appspwd) module_type=LIBRARY batch=NO compile_all=special output_file=$AU_TOP/resource/EXAMPLE.plx

HOW TO Generate a Library in R12:

$ORACLE_HOME/bin/frmcmp_batch module_type=LIBRARY module=$AU_TOP/resource/EXAMPLE.pll userid=apps/(appspwd)output_file=$AU_TOP/resource/EXAMPLE.plx compile_all=special

Friday, February 5, 2016

Oracle Apps r12 (EBS) Login page blank

1. Removed any lock files in these directories - while everything was down - $INST_TOP/admin/scripts/adstpall.sh - to bring it all down.

$INST_TOP/ora/10.1.3/j2ee/oacore/persistence/oacore_default_group_1
$INST_TOP/ora/10.1.3/j2ee/oafm/persistence/oafm_default_group_1 and
$INST_TOP/ora/10.1.3/j2ee/forms/persistence/forms_default_group_1

File example that was removed:  scheduler_notifications.lock
rm *.lock
I use that.

2. Next, ran $INST_TOP/admin/scripts/adautocfg.sh

3. Finally I ran this to compile

$FND_TOP/patch/115/bin/ojspCompile.pl --flush --compile -p 2



4. Brought it all back up using $INST_TOP/admin/scripts/adstrtal.sh

It was all working again as normal.