APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 36,440 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    January 2010
    M T W T F S S
    « Sep   Feb »
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
  • Archives

  • Authors

Create Custom TOP in R12

Posted by appsinfo on January 27, 2010

CUSTOM TOP Creation

For customizations you need to create custom top inorder to create all the custom objects and custom menus, responsibilities.

1. Create directory structure in $APPL_TOP

xxxtest/

`– 12.0.0

    |– admin

    |   |– driver

    |   |– odf

    |   |– sql

    |   `– template

    |– bin

    |– forms

    |   `– US

    |– help

    |– html

    |– java

    |– lib

    |– log

    |– mds

    |– media

    |– mesg

    |– out

    |– patch

    |– reports

    |   `– US

    `– sql

 2) Add the custom module into the environment

 cd $APPL_TOP

 vi customtest_appsvis1.env

XXRLT_TOP=/sandb1/oracle/TEST/apps/apps_st/appl/xxrlt/12.0.0

export XXRLT_TOP

source the environment file ( /sandb1/oracle/TEST/apps/apps_st/appl/APPSTEST_pkgtest.env )

 Make entry to context file

 /sandb1/oracle/TEST/inst/apps/TEST_pkgtest/appl/admin/TEST_pkgtest.xml

 /sandb1/oracle/TEST/apps/apps_st/appl/xxrlt/12.0.0

 cd $INST_TOP/admin/install

sh adgentopfile.sh

 Open new session, source environment file, and stop middle tier services, run autoconfig

Open new session, source environment file, check for custom top in topfile.txt in $APPL_TOP/admin, start the middle tier services.

 3) Create Tablespace

  create tablespace XXRLT datafile ‘/sandb1/oracle/TEST/db/apps_st/data/xxrlt01.dbf’ size 500M

 4) Create USER

  create user xxrlt identified by xxrlt

default tablespace xxrlt

temporary tablespace temp1

quota unlimited on xxrlt

grant connect, resource to xxrlt;

 5) Register your Oracle Schema

 Login to Applications with System Administrator responsibility

Navigate to Application–>Register

Application = XXRLT Custom Application

Short Name = XXRLT

Basepath = XXRLT_TOP

Description = XXRLT Custom Application

 6) Register Oracle User

 Naviate to Security–>Oracle–>Register

Database User Name = XXRLT

Password = XXRLT

Privilege = Enabled

Install Group = 0

Description = XXRLT Custom Application User

 7) Add Application to a Data Group

 Navigate to Security–>Oracle–>DataGroup

Data Group = XXRLTGroup

Description = XXRLT Custom Data Group

Click on “Copy Applications from” and pick Standard data Group, then add the following entry.

Application = XXRLT Custom

Oracle ID = APPS

Description = XXRLT Custom Application

 8) 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

Group = XXRLT Request Group

Application = XXRLT Custom

Code = XXRLT

Description = XXRLT Custom Requests

We will not define any requests to add to the group at this stage, but you can add some now if required.

 9) 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 = XXRLT_CUSTOM_MENU

User Menu Name = XXRLT Custom Application

Menu Type =

Description = XXRLT 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

 Menu = XXRLT_CUSTOM_MENU_SSWA

User Menu Name = XXRLT Custom Application SSWA

Menu Type =

Description = XXRLT Custom Application Menu for SSWA

 10) Create new responsibility. One for Core Applications and One for Self Service (SSWA)

 Navigate to Security–>Responsibility–>Define

Responsibility Name = XXRLT Custom

Application = XXRLT Custom

Responsibility Key = XXRLTCUSTOM

Description = XXRLT Custom Responsibility

Available From = Oracle Applications

Data Group Name = XXRLTGroup

Data Group Application = XXRLT Custom

Menu = XXRLT Custom Application

Request Group Name = XXRLT Request Group

 Responsibility Name = XXRLT Custom SSWA

Application = XXRLT Custom

Responsibility Key = XXRLTCUSTOMSSWA

Description = XXRLT Custom Responsibility SSWA

Available From = Oracle Self Service Web Applications

Data Group Name = XXRLTGroup

Data Group Application = XXRLT Custom

Menu = XXRLT Custom Application SSWA

Request Group Name = XXRLT Request Group

 11) Add responsibility to user

 Navigate to Security–>User–>Define

Add XXRLT Custom responsibility to users as required.

 12) Other considerations

 You are now ready to create your database Objects, custom Reports, Forms, Packages, etc

 Create the source code files in the XXRLT_TOP directory appropriate for the type of object. For example forms would be located in $XXRLT_TOP/forms/US or

 package source code in $XXRLT_TOP/admin/sql for example.

 Database Objects, such as tables, indexes and sequences should be created in the XXRLT schema, and then you need to

a) Grant all privilege from each custom data object to the APPS schema.

For example : logged in as XXRLT user

grant all privileges on myTable to apps;

 b) Create a synonym in APPS for each custom data object

For example : logged in as APPS user

create synonym myTable for XXRLT.myTable;

 13) Login to sysadmin, Application Developer Responsibility

 Application > Form ( Register the form )

Application > Funtion ( Add the form to a function )

Application > Menu ( Attach the function to a menu )

 Menu that is added to a particular responsbility is given to specific user

Security > User > Define

Advertisements

4 Responses to “Create Custom TOP in R12”

  1. Jaqueline said

    Excellent site you have here.. It’s difficult to find good quality writing like yours these days. I honestly appreciate people like you! Take care!!

  2. mark said

    Thanks for finally talking about >Create Custom TOP
    in R12 Oracle DBA’s Group <Loved it!

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: