Compile CUSTOM.pll and Oracle FORM

To Compile CUSTOM.pll

PREQUISIT:
1) Set Environment variable
2) Run above command in $AU_TOP/resource

Use below command:
frmcmp_batch module=CUSTOM.pll userid=apps/<pwd> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

----------------------------------------------------

To Compile FORM
Go to path where .fmb is present

Use below command:
frmcmp_batch userid=apps/apps module=<FORM_NAME.fmb> output_file=<FORM_NAME.fmx> module_type=form compile_all=special

or

frmcmp_batch module=<FORM_NAME.fmb> userid=apps/apps output_file=<FORM_NAME.fmx> module_type=form batch=yes compile_all=special

CO code to remove links on OAF page - Like Home,Logout

In PR

OAPageLayoutBean page = pageContext.getPageLayoutBean();
page.prepareForRendering(pageContext);
OAGlobalButtonBarBean buttons =(OAGlobalButtonBarBean)page.getGlobalButtons();
buttons.setRendered(false);

CEMLI performance checker

Concurrent Program:   CEMLI performance checker
Its output is the report containing result based on performance of all the concurrent program with Trace enable (Result is PASS/FAIL).

1. create any (say 5) concurrent program whose performance needs to be checked make it (all)Trace enable
2. Run those concurrent programs one-by-one
3. Now at end run the CEMLI performance checker
4. view the log file, in that log file at end their is an URL where we can find the Performance report of our concurrent programs
5. copy-paste the URL in Browser (We have the required report)

Set FORMS_PATH in putty

applprod@xxo00005:/u02/R12/EBSPRD/fs1/EBSapps/appl/xxcustom_top/12.0.0/forms/US$ export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

Bouncing Appache

This is specially for OAF Developers, who frequently needs to bounce appache / oacore to refresh OAF pages

Set environment variable, use below command in putty
ps -ef | grep tns
Command output will be like
/u02/R12/EBSPRD/fs1/EBSapps/10.1.2/bin/tnslsnr APPS_EBSPRD -inherit

cd /u02/R12/EBSPRD/

 . EBSapps.env run

This would set environment variable

------

In R12.2.X We need to bounce oacore, below commands to be executed from putty,
admanagedsrvctl.sh stop oacore_server1
admanagedsrvctl.sh start oacore_server1
(here we would need Weblogic password)

or we can bounce oacore from front end by login as weblogic user in console
http://<host_name>:7002/console/

Environment-->Servers-->Control-->click on oacore_server1-->Shutdown(Force Shutdown Now)-->ok
Environment-->Servers-->Control-->click on oacore_server1-->Start-->ok

------

In R12.1.X We need to start stop 2 scripts
adapcctl.sh
adoacorectl.sh

search below tops in putty to find above 2 scripts
$APPL_TOP
$CUSTOM_TOP
$ADMIN_SCRIPTS_HOME
$INST_TOP

>adapcctl.sh stop
>adoacorectl.sh stop
>adoacorectl.sh start
>adapcctl.sh start
--------

In 11i we only need to bounce appache
>adapcctl.sh stop
>adapcctl.sh start

Arabic_to_unicode in Java

String to Unicode Converter Sites:
http://www.arabunic.free.fr/
http://snible.org/java2/uni2java.html

Requirement was, if attachment is missing we should show error message
Complication was in Arabic Interface when attachment is missing it has value as "لا شيء " which is ,  "None " in English Interface.

so to store "لا شيء "(directly) in some variable was an issue in Java

Solution was to obtain the unicode for "لا شيء " from the above sites

and then,
String uni = "\u0644\u0627\u0020\u0634\u064A\u0621\u0020"              <-------unicode for "لا شيء"

so now we can use variable "uni" in condition to show error message.

Alert - goes into exception

Alert goes in to exception but the query inside Alert is right also complete Alert setup is correct
then check if Workflow mailer is off, make it ON

System Administrator -> Oracle Applications Manager -> Workflow -> Notification Mailers = 'Up'