Introduction:
It is possible to create custom tops in Oracle
applications as per client business requirement. Its name starts with “XX<name>”.
Eg:
XXCUSTOM
Reference
oracle Note id: Creating a Custom Application in Oracle E-Business Suite
Release 12.2 (Doc ID 1577707.1)
Section
1: Create A Custom Application Using adsplice
1.
Download Patch 3636980
2.
Manually copy the 3 .txt files from the 3636980\izu\admin directory to
$APPL_TOP/admin directory:
3. Rename to xxcustom<>.txt and also entries (schema name,tablespace
name,temp tablespace name etc.,) in the files.
xxcustomprod.txt
xxcustomterr.txt
newprods.txt
4.
Run adsplice from $APPL_TOP/admin directory
adsplice
5.
Give appropriate paths, names etc., to run adsplice without any errors.
Section
2: Verify Creation of Custom Product in the Database
1.
Log in to SQL*Plus as APPS, and run the following SQL to confirm that the
fnd_application table has one row:
SQL>select
* from fnd_application where application_short_name = 'XXCUSTOM';
This
statement should return one row only.
2.
Run the following SQL to check the product installations table has one row for
your custom product:
Note:
Application id value should be greater than 50,000
SQL>select
* from fnd_product_installations where APPLICATION_ID = 50201;
This
statement should return one row only.
3.
Run the following SQL to check the database user:
SQL>select
* from dba_users where username = 'XXCUSTOM';
This
statement should return one row only.
4.To
ensure the new environment file is picked up, log out and back in again as
applmgr, then run the following command to confirm the $XXCUSTOM_TOP variable
is correctly set:
$
env | grep XXCUSTOM
5.
Run the following command to check the file system has been created correctly.
You should see a directory listing returned as shown:
$
ls $XXCUSTOM_TOP
admin
log mesg out sql
Section
3: Perform Required Steps on Application Tier Nodes
1.
For shared APPL_TOP installations, simply run AutoConfig for the remaining
nodes (there is no need to rerun AD Splice). Otherwise perform section 1 steps
(re-run adsplice)
2.
Restart the application tier services.
Section
4: Create Custom Objects.
1.
You can now create any custom objects required.
In
the $XXCUSTOM_TOP directory, create source code files appropriate to the type
of object. For example, forms would be located in $XXCUSTOM_TOP/forms/US, and
package source code in $XXCUSTOM_TOP/admin/sql.
2.
You may also want to create custom request group, responsibilities, menus, etc.
that your users require to access your custom objects.
Note:
Above steps will take care by technical team.
3.
Database objects such as tables, indexes, and sequences should be created in
the XXCUSTOM schema. You then need to:
Grant
all privilege from each custom data object to the APPS schema.
For
example, logged in as the XXCUSTOM user:
SQL>grant
all privileges on xxcustom_invoices to apps;
Create
a synonym in APPS for each custom data object.
For
example, logged in as the APPS user:
SQL>create
synonym xxcustom_invoices for XXCUSTOM.xxcustom_invoices;
Section
5: Propagate Changes to Other File System
1.
Run adop phase=fs_clone to synchronize both file systems (XXCUSTOM directory
will also create in PATCH file system).Otherwise run adsplice again from PATCH
$APPL_TOP/admin to copy 3 .txt files
Section
6: Post Steps
1.
Check XXCUSTOM entry in $CONTEXT_FILE.If not present add it and run autoconfig.
vi
$CONTEXT_FILE (take backup of original xml file and edit it)
<XXCUSTOM_TOP
oa_var=”s_xxcustomtop” oa_type=”PROD_TOP” oa_enabled=”FALSE” >
/u01/oracle/R12.2/fs1/EBSapps/appl/XXCUSTOM/12.0.0</XXCUSTOM_TOP>
2.
Add below details at Application Level
·
Sysadmin à application àregister
Application:
xxcustom custom application
Short
Name: XXCUSTOM
Base
Path: XXCUSTOM_TOP
Description:
xxcustom custom application
·
Sysadmin à security à oracle à register
Database
User Name: XXCUSTOM
Password:
xxxx
Privilege:
Enabled
Install
Group: 0
Description:
xxcustom custom application account
·
Sysadmin --> security --> oracle --> datagroup
Data
Group: Standard
Description:
Standard Data Group
Application:
xxcustom custom application
Oracle
ID: APPS
Note:
Application value should be same name provided at Sysadmin --> application
--> register --> Application
·
Navigation: Application Developer --> Application
--> Register
Application:
xxcustom custom application
Short
Name: XXCUSTOM
Base
Path: XXCUSTOM_TOP
Description:
xxcustom custom application
No comments:
Post a Comment