Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Custom Tops Setup in Oracle 11i/R12

  1. #1

    Post Custom Tops Setup in Oracle 11i/R12

    Create Custom TOP in R12
    ============================

    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
    Last edited by Hemant; 01-23-2012 at 01:55 AM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Thanks Kaushal for this excellent post.

+ Reply to Thread

Similar Threads

  1. Transparent Application Failover (TAF) Setup on Client Side for Oracle RAC
    By Hemant in forum RAC Performance,LoadBalancing,TAF,FAN,Troubleshooting
    Replies: 1
    Last Post: 10-22-2012, 07:51 PM
  2. Transparent Application Failover (TAF) setup and testing - Oracle 10g RAC
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 1
    Last Post: 04-24-2012, 05:40 PM
  3. Printer Setup in Oracle Apps 11i / R12
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 02-16-2012, 09:28 PM
  4. Setup auto start and shut of the Oracle database in linux
    By shoaibansari in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 02-14-2012, 07:57 PM
  5. Oracle RAC Services Setup with Load Balancing , TAF and FAN
    By Hemant in forum RAC Performance,LoadBalancing,TAF,FAN,Troubleshooting
    Replies: 0
    Last Post: 12-09-2011, 11:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics