Creating Custom TOP in Oracle EBS R12

This blog demonstrates creation of custom top in EBS R12. Before creating any custom top user    should be aware for certain values such as EBS Database SID, EBS Host name.
For now we are taking some dummy values such as:-

DB SID => EBS_DB_SID
EBS Host name => EBS_HOST_NAME

Note: All the red colored below script command part have to be modified as per your instance.

Step1: Log in to EBS server using putty(any Linux machine) as 'applmgr' user.

Step2: Source the EBS Apps environment variable by moving to the APPL_TOP directory as shown below.

Step3: Create directory structure for your custom application files

                   mkdir $APPL_TOP/xxcll
                   mkdir $APPL_TOP/xxcll/12.0.0
                   mkdir $APPL_TOP/xxcll/12.0.0/admin

                   mkdir $APPL_TOP/xxcll/12.0.0/admin/sql

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

Step4: For adding custom module to the environment execute below command after modifying it accordingly.

                  cat <<EOF >/$APPL_TOP/customEBS_DB_SID'_'EBS_HOST_NAME.env

                  XXCLL_TOP="u01/applmgr/EBS_DB_SID/apps/apps_st/appl/xxcll/12.0.0"
                  export XXCLL_TOP

                  EOF

You can verify the successfull creation of this environment file by moving to APPL_TOP. And view your custom environment file created in above step.
Threre should be a customfile entry in it, which looks like as shown below.


                customfile=/u01/applmgr/EBS_DB_SID/apps/apps_st/appl/customEBS_DB_SID'_'EBS_HOST_NAME.env


Step5: Next step is to modify the context file, entering the path of our custom top. To know the location of context file execute :-

                echo $CONTEXT_FILE

This will give you the location of context file in your EBS instance.
Now move to the context file location and take the backup of the file. Tou can also take the bakup of contextfile by executing:-

                mv $CONTEXT_FILE $CONTEXT_FILE.bkup

Now edit your context file foe adding the details of your custom top. Its houd look like as shown below:

 <XXCLL_TOP oa_var="s_xxclltop" oa_type="PROD_TOP" oa_enabled="FALSE">/u01/applmgr/EBS_DB_SID/apps/apps_st/appl/xxcll/12.0.0</XXCLL_TOP>

After editing save the file.

Step6: In order to make the changes made in contextfile effective we need to run autoconfig file.
Follow the below steps sequentially to run autoconfig file:-

• Move to ADMIN_SCRIPTS_HOME by executing :- 

            cd $ADMIN_SCRIPTS_HOME 

• Stop all the services for the application by executing :- 

           ./adstpall.sh apps/apps 

          If you get any status other than 0 then you have to kill the services manually.

• In same directory you will find adautocfg.sh script which we have to run for autoconfig by executing:-

           sh adautocfg.sh

         It will prompt for apps password.
         It will now configure automatically to application tier. 

• Wait till it shows "Autoconfig Completed successfully"   

• Start all the services by executing:-

         ./adstrtal.sh apps/apps

Step7: To verify that custom top creation is successfull, move to APPL_TOP by executing :-

            cd $APPL_TOP

            And execute :- cd $XXCLL_TOP


EBS setups for Custom TOP:-

Step1: Register Custom Application

Navigation:- System Administrator > Application > Registe



Enter the specific details for Application,Short Name,Basepath, Description and save the record.

                  Application:    XXCLL Custom Application
                  Short Name:    XXCLL
                  Basepath:        XXCLL_TOP
                  Description:    XXCLL Custom Application

 


Step2: Register Oracle User

Navigation:- System Administrator > Security> ORACLE> Register

 

 Enter the specific values and save the record.

                    Database User Name:    XXCLL (Provide Data Base User Name)
                    Password:                      XXCLL (Provide Username Password)
                    Privilege:                       Enabled
                    Install Group:                0
                    Description:                  XXCLL Custom Application User

 


Step3: Creating Custom Data Group 

Navigation:- System Administrator > Security > ORACLE > DataGroup

 

Enter the Data Group Name and Description and Click on "Copy Application From" as shown in below snapshot. A pop up window will open. Select 'Standard' and click on 'ok'.
 




Click on 'New' button at the header of form and add your custom application created above and oracle id as 'APPS' as shown below and save the record.









Please give your feedback on this blog and post.

Happy Coding