blue sky.. green sea.. red earth_ r12.2.x - registering custom application_ product_ custom_top in...
TRANSCRIPT
9/2/2015 Blue Sky.. Green Sea.. Red Earth: R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
http://zealtheory.blogspot.com/2014/10/r122xregisteringcustomapplication.html 1/4
Theorems, Equations & Reactions
Blue Sky.. Green Sea.. Red Earth
R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
The process of registering custom application is different from other version oracle applications. Below are the steps that I followed toperform the register custom application like XXONT (An extension to the standard Oracle Order Management module). The sameapplies for any Custom Application /Product.
With R12.2.x, Oracle have introduced online patching functionality using two file editions RUN and PATCH. We should NOT useApplications form to register custom application rather use adsplice to ensure that the application is set up for online patching.
Environment:Two node architecture with application node in Linux and Database on HP UX Itanium
Application Release: R12.2.3 on Linux x86 64 bit 6This node runs all the components of the Oracle EBS like forms, weblogic, concurrent managers, OACore and so on.Database : 11.2.0.3 on HP UX Itanium. Database node contains only the database.
Steps:
1. Create the schema in the database. I am creating a schema called 'PLUM' and I use the same schema for all the custom application.You are always welcome to create each schema for each custom application.
CREATE USER PLUM IDENTIFIED BY plumDEFAULT TABLESPACE APPS_TS_TX_DATATEMPORARY TABLESPACE TEMP1PROFILE DEFAULTACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE TO PLUM; GRANT CREATE ANY CONTEXT TO PLUM; GRANT CREATE ANY TYPE TO PLUM; GRANT CREATE CLUSTER TO PLUM; GRANT CREATE DATABASE LINK TO PLUM; GRANT CREATE DIMENSION TO PLUM; GRANT CREATE INDEXTYPE TO PLUM; GRANT CREATE LIBRARY TO PLUM; GRANT CREATE MATERIALIZED VIEW TO PLUM; GRANT CREATE OPERATOR TO PLUM; GRANT CREATE PROCEDURE TO PLUM; GRANT CREATE PUBLIC SYNONYM TO PLUM; GRANT CREATE SEQUENCE TO PLUM; GRANT CREATE SYNONYM TO PLUM; GRANT CREATE TABLE TO PLUM; GRANT CREATE TRIGGER TO PLUM; GRANT CREATE TYPE TO PLUM; GRANT CREATE VIEW TO PLUM;
2. Download the patch 3636980 (Support Diagnostics (IZU) patch for AD Splice). This patch is generic for R12.
3. Unzip the files in the patch and copy the following three files from p3636980_R12_GENERIC\3636980\izu\admin to your desktop/current working folder.
izuprod.txt
izuterr.txtnewprods.txt
4.Rename the file izuprod.txt to [CUSTOM_MODULE]prod.txt and izuterr.txt to [CUSTOM_MODULE]terr.txt
In my case, I renamed the file as xxontprod.txt and xxontterr.txt.
5. Open the newprods.txt in a text editor and change all references of "izu" to [custom_module] and all references of "IZU" to[CUSTOM_MODULE]. Please do maintain the case sensitivity.
Cherrish Vaidiyan
Idealist, Minimalist andEnthusiast
View my complete profile
"DREAM IS THE FUEL"
Select Language
Powered by Translate
TRANSLATE
2015 (8)
2014 (30) Dec (5)
Nov (3)
Oct (4)R12.2.x RegisteringCustom Application/Product/...
Oracle 10g /11g ORA02082: a loopbackdatabase l...
Oracle 11g RDBMS Renaming the OracleDatabase (S...
Oracle RDBMS : DROPDATABASE ORA01586: database...
Sep (5)
Jun (1)
May (5)
Apr (4)
Feb (3)
2013 (15)
2012 (13)
2011 (18)
2010 (5)
2009 (4)
2008 (1)
2007 (2)
2006 (1)
BLOG ARCHIVE
0 More Next Blog» Create Blog
9/2/2015 Blue Sky.. Green Sea.. Red Earth: R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
http://zealtheory.blogspot.com/2014/10/r122xregisteringcustomapplication.html 2/4
In my example, I will change 'izu' to 'xxont' and 'IZU' to 'XXONT'.
%%% 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=xxontbase_product_top=*APPL_TOP*oracle_schema=plumsizing_factor=100main_tspace=APPS_TS_TX_DATAindex_tspace=APPS_TS_TX_IDXtemp_tspace=TEMP1default_tspace=APPS_TS_TX_DATA
# end of Oracle Support Diagnostic Tools
6. Open the xxontprod.txt in a text editor
Change all the references of 'izu' and 'IZU' with 'xxont' and 'XXONT' respectively. Please do maintain the case sensitivity.
Change the Application/Product ID from 278 to your own unique number.
Note: Oracle recommends to pick a number above 50000 that is not already in use. You can use the below SQL to confirm thatApplication/Product ID is available to use or not:
SQL>select decode(count ,0, 'Selected number is Available', 'Selected number already in use') Status, &&enter_custom_applID selected_numberfrom(select count(*) as count from(select 'x' from fnd_oracle_useridwhere oracle_id= &&enter_custom_applIDunionselect 'x' from fnd_applicationwhere application_id= &&enter_custom_applID));
I wanted to give 50301 for XXONT, so I entered 50301 as the parameter for the query. The SQL returned "Selected number isAvailable".
So I changed 278 to 50301 in the file xxontprod.txt.
7. Open the xxontterr.txt in a text editor.
Change all the references of 'izu' to [custom_module] and 'IZU' to [CUSTOM_MODULE] keeping the case sensitivity. In ourexample, 'izu' > 'xxont' and 'IZU' > 'XXONT'.
Change the text 'Oracle_Support_Diagnostic_Tools' to 'abc_custom_app". In my example, I changed the text to'Plum_Oracle_Order_Management'.
8. Copy the three files to $APPL_TOP/admin directory.
xxontprod.txtxxontterr.txt
newprods.txt
9. Change the directory to $APPL_TOP/admin and run adsplice. Note: adsplice must be run from the admin directory under APPL_TOP.
$ adsplice
Your default directory is '/u01/app/oracle/fs1/EBSapps/appl'.Is this the correct APPL_TOP [Yes] ?
Filename [adsplice.log] : adsplice_xxont.log
9/2/2015 Blue Sky.. Green Sea.. Red Earth: R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
http://zealtheory.blogspot.com/2014/10/r122xregisteringcustomapplication.html 3/4
scribbled by Cherrish Vaidiyan on Thursday, October 23, 2014
You are about to install or upgrade Oracle E‐Business Suite product tablesin your ORACLE database 'D599'using ORACLE executables in '/u01/app/oracle/fs1/EBSapps/10.1.2'.Is this the correct database [Yes] ?
Enter the password for your 'SYSTEM' ORACLE schema:
Enter the ORACLE password of Application Object Library [APPS] :
Please enter the directory where your AD Splicer control file is located.The default directory is [/u01/app/oracle/fs1/EBSapps/appl/admin] : Please enter the name of your AD Splicer control file [newprods.txt] :
Do you wish to regenerate your environment file [Yes] ?
Checking if AutoConfig is enabled....
Running AutoConfig on : All products ...
10. Check the adsplice and Autoconfig log file.
Now you can verify that the Custom Product/ Application is in the database using the following queries:
Log in to SQLPLUS as apps.
select * from fnd_application where application_short_name = 'XXONT';select * from fnd_product_installations where APPLICATION_ID = 50301;select * from dba_users where username = 'XXONT';
Login to new session of Application node and check for environment file$ env |grep XXONTXXONT_TOP=/u01/app/oracle/fs1/EBSapps/appl/xxont/12.0.0$$ ls $XXONT_TOPadmin log mesg out sql
11. You can not create other additional directories if needed like bin, /forms/US, include, lib, mds, reports/US, workflow.
Note:If you are using Shared APPL_TOP, you need to do all these process on ONE node and then run autoconfig on others. You don't haveto rerun adsplice. If APPL_TOP is NOT SHARED, repeat the steps 8,9,10 and 11.
Do you have to repeat the steps for Patch File system ?When you start the next online patching cycle, the prepare phase will run adsplice syncup actions to synchronize the two file systems.Check for a known bug 18815526:R12.AD.C in case adsplice syncup fails when prepare phase is run.
Reference:Creating a Custom Application in Oracle EBusiness Suite Release 12.2 (Doc ID 1577707.1)
Recommend this on Google
1 comment:
Nadh August 25, 2015 at 4:18:00 AM EDT
Hi,
Thanks a a lot for your notes. It is indeed very helpful.But can you please also include how the output at the user interface looks like?
9/2/2015 Blue Sky.. Green Sea.. Red Earth: R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
http://zealtheory.blogspot.com/2014/10/r122xregisteringcustomapplication.html 4/4
Newer Post Older PostHome
Subscribe to: Post Comments (Atom)
Notify me
Sign out
Enter your comment...
Comment as: Unknown (Google)
Publish Preview
Regards,Nadhrah
Reply
Oracle 11g: Data Guard Physical Standby Database Setup Guide using RMAN Duplicate
Oracle RMAN 11g: SQL queries against Catalog Database for backup info
R12.2.x Registering Custom Application/ Product/ CUSTOM_TOP in Oracle EBusiness Suite Release 12.2
Common Data Guard Broker (DGMGRL) Errors ORA16664, ORA16809, ORA16714, ORA16826
Oracle Discoverer ERROR: The shiphome you are trying to install is not the proper shiphome for the current platform. The shiphome is for Microsoft Windows (32bit) platform.
Oracle Discoverer dis51adm.exe or dis51usr.exe ERROR: The program can't start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix thisproblem.
R12.x ORA20100: Error: FND_FILE failure. Unable to create file, lxxxxxxx.tmp in the directory, /yyy/zzzz/abc
Oracle Database: UTL_FILE_DIR init Parameter validation script
Oracle RDBMS : DROP DATABASE ORA01586: database must be mounted EXCLUSIVE and not open for this operation
R12.2.x adop phase=prepare ORA20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH
POPULAR POSTS
Picture Window template. Powered by Blogger.