Custom Top Creation in 11.5.0

• Log into your unix box as applmgr and create directory under appl_top for example: test
• Create another directory under test as 11.5.0 (location of test_top )
• Create directories
  mkdir -p media forms reports sql log bin admin lib java mesg patch out html jar
• Change your directory location to test_top/forms and create US directory
• Similarly change your directory location to test_top/reports and create US directory
• create sql and odf directories under test_top/admin
• Then after create customTEST.env in /apps/applmgr/visappl/
• Edit customTEST.env
• TEST_TOP=/apps/applmgr/visappl/test/11.5.0/
  export TEST_TOP
  save and quit
• log into your database and create tablespace for your custom top
  For example:
  create tablespace test datafile '/apps/oracle/visdata/testdb01.dbf' size 20
  0m;
• create a user called test
  For example:create user test identified by welcome;
• grant privileges
  For example: grant connect, resource to test;
• for the user created assign a default tablespace
  For example: alter user test default tablespace test;
• Login to ur EBS with sys administrator privs..
• Navigate application- register---
  Application ---custom application
  Short name---test
  Basepath---test_topDescription---custom application
• Navigate security—oracle—register—
  Database user---test
  Password—welcome
  Privilege—enabled
  Install group—0Description—custom application user
• Navigate security—oracle—data group
  Data group—custom group
  Description—custom application data group
  Click on copy application form and select standard data group
  Now add your custom top application:
  Application—custom application
  Oracle ID--appsDescription—custom application test group
• Navigate to security—responsibility—request
  Group--custom apppl request group
  Application—custom application
  Code—customDescription—custom application data group
• Navigate application—Menu
  Menu—custom_menu
  User menu name—custom application user
  Menu type—leave blank
  Description—custom application custom menu
  Seq-10
  Prompt—run requests
  Sub menu—leave blank
  Function—requests:submit
  Description—submit requests
  Seq-20
  Prompt—view requests
  Sub menu—leave blank
  Function—view all concurrent requestsDescription—view requests
• Navigate security—responsibility—define
  Responsibility name—custom application
  Application—custom application
  Responsibility key—customapplication
  Description—custom application responsibility
  Available from—oracle applications
  Data group
  Name--custom group
  Application—custom application
  Request group
  Name—custom appl request group
  Application—custom applicationMenu—custom application user
• Navigate security—user—define
  User—test
  Password-welcome
  Description—custom application user Add custom application responsibility to this user test

Clearing JSP pages in R12

• While clearing all _pages in ($INST_TOP/_pages) and restart apache, we'll get a blank page since appsLocalLogin.jsp cannot be compiled automatically in R12.
• This is can be done by making changes in the appsLocalLogin.jsp file.
• Just change "justrun" to "recompile"
• Location of appsLocalLogin.jsp in R12 is $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml
• Restart middle tier services.

How to Compile Forms in R12

compile a single form manually:
frmcmp_batch module=$au_top/forms/US/testform.fmb userid=apps/apps output_file=$test_top/forms/US/testform.fmx module_type=form compile_all=special

Note: Here we are compiling a form so we specify module_type=form, if it is a library file like .pll file we specify module_type=library

compile all forms and all library files:

• log in as applmgr
• source environment file
• run adadmin
• select Generate application files menu and
• Generate form files