Custom Top/Application Creation R12   8 comments

SCHEMA NAME : XXERP
TOP NAME : XXERP_TOP
Application : XXERP Custom Application
Data Group : Standard
Request Group : XXERP Request Group
Menu : XXERP_CUSTOM_MENU
Responsibility : XXERP Custom

 

Step-1
Create a Tablespace in the backened Database for custom schema.
create tablespace XXERP datafile ‘/d01/oracle/PROD/db/apps_st/data/XXERP01.dbf’
size 50M;
Step-2
Create Schema
create user XXERP identified by XXERP default tablespace XXERP temporary tablespace temp quota unlimited on XXERP;

Step-3

Grants Connect and Resource to schema

grant connect, resource to XXERP;
Step-4
Make the directory structure for your custom application files.
cd $APPL_TOP
mkdir XXERP
mkdir -p XXERP/12.0.0
mkdir -p XXERP/12.0.0/admin
mkdir -p XXERP/12.0.0/admin/sql
mkdir -p XXERP/12.0.0/admin/odf
mkdir -p XXERP/12.0.0/sql
mkdir -p XXERP/12.0.0/bin
mkdir -p XXERP/12.0.0/reports
mkdir -p XXERP/12.0.0/reports/US
mkdir -p XXERP/12.0.0/forms
mkdir -p XXERP/12.0.0/forms/US
mkdir -p XXERP/12.0.0/lib
mkdir -p XXERP/12.0.0/out
mkdir -p XXERP/12.0.0/log

Step-5
Create Custom Environment file in APPL_TOP directory

 

1

 

Step-6
Edit customPROD_idba22.env file

2

 

3

 

export XXERP_TOP=/d01/oracle/PROD/apps/apps_st/appl/XXERP/12.0.0

 

Step-7

4

 

5

 

go to last line and add
XXERP_TOP=/d01/oracle/PROD/apps/apps_st/appl/XXERP/12.0.0

6

 

Step-8
Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application–>Register
Application = XXERP Custom Application
Short Name = XXERP
Basepath = XXERP_TOP
Description = XXERP Custom Application

7

 

Step-9
Register Oracle User
Naviate to Security–>Oracle–>Register
Database User Name = XXERP
Password = XXERP
Privilege = Enabled
Install Group = 0
Description = XXERP Custom Application User

8

 

Step-10
Add Application to a Data Group
Navigate to Security–>Oracle–>DataGroup

9

 

Step-11
Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the
Custom Responsibility (which is defined at a later stage)
Navigate to Security–>responsibility–>Request
Group = XXERP Request Group
Application = XXERP Custom
Code = XXERP
Description = XXERP Custom Requests
We will not define any requests to add to the group at this stage, but you can add some now if required.

 

10

 

Step-12
Create custom menu
This will act as a placeholder for any menu items we wish to make available for the
Custom Responsibility (which is defined at a later stage). We will create two menus, one
for Core Applications and one for Self Service.
Navigate to Application–>Menu
Menu = XXERP_CUSTOM_MENU
User Menu Name = XXERP Custom Application
Menu Type =
Description = XXERP Custom Application Menu
Seq = 100
Prompt = View Requests
Submenu =
Function = View All Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Submenu =
Function = Requests: Submit
Description = Submit Requests

11

Step-13
Create new responsibility. Navigate to Security–>Responsibility–>Define
Responsibility Name = XXERP Custom
Application = XXERP Custom
Responsibility Key = XXERPCUSTOM
Description = XXERP Custom Responsibility
Available From = Oracle Applications
Data Group Name = XXERPGroup
Data Group Application = XXERP Custom
Menu = XXERP Custom Application
Request Group Name = XXERP Request Group

12

Step-14
Add responsibility to user
Navigate to Security–>User–>Define
Add XXERP Custom responsibility to users as required.

13

Step-15
As we have edited default.env we need to bounce the opmn.

cd $ADMIN_SCRIPTS_HOME
sh adopmnctl.sh stopall

Rest the Application ENvironment and start OPMN
sh adopmnctl.sh startall

 

14

 

 

Posted October 30, 2013 by balaoracledba.com in OracleAppsR12

8 responses to “Custom Top/Application Creation R12

Subscribe to comments with RSS.

  1. Hi is this applicable to r12.2 version?

  2. Pingback: How to create CustomTop in R12.2 | OracleAPPSDBA & Oracle DBA Blog

  3. Hi Bala,

    We all thank you for sharing your experience/post.

    How to create Custom Top in 12.2.x env, Can you assist here?

  4. Hi,

    No need to add custom entry in context file? also no need to run autocinfig for the above procedure?

    Please let me know

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: