Look Apps

Oracle Applications DBA APPSLab

 
R12
  • CREATE CUSTOM TOP IN R12
  • RELEASE12 INSTALLATION
  • R12.AD.A.DELTA.4 PATCH
  • APPS R12 SCRIPTS & LOG FILE LOCATIONS
  • APPS 11i
  • ENABLING SSL FOR E-BUSINESS SUITE
  • 11I INSTALLATION(11.5.10.2 on Redhat Linux AS 4.0 ...
  • Replacing Jinitiator with Sun Java JRE for APPS
  • INDIAN LOCALIZATION PATCH
  • Database Upgrade 9.2.0.6 to 10.2.0.2.0 Oracle App...
  • Multi Node to Single Node Cloning
  • 10G
  • Installing 10G Application Server
  • 10G DATAPUMP
  • INSTALLING 10G DEVELOPER SUITE ON LINUX MACHINE
  • 9i
  • Apply ADI-6 Patch
  • MANUALLY CLONE DATABASE
  • Copy and Rename an Oracle Database - (without expo...
  • linux/Unix
  • LINUX BASICS
  • Training
    Coming Soon
    Search
    Only search this Blog
    GOOGLE Ads
    Coming Soon
    CREATE CUSTOM TOP IN R12
    Wednesday, July 16, 2008
    CREATE CUSTOM TOP IN R12



    SCHEMA NAME : XXRLT
    TOP NAME : XXRLT_TOP
    Application : XXRLT Custom Application
    Data Group : XXRLTGroup
    Request Group : XXRLT Request Group
    Menu : XXRLT_CUSTOM_MENU
    Responsibility : XXRLT Custom

    1) Make the directory structure for your custom application files.

    cd $APPL_TOP
    mkdir xxrlt
    mkdir xxrlt/12.0.0
    mkdir xxrlt/12.0.0/admin
    mkdir xxrlt/12.0.0/admin/sql
    mkdir xxrlt/12.0.0/admin/odf
    mkdir xxrlt/12.0.0/sql
    mkdir xxrlt/12.0.0/bin
    mkdir xxrlt/12.0.0/reports
    mkdir xxrlt/12.0.0/reports/US
    mkdir xxrlt/12.0.0/forms
    mkdir xxrlt/12.0.0/forms/US
    mkdir xxrlt/12.0.0/lib
    mkdir xxrlt/12.0.0/out
    mkdir xxrlt/12.0.0/log



    2) Add the custom module into the environment

    cd $APPL_TOP

    vi customPROD_app01.env
    XXRLT_TOP=/sandb1/oracle/PROD/apps/apps_st/appl/xxrlt/12.0.0
    export XXRLT_TOP
    source the environment file ( /sandb1/oracle/PROD/apps/apps_st/appl/APPSPROD_pkgprod.env )

    Make entry to context file

    /sandb1/oracle/PROD/inst/apps/PROD_pkgprod/appl/admin/PROD_pkgprod.xml

    /sandb1/oracle/PROD/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 XXRLT datafile '/sandb1/oracle/PROD/db/apps_st/data/xxrlt01.dbf' size 500M

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

    Labels:

    posted by Lokesh Babu @ 2:52 AM  
    0 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Lokesh Babu
    Home: Bangalore, Karnataka, India
    About Me:
    See my complete profile
    Previous Post
    Archives
    Links
    Template by

    Blogger Templates

    BLOGGER