Saturday, September 12, 2009

Starting/Stopping Apache in Oracle Applications

Oracle Apps Ver: 11i

Execute the following command in Oracle Applications Server (Application Tier),

. $COMMON_TOP/admin/scripts/$TWO_TASK/adapcctl.sh status/stop/start

status- To get the status of the Apache
stop - To stop Apache
start - To start Apache

Any java class files migration, MDS migration (EO, VO XML files etc), OA personalizations migration need Apache bounce in 11i.

Migrating Oracle Form Personalization

In Oracle Apps DB server, do the followings to migrate Oracle Form Personalization between different instances,

Oracle Apps Ver: 11i

Step 1>Run the following command for downloading all the personalization for a perticular form,

$FND_TOP/bin/FNDLOAD "db_userid"/"db_pwd" 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct "filename.ldt" FND_FORM_CUSTOM_RULES form_name="FND_FORM_CUSTOM_RULES.FORM_NAME"

Step 2>Run the following command for uploading all the personalization for the form,

$FND_TOP/bin/FNDLOAD "db_userid"/"db_pwd" 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct "file_name.ldt"