STEP1:
Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support.
STEP2:
-rw-r--r--. 1 applerp dba 13049 Jun 20 21:16 p3636980_R12_GENERIC (1).zip
-bash-4.1$ unzip *
Archive: p3636980_R12_GENERIC (1).zip
inflating: 3636980/README.html
inflating: 3636980/README.txt
inflating: 3636980/patch_metadata.xml
inflating: 3636980/u3636980.drv
inflating: 3636980/f3636980.ldt
inflating: 3636980/izu/patch/115/manualsteps/izu_splice_extra.xml
inflating: 3636980/izu/patch/115/manualsteps/izu_splice_tasks.xml
inflating: 3636980/izu/admin/izuprod.txt
inflating: 3636980/izu/admin/izuterr.txt
inflating: 3636980/izu/admin/newprods.txt
inflating: 3636980/izu/admin/driver/izufile.drv
extracting: 3636980/marker1.txt
inflating: 3636980/b3636980.ldt
Step4:
Open newprods.txt in a text editor.
Change from below
%%% Splicer control file format 12.0.A
#
# $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $
#
#
# Section for Oracle Support Diagnostic Tools
from
%%% Splicer control file format 12.0.A
#
# $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $
#
#
# Section for Oracle Support Diagnostic Tools
product=izu
base_product_top=*APPL_TOP*
oracle_schema=izu
sizing_factor=100
main_tspace=USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace=USER_DATA
to
# end of Oracle Support Diagnostic Tools
product=XXTOP
base_product_top=*APPL_TOP*
oracle_schema=xxtop
sizing_factor=100
main_tspace=USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace=USER_DATA
# end of Oracle Support Diagnostic Tools
Step5:
open xxerpprod.txt and change the references from izu to xxerp
Please use below sql for finding whether custom application id 50000 is availble or not
select decode(count ,0, 'Selected number is available', 'Selected number is already in use') Status, &&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id= &&enter_custom_applID
)
);
STATUS SELECTED_NUMBER
--------------------------------- ---------------
Selected number is avalible 50080
step 7:
open xxtopterr.txt and change the references from izu to xxtop
-bash-4.1$ cat xxtopterr.txt
# +=======================================================================+
# | Copyright (c) 1994 Oracle Corporation Redwood Shores, CA USA |
# | All rights reserved. |
# +=======================================================================+
# | FILENAME |
# | izuterr.txt |
# | $Header: izuterr.txt 120.1 2006/09/20 15:54:52 jaobrien noship $
# | |
# | DESCRIPTION |
# | Appliation Autopatch territory description file for now |
# | it only contains a list of possible languages |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | HISTORY |
# | kkhokhar 05/18/04 Created |
# | mcasalgr 12-sep-05 internal revision |
# +=======================================================================+
#
%%% 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 xxtop top_custom_top
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 izuterr.txt file
# #################################################################
Step9:
Copy the following text files to the $APPL_TOP/admin directory:
xxtopprod.txt
xxtopterr.txt
newprods.txt
Change the current working directory to $APPL_TOP/admin
cd $APPL_TOP/admin
Step10:Run adsplice
-bash-4.1$ adsplice
Copyright (c) 2002, 2012 Oracle Corporation
Redwood Shores, California, USA
AD Splicer
Version 12.2.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Your default directory is '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Splicer records your AD Splicer session in a text file
you specify. Enter your AD Splicer log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adsplice.log] :
************* Start of AD Splicer session *************
AD Splicer version: 12.2.0
AD Splicer started at: Thu Jun 21 2018 21:47:41
APPL_TOP is set to /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl
Change DB = YES.
Backing up restart files, if any......Done.
Your previous AD Splicer session did not run to completion.
Do you wish to continue with your previous AD Splicer session [Yes] ? no
You chose to disregard your previous AD Splicer session
and to restart AD Splicer from the beginning.
Enter Yes to confirm that you wish to overwrite your previous
AD Splicer session and begin a new AD Splicer session.
Enter No to continue with your previous AD Splicer session. [No] : yes
Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [ERPVIS] : ERPVIS *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have or want to install files used for installing or upgrading
the database in this APPL_TOP [YES] ? YES *
Do you currently have or want to install Java and HTML files for HTML-based
functionality in this APPL_TOP [YES] ? YES *
Do you currently have or want to install Oracle E-Business Suite forms files
in this APPL_TOP [YES] ? YES *
Do you currently have or want to install concurrent program files
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [AT_erp] : AT_erp *
You are about to install or upgrade Oracle E-Business Suite product tables
in your ORACLE database 'ERPVIS'
using ORACLE executables in '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/10.1.2'.
Is this the correct database [Yes] ?
AD Splicer needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Splicer is verifying your username/password.
The status of various features in this run of AD Splicer is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
*** Edition Enabled User ***
Please enter the directory where your AD Splicer control file is located.
The default directory is [/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin] :
Please enter the name of your AD Splicer control file [newprods.txt] :
Processing file /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/newprods.txt...
Loading information for product 'XXTOP'...
Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!
Successfully read file /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/newprods.txt.
Verifying localizations...
Validating inter-product dependency information...
Re-organizing product information lists...
Adding new languages into FND_LANGUAGES...
Creating ORACLE usernames for products...
AD Splicer is creating or updating the ORACLE username XXTOP
with password ***** for te4b custom top tables.
New product XXTOP spliced. Use FNDCPASS to change the password.
Granting privileges for tablespaces...
Granting required system privileges and creating APPS*DDL packages...
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** XXTOP *****'
Done running adaddls.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddls.pls ***** XXTOP *****'
Done running adaaddls.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddlb.pls ***** XXTOP *****'
Done running adaddlb.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddlb.pls ***** XXTOP *****'
Done running adaaddlb.pls for XXTOP
Registering ORACLE usernames/passwords.
**
**Inserting application information for new products...
**
**** Running Seed Table Prepare for FND_APPLICATION ****
**** Running Seed Table Prepare for FND_APPLICATION_TL ****
Running fnd_application_pkg.add_language ...
**
**Updating product information for new products...
**
Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.
**
**Updating product dependency information...
**
Recording modules in the database...done.
**
**Updating Data Groups...
**
Reading existing data groups from database.
Registering any new data groups.
Registering any new data group units.
Updating Data Group "Standard" to point to
APPS #1 Account (ORACLE ID = 900)
Updating Patch Advisor tables to include new product information ..
sqlplus -s APPS/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/sql/adpaseed.sql *****'
Done.
Saving module actions...done.
Saving product actions...done.
Making product top directory for product "XXTOP"...
Directory will be /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/XXTOP/12.0.0
Making directory "log" for product "XXTOP"...
Making directory "out" for product "XXTOP"...
Making directory "mesg" for product "XXTOP"...
Making directory "sql" for product "XXTOP"...
Creating stub file "sql/XXTOPNLINS.sql" for product "XXTOP"...
Making directory "admin/sql" for product "XXTOP"...
Creating stub file "admin/sql/XXTOPNLADD.sql" for product "XXTOP"...
Making directory "admin/driver" for product "XXTOP"...
Recording ADSPLICE action for product: XXTOP
Do you wish to regenerate your environment file [Yes] ? yes
Checking if AutoConfig is enabled....
Running AutoConfig on : All products ...
The log file is located at:
/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/ERPVIS/log/autoconfig_1.log
Please check the log file for more details about the run of AutoConfig.
If you added new products, use FNDCPASS to change their default passwords.
AD Splicer is complete.
Errors and warnings are listed in the log file
/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/ERPVIS/log/adsplice.log
and in other log files in the same directory.
Check in the backend whether custom schema is created or not.
Also check whether custom folder got created in $APPL_TOP with name xxerp.
Reset the environment using by running EBSapps.env /dev/oracle/DEV/EBSapps.env run
Thanks.
Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support.
STEP2:
-rw-r--r--. 1 applerp dba 13049 Jun 20 21:16 p3636980_R12_GENERIC (1).zip
-bash-4.1$ unzip *
Archive: p3636980_R12_GENERIC (1).zip
inflating: 3636980/README.html
inflating: 3636980/README.txt
inflating: 3636980/patch_metadata.xml
inflating: 3636980/u3636980.drv
inflating: 3636980/f3636980.ldt
inflating: 3636980/izu/patch/115/manualsteps/izu_splice_extra.xml
inflating: 3636980/izu/patch/115/manualsteps/izu_splice_tasks.xml
inflating: 3636980/izu/admin/izuprod.txt
inflating: 3636980/izu/admin/izuterr.txt
inflating: 3636980/izu/admin/newprods.txt
inflating: 3636980/izu/admin/driver/izufile.drv
extracting: 3636980/marker1.txt
inflating: 3636980/b3636980.ldt
-bash-4.1$ mv izuterr.txt xxtoperr.txt
-bash-4.1$ mv izuprod.txt xxtopprod.txt
- -bash-4.1$ ls -lrt
total 20
-rwxr-xr-x. 1 applerp dba 4966 Jan 1 2002
xxtopprod.txt
-rwxr-xr-x. 1 applerp dba 2889 Jan 1 2002
xxtoperr.txt
-rwxr-xr-x. 1 applerp dba
365 Jan 1 2002 newprods.txt
drwxr-xr-x. 2 applerp dba 4096 Jun 27 18:33 driver
Step4:
Open newprods.txt in a text editor.
Change from below
%%% Splicer control file format 12.0.A
#
# $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $
#
#
# Section for Oracle Support Diagnostic Tools
from
%%% Splicer control file format 12.0.A
#
# $Header: newprods.txt 120.1 2006/09/20 12:57:45 jaobrien noship $
#
#
# Section for Oracle Support Diagnostic Tools
product=izu
base_product_top=*APPL_TOP*
oracle_schema=izu
sizing_factor=100
main_tspace=USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace=USER_DATA
to
# end of Oracle Support Diagnostic Tools
product=XXTOP
base_product_top=*APPL_TOP*
oracle_schema=xxtop
sizing_factor=100
main_tspace=USER_DATA
index_tspace=USER_IDX
temp_tspace=TEMP
default_tspace=USER_DATA
# end of Oracle Support Diagnostic Tools
Step5:
open xxerpprod.txt and change the references from izu to xxerp
Please use below sql for finding whether custom application id 50000 is availble or not
select decode(count ,0, 'Selected number is available', 'Selected number is already in use') Status, &&enter_custom_applID selected_number
from
(
select count(*) as count from
(
select 'x' from fnd_oracle_userid
where oracle_id= &&enter_custom_applID
union
select 'x' from fnd_application
where application_id= &&enter_custom_applID
)
);
STATUS SELECTED_NUMBER
--------------------------------- ---------------
Selected number is avalible 50080
Step 6:
open xxtopprod.txt and change the references from izu to xxtop
-bash-4.1$ cat xxtopprod.txt
# +=======================================================================+
# | Copyright (c) 1992 Oracle Corporation Redwood Shores, CA USA |
# | All rights reserved. |
# +=======================================================================+
# | FILENAME |
# | izuprod.txt |
# | $Header: izuprod.txt 120.1 2006/09/20 15:57:48 jaobrien noship $
# | |
# | DESCRIPTION |
# | Common product description file. |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | This file is changed with each release. |
# | HISTORY |
# | 05/18/04 kkhokhar created |
# | 12-sep-05 mcasalgr internal revision |
# +=======================================================================+
#
# ##################################################
# 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
xxtop 50080
END_OF_PRODUCT_ABBREVIATIONS -999
#
# ##################################################
# Oracle Support Diagnostic Tools
# ##################################################
#
# application id, abbreviation, shortname, prefix
50080 xxtop XXtop 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
50080 XXtop XXtop
# concurrent conflict set id (logical database id)
0
# minimum version you can upgrade from, for shared and for fully-installed
1.0.0 1.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
XXtop 12.0.0
END_OF_RELEASE 0.0.0
#
#
# #################################################################
# end of izuprod.txt file
# #################################################################
#
step 7:
open xxtopterr.txt and change the references from izu to xxtop
-bash-4.1$ cat xxtopterr.txt
# +=======================================================================+
# | Copyright (c) 1994 Oracle Corporation Redwood Shores, CA USA |
# | All rights reserved. |
# +=======================================================================+
# | FILENAME |
# | izuterr.txt |
# | $Header: izuterr.txt 120.1 2006/09/20 15:54:52 jaobrien noship $
# | |
# | DESCRIPTION |
# | Appliation Autopatch territory description file for now |
# | it only contains a list of possible languages |
# | |
# | NOTES |
# | All comment lines must begin with a #. |
# | HISTORY |
# | kkhokhar 05/18/04 Created |
# | mcasalgr 12-sep-05 internal revision |
# +=======================================================================+
#
%%% 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 xxtop top_custom_top
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 izuterr.txt file
# #################################################################
Step9:
Copy the following text files to the $APPL_TOP/admin directory:
xxtopprod.txt
xxtopterr.txt
newprods.txt
Change the current working directory to $APPL_TOP/admin
cd $APPL_TOP/admin
Step10:Run adsplice
-bash-4.1$ adsplice
Copyright (c) 2002, 2012 Oracle Corporation
Redwood Shores, California, USA
AD Splicer
Version 12.2.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Your default directory is '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Splicer records your AD Splicer session in a text file
you specify. Enter your AD Splicer log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adsplice.log] :
************* Start of AD Splicer session *************
AD Splicer version: 12.2.0
AD Splicer started at: Thu Jun 21 2018 21:47:41
APPL_TOP is set to /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl
Change DB = YES.
Backing up restart files, if any......Done.
Your previous AD Splicer session did not run to completion.
Do you wish to continue with your previous AD Splicer session [Yes] ? no
You chose to disregard your previous AD Splicer session
and to restart AD Splicer from the beginning.
Enter Yes to confirm that you wish to overwrite your previous
AD Splicer session and begin a new AD Splicer session.
Enter No to continue with your previous AD Splicer session. [No] : yes
Please enter the name of the Oracle E-Business Suite System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [ERPVIS] : ERPVIS *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have or want to install files used for installing or upgrading
the database in this APPL_TOP [YES] ? YES *
Do you currently have or want to install Java and HTML files for HTML-based
functionality in this APPL_TOP [YES] ? YES *
Do you currently have or want to install Oracle E-Business Suite forms files
in this APPL_TOP [YES] ? YES *
Do you currently have or want to install concurrent program files
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle E-Business Suite
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [AT_erp] : AT_erp *
You are about to install or upgrade Oracle E-Business Suite product tables
in your ORACLE database 'ERPVIS'
using ORACLE executables in '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/10.1.2'.
Is this the correct database [Yes] ?
AD Splicer needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Splicer is verifying your username/password.
The status of various features in this run of AD Splicer is:
<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code Language Status
---- --------------------------------------- ---------
US American English Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
*** Edition Enabled User ***
Please enter the directory where your AD Splicer control file is located.
The default directory is [/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin] :
Please enter the name of your AD Splicer control file [newprods.txt] :
Processing file /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/newprods.txt...
Loading information for product 'XXTOP'...
Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!
Successfully read file /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/newprods.txt.
Verifying localizations...
Validating inter-product dependency information...
Re-organizing product information lists...
Adding new languages into FND_LANGUAGES...
Creating ORACLE usernames for products...
AD Splicer is creating or updating the ORACLE username XXTOP
with password ***** for te4b custom top tables.
New product XXTOP spliced. Use FNDCPASS to change the password.
Granting privileges for tablespaces...
Granting required system privileges and creating APPS*DDL packages...
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** XXTOP *****'
Done running adaddls.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddls.pls ***** XXTOP *****'
Done running adaaddls.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddlb.pls ***** XXTOP *****'
Done running adaddlb.pls for XXTOP
sqlplus -s XXTOP/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddlb.pls ***** XXTOP *****'
Done running adaaddlb.pls for XXTOP
Registering ORACLE usernames/passwords.
**
**Inserting application information for new products...
**
**** Running Seed Table Prepare for FND_APPLICATION ****
**** Running Seed Table Prepare for FND_APPLICATION_TL ****
Running fnd_application_pkg.add_language ...
**
**Updating product information for new products...
**
Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.
**
**Updating product dependency information...
**
Recording modules in the database...done.
**
**Updating Data Groups...
**
Reading existing data groups from database.
Registering any new data groups.
Registering any new data group units.
Updating Data Group "Standard" to point to
APPS #1 Account (ORACLE ID = 900)
Updating Patch Advisor tables to include new product information ..
sqlplus -s APPS/***** @/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/ad/12.0.0/sql/adpaseed.sql *****'
Done.
Saving module actions...done.
Saving product actions...done.
Making product top directory for product "XXTOP"...
Directory will be /home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/XXTOP/12.0.0
Making directory "log" for product "XXTOP"...
Making directory "out" for product "XXTOP"...
Making directory "mesg" for product "XXTOP"...
Making directory "sql" for product "XXTOP"...
Creating stub file "sql/XXTOPNLINS.sql" for product "XXTOP"...
Making directory "admin/sql" for product "XXTOP"...
Creating stub file "admin/sql/XXTOPNLADD.sql" for product "XXTOP"...
Making directory "admin/driver" for product "XXTOP"...
Recording ADSPLICE action for product: XXTOP
Do you wish to regenerate your environment file [Yes] ? yes
Checking if AutoConfig is enabled....
Running AutoConfig on : All products ...
The log file is located at:
/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/ERPVIS/log/autoconfig_1.log
Please check the log file for more details about the run of AutoConfig.
If you added new products, use FNDCPASS to change their default passwords.
AD Splicer is complete.
Errors and warnings are listed in the log file
/home/applerp/R12_2_6_apps/ERPVIS/fs1/EBSapps/appl/admin/ERPVIS/log/adsplice.log
and in other log files in the same directory.
Check in the backend whether custom schema is created or not.
Also check whether custom folder got created in $APPL_TOP with name xxerp.
Reset the environment using by running EBSapps.env /dev/oracle/DEV/EBSapps.env run
Thanks.
No comments:
Post a Comment