Custom Top - 2

Custom Top in Oracle Application - Creation & Registering

Kindly follow the previous post

STEP 11

Register your Oracle Schema

Login to Applications with System Administrator responsibility
Navigate to
Application–>Register

STEP 12

Register Oracle User

Naviate to
Security-->Oracle-->Register

STEP 13

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

STEP 14

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-->responsbility-->Request

STEP 15

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

STEP 16

This is the CUSTOM_TOP we created in the above 15 steps.







All the best Flocks...

Custom Top - 1

Custom Top in Oracle Application - Creation & Registering

STEP 1

Created the directory structure for your custom application files under $APPL_TOP/abdul

$cd $APPL_TOP

$ mkdir abdul

$ mkdir abdul/11.5.0

$ mkdir abdul/11.5.0/admin

$ mkdir abdul/11.5.0/admin/sql

$ mkdir abdul/11.5.0/admin/odf

$ mkdir abdul/11.5.0/sql

$ mkdir abdul/11.5.0/bin

$ mkdir abdul/11.5.0/reports

$ mkdir abdul/11.5.0/reports/US

$ mkdir abdul/11.5.0/forms

$ mkdir abdul/11.5.0/forms/US

$ mkdir abdul/11.5.0/log

$ mkdir abdul/11.5.0/out

$ mkdir abdul/11.5.0/$APPLLIB

$ mkdir abdul/11.5.0/$APPLOUT

STEP 2

Added entry ABDUL_TOP=/ebiz/testappl/testappl/abdul in Enviornment file custom_TEST_vmware.env

ABDUL_TOP=/ebiz/testappl/testappl/abdul

export ABDUL_TOP

STEP 3

Then Run "custom_TEST_vmware.env",

./custom_TEST_vmware.env

STEP 4

Then Run "APPSORA.env"

./APPSORA.env

STEP 5

Finally Run the Oracle Manager's bash profile,

.bash_profile

STEP 6

Now Check for "ABDUL" top

$cd $ABDUL_TOP

$pwd

/ebiz/testappl/testappl/abdul

STEP 7

Create datafile (.dbf) from the new customized top in database

Connect to database manager

connect into sys user.

create tablespace and datafile for ABDUL_TOP

STEP 8

SQL> create tablespace abdul datafile '/ebiz/testora/testdata/abduldbf' size 10M;

Tablespace created.

STEP 9

Create Schema (USER) and Grant connect,resource to the USER.

SQL> create user abdul identified by abdul default tablespace abdul temporary tablespace temp quota unlimited on abdul;

User created.

STEP 10

SQL> grant connect,resource to abdul;

Grant succeeded.