Hi Guys,
I just did a creation of a new custom top so follows below how to do it.
Usually we have two options to do it, one it's manually (not recommended once custom patches won't work) or second using adsplice that it's better option.
First of all we need 3 files:
- newprods.txt <-- that is our control file (not db control file).
- <xxtop>prod.txt
- <xxtop>terr.txt
in the End of this topic you can find script example.
Change <xxtop> for the respective value on those three files, in my case is xxnfe.
Then move those three files for $APPL_TOP/ or $APPL_TOP/admin
Go to the directory where newprods.txt (control file) it's present and run adsplice, answer prompts and it's done.
Ps.: It's necessary to define a tablespace and user that already exist, if does not exist create it before run adsplice, it's not necessary to create directory manually, adsplice create it, make sure to give connect,resource and tablespace quota or unlimited tablespace for respective user.
Find scripts example below:
newprods.txt:
%%% Splicer control file format 12.0.A
# $Header: newprods.txt 120.1 2012/06/25 12:00:00 mzambonini noship $
# +=======================================================================+
# Copyright (c) 2012 ITConvergence
# All Rights Reserved
# +=======================================================================+
# | FILENAME |
# | newprods.txt |
# | |
# | DESCRIPTION |
# | Common product description file. |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | This file is changed with each release. |
# | HISTORY |
# | 25-JUN-2012 mzambonini created |
# | |
# +=======================================================================+
#
product=xxnfe
base_product_top=*APPL_TOP*
oracle_schema=xxnfe
sizing_factor=100
main_tspace=APPS_TS_TX_DATA
index_tspace=APPS_TS_TX_IDX
temp_tspace=TEMP1
default_tspace=APPS_TS_TX_DATA
# end
xxnfeprod.txt
# $Header: xxnfeprod.txt 120.1 2012/06/25 12:00:00 mzambonini noship $
# +=======================================================================+
# Copyright (c) 2012 ITConvergence
# All Rights Reserved
# +=======================================================================+
# | FILENAME |
# | xxnfeprod.txt |
# | |
# | DESCRIPTION |
# | Common product description file. |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | This file is changed with each release. |
# | HISTORY |
# | 25-JUN-2012 mzambonini created |
# | |
# +=======================================================================+
#
# ##################################################
# file format id (should begin with "%%%")
# ##################################################
%%% Single-product product data file format 12.0.A
#
# ##################################################
# LIST OF PRODUCT ABBREVIATIONS and the corresponding application ids.
# This list lets you forward-reference the abbreviations of shared products.
# This list should match the official correspondence between id and
# abbreviation, given for each product in the Product List.
# ##################################################
#
# Product specific Product ID's
xxnfe 368
END_OF_PRODUCT_ABBREVIATIONS -999
#
# ##################################################
# Oracle Support Diagnostic Tools
# ##################################################
#
# application id, abbreviation, shortname, prefix
368 xxnfe XXNFE APP
# multiple product installations for msob, "controlled release", shared only
# optional fourth field is "stub product". default is No
No No No No
# multilingual, has NLADD.sql
Yes Yes
# install oracle id, default ORACLE username, default ORACLE password
368 XXNFE <password_case_sensitive>
# concurrent conflict set id (logical database id)
0
# minimum version you can upgrade from, for shared and for fully-installed
12.0.0 12.0.0
# shared products
# FND, AK, AX and AZ are required for this section
# For example:
# fnd ak ax az gl inv po ap fa ar oe as per pay mfg bom eng mrp crp wip pa
# If you list a product in the set-to-install or required-as-installed
# sections below, you MUST also list the product as a shared product
# fnd ak ax az
none
# product libraries needed for "make -f <product>.mk all"
# For example: fnd alr gl rg
none
# when install this product, set these other products to install
# This is the set-to-install section
# AK, AX and AZ are required for this section
# For example: ak ax az rg
# This section must exactly match the required-as-installed section
# ak ax az
none
# requires that these other products are fully installed or installing
# This is the required-as-installed section
# AK, AX and AZ are required for this section
# For example: ak ax az rg
# This section must exactly match the set-to-install section
# ak ax az
none
#
# ##################################################
# END OF PRODUCT LIST
# ##################################################
#
END_OF_PRODUCTS
#
# ##################################################
# START OF RELEASE LIST
# ##################################################
# For each release, the products should be listed in install/upgrade order.
# FND should always be listed first in the release.
#
# The first release listed should be the lowest release
# we support upgrading from (e.g. release 10.5.0 for MPL 10)
# AutoInstall will stop if a product version is lower than the lowest release.
# AutoInstall will assume that if a product version is at the lowest release,
# then it can be upgraded to the current release.
#
#
# ##################################################
# Release 12.0.0
# ##################################################
#
# release name, for use by AutoInstall only
Release 12.0.0
# release version, for FND_PRODUCT_GROUPS and the \ Help Version feature.
# this value should not contain any English.
12.0.0
# release abbreviation, rename prefix, release type
R120 R120_ additional-this-mpl
# list of products and versions
XXNFE 12.0.0
END_OF_RELEASE 0.0.0
#
#
# #################################################################
# end of xxnfeprod.txt file
# #################################################################
#
xxnfeterr.txt
# $Header: xxnfeterr.txt 120.1 2012/06/25 12:00:00 mzambonini noship $
# +=======================================================================+
# Copyright (c) 2012 ITConvergence
# All Rights Reserved
# +=======================================================================+
# | FILENAME |
# | xxnfeterr.txt |
# | |
# | DESCRIPTION |
# | Common product description file. |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | This file is changed with each release. |
# | |
# | HISTORY |
# | 25-JUN-2012 mzambonini created |
# | |
# +=======================================================================+
#
%%% Single-product territory data file format 12.0.A
#
# Release abbreviation
# 10.7 - R1107, 11.0 = R11.0.28, 11.5 = R115
R120
#
# ###############################################################
# LIST OF LANGUAGE INFO
# ###############################################################
#
# See applterr.txt for more info on what the fields for a language mean
#
# You should specify the product's name in American English
#
# You do not need to include records for other languages unless you need to
# specify the product's name in other languages
#
# ############################
#
# language id, shortname, codes and names
0 usaeng US AMERICAN EN US American_English
# appltape filename, appltape filename for loc. products, codeset
appltape.txt appltape.txt WE8ISO8859P1
# signon translated, standard dg name, other dg prefix
Yes Standard Data_Group
# products that have dnls.drv files
none
# products that have bnls.drv files
none
# products that have fnls.drv files
none
# products that have GV dnls.drv files
none
# products that have GV fnls.drv files
none
# product names in this language
c xxnfe XXNFE_Custom_application_Server
END_OF_PRODUCT_NAMES
#
# You may specify info for other languages here, but usually you will
# not need to do this.
#
END_OF_LANGUAGE_INFO
#
# #################################################################
# end of xxnfeterr.txt file
# #################################################################
No comments:
Post a Comment