STEP1:
Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support.
STEP2:
Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory.
STEP3:
Rename izuterr.txt to xxerpterr.txt
and izuprod.txt to xxerpprod.txt
Step4:
Open newprods.txt in a text editor.
Change from below
to
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 ) );
open xxerpterr.txt and change the references from izu to xxerp
Step6:
Copy the following text files to the $APPL_TOP/admin directory:
xxerpprod.txt
xxerpterr.txt
newprods.txt
Change the current working directory to $APPL_TOP/admin
cd $APPL_TOP/admin
Step7:Run adsplice
[appldev@dev-devapp1 admin]$ 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 '/dev/oracle/DEV/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: Mon Jul 11 2016 00:42:31 APPL_TOP is set to /dev/oracle/DEV/fs1/EBSapps/appl Change DB = 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 [DEV] : DEV * 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_relebsodevapp1] : AT_relebsodevapp1 * You are about to install or upgrade Oracle E-Business Suite product tables in your ORACLE database 'DEV' using ORACLE executables in '/dev/oracle/DEV/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 [/dev/oracle/DEV/fs1/EBSapps/appl/admin] : Please enter the name of your AD Splicer control file [newprods.txt] : Processing file /dev/oracle/DEV/fs1/EBSapps/appl/admin/newprods.txt... Loading information for product 'xxerp'... Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file! Successfully read file /dev/oracle/DEV/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 XXERP with password ***** for XXERP CUSTOM Application tables. New product XXERP spliced. Use FNDCPASS to change the password. Granting privileges for tablespaces... Granting required system privileges and creating APPS*DDL packages... sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddls.pls ***** XXERP *****' Done running adaddls.pls for XXERP sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddls.pls ***** XXERP *****' Done running adaaddls.pls for XXERP sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaddlb.pls ***** XXERP *****' Done running adaddlb.pls for XXERP sqlplus -s XXERP/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adaaddlb.pls ***** XXERP *****' Done running adaaddlb.pls for XXERP 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 **** INSERT INTO FND_OAM_CONTEXT_CUSTOM (OA_VAR,CTX_TYPE,OA_TYPE,NAME,DEFAULT_VALUE,TITLE,DESCRIPTION) VALUES ('c_xxerp','A','PROD_TOP','c_xxerp','/dev/oracle/DEV/fs1/EBSapps/appl/xxerp/12.0.0','custom prod top xxerp','this is spliced custom prod top') Temporarily resetting CLASSPATH to: "/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/dev/oracle/DEV/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/dev/oracle/DEV/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/dev/oracle/DEV/fs1/EBSapps/comn/java/classes:/dev/oracle/DEV/fs1/EBSapps/10.1.2/forms/java:/dev/oracle/DEV/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/dev/oracle/DEV/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/dev/oracle/DEV/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar" Calling /dev/oracle/DEV/fs1/EBSapps/comn/util/jdk32/jre/bin/java ... 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/***** @/dev/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/dev/oracle/DEV/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 "xxerp"... Directory will be /dev/oracle/DEV/fs1/EBSapps/appl/xxerp/12.0.0 Making directory "log" for product "xxerp"... Making directory "out" for product "xxerp"... Making directory "mesg" for product "xxerp"... Making directory "sql" for product "xxerp"... Creating stub file "sql/XXERPNLINS.sql" for product "xxerp"... Making directory "admin/sql" for product "xxerp"... Creating stub file "admin/sql/XXERPNLADD.sql" for product "xxerp"... Making directory "admin/driver" for product "xxerp"... Recording ADSPLICE action for product: xxerp Do you wish to regenerate your environment file [Yes] ? Yes Checking if AutoConfig is enabled.... Running AutoConfig on : All products ...
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.
thanks for sharing such a useful documents
Thanks Razi
Nice and useful articles. I loved reading them.
Thanks
Mr Bala How are you, This is Suresh Talasila make sure you change this step Step7:Run adadmin it should be Step7:Run adsplice
Thanks Suresh. I have updated