HOW TO INTEGRATE APPLICATIONS RELEASE R12 WITH CUSTOM APPLICATIONS

HOW TO INTEGRATE APPLICATIONS RELEASE R12 WITH CUSTOM APPLICATIONS

SCHEMA NAME : xxcxl

TOP NAME : XXCXL_TOP

Application : xxcxl Custom Application

Data Group : Standard

Request Group : xxcxl Request Group

Menu : xxcxl_CUSTOM_MENU

Responsibility : xxcxl Custom

Assumptions:

APPL_TOP: /u01/applmgr/ESTSOA/apps/apps_st/appl

Instance Name: ESTSOA

Server Name: soaebs

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

cd $APPL_TOP

mkdir xxcxl

mkdir xxcxl/12.0.0

mkdir xxcxl/12.0.0/admin

mkdir xxcxl/12.0.0/admin/sql

mkdir xxcxl/12.0.0/admin/odf

mkdir xxcxl/12.0.0/sql

mkdir xxcxl/12.0.0/bin

mkdir xxcxl/12.0.0/reports

mkdir xxcxl/12.0.0/reports/US

mkdir xxcxl/12.0.0/forms

mkdir xxcxl/12.0.0/forms/US

mkdir xxcxl/12.0.0/lib

mkdir xxcxl/12.0.0/out

mkdir xxcxl/12.0.0/log

2) Add the custom module into the environment

cd $APPL_TOP

echo "XXCXL_TOP=/u01/applmgr/ESTSOA/apps/apps_st/appl/xxcxl/12.0.0" >

customESTSOA_soaebs.env

echo "export XXCXL_TOP " >> customESTSOA_soaebs.env

Source the environment file

(/u01/applmgr/ESTSOA/apps/apps_st/appl/APPSESTSOA_soaebs.env )

Make entry to the application context file

vi $INST_TOP/appl/admin/ESTSOA_soaebs.xml

<AU_TOP oa_var="s_autop" oa_type="ESTSOA_TOP"

oa_enabled="FALSE">/u01/applmgr/ESTSOA/apps/apps_st/appl/au/12.0.0</AU_TOP>
like above antry have to give below shown ,
<XXCXL_TOP oa_var="s_xxcxltop" oa_type="ESTSOA_TOP"

oa_enabled="FALSE">/u01/applmgr/ESTSOA/apps/apps_st/appl/xxcxl/12.0.0</XXCXL_T

OP>

cd $INST_TOP/admin/install

sh adgentopfile.sh

3) create tablespace xxcxl datafile '/u01/oracle/ESTSOA/db/apps_st/data/xxcxl01.dbf'

size 500M

4) create user xxcxl identified by xxcxl

default tablespace xxcxl

temporary tablespace temp

quota unlimited on xxcxl;

grant connect, resource to xxcxl;

5) Register your Oracle Schema.

Login to Applications with System Administrator responsibility

Navigate to Application-->Register

Application = xxcxl Custom Application

Short Name = xxcxl

Basepath = XXCXL_TOP

Description = xxcxl Custom Application

6) Register Oracle User

Naviate to Security-->Oracle-->Register

Database User Name = xxcxl

Password = xxcxl

Privilege = Enabled

Install Group = 0

Description = xxcxl Custom Application User

7) Add Application to a Data Group

Navigate to Security-->Oracle-->DataGroup

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

Group = xxcxl Request Group

Application = xxcxl Custom

Code = xxcxl

Description = xxcxl 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 = xxcxl_CUSTOM_MENU

User Menu Name = xxcxl Custom Application

Menu Type =

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

10) Create new responsibility. Navigate to Security-->Responsibility-->Define

Responsibility Name = xxcxl Custom

Application = xxcxl Custom

Responsibility Key = xxcxlCUSTOM

Description = xxcxl Custom Responsibility

Available From = Oracle Applications

Data Group Name = xxcxlGroup

Data Group Application = xxcxl Custom

Menu = xxcxl Custom Application

Request Group Name = xxcxl Request Group

11) Add responsibility to user

Navigate to Security-->User-->Define

Add xxcxl 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 XXCXL_TOP directory appropriate for the type of

object. For example forms would be located in $XXCXL_TOP/forms/US or package

source code in $XXCXL_TOP/admin/sql for example.

Database Objects, such as tables, indexes and sequences should be created in the xxcxl

schema, and then you need to

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

For example : logged in as xxcxl 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 xxcxl.myTable;

13) Login to sysadmin, Application Developer Responsibility

In the backend compile your form

su - applmgr

cd $AU_TOP/forms/US

cp TEMPLATE.fmb DEMO.fmb

frmcmp_batch module=DEMO.fmb userid=apps/apps output_file=

/u01/applmgr/ESTSOA/apps/apps_st/appl/xxcxl/12.0.0/forms/US/DEMO.fmx

compile_all=special batch=yes

Application > Form (Register the form)

Application > Function (Add the form to a function)

Application > Menu (Attach the function to a menu)

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.

cd $ADMIN_SCRIPTS_HOME

sh adstpall.sh apps/apps

sh adautocfg.sh

sh adstrtal.sh apps/apps

cat $APPL_TOP/admin/topfile.txt

XXCXL /u01/applmgr/ESTSOA/apps/apps_st/appl

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

Security > User >

Connect as Username(xxcxl custom responsibility holding user)

>>>Errors and Solution:

Solution

Restart the forms server

cd $ADMIN_SCRIPTS_HOME

sh adstpall.sh apps/apps

sh adstrtal.sh apps/apps