Procedure:
1-We start by downloading the patch "3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support. We will be using its contents to setup the application.
2- Under 3636980/izu/admin there are 3 files that needs to be used.
izuprod.txt izuterr.txt newprods.txt
3- We then rename the following files accordingly, such asprod.txt and
terr.txt
mv izuprod.txt xxstprod.txt
mv izuterr.txt xxstterr.txt
4- Change the details in the newprods.txt so that all references of "izu" to and all references of "IZU" to (i.e. keep the case sensitivity).
5- We then create a tablespace. In our example our tablespace name will be TSXXST
7- Then xxstprod.txt will be changed so that all references of "izu" toand all references of "IZU" to (i.e. keep the case sensitivity). We also change product id references of 278 to our own number which we decide according the following SQL. Choose one id accordingly, "for example 50001", and replace 278 with it.
8- We then edit the last file xxstterr.txt so that all references are for xxst which our new custom top.
9- We then copy the files we have changed to the $APPL_TOP/admin folder.
cp newprods.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
cp xxstprod.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
cp xxstterr.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
10- Then we are finally able to run adsplice under the $APPL_TOP folder so that we run autoconfig and create our custom application.
>cd $APPL_TOP/admin
>adsplice
11- Remember to check apply the following SQLs so that we might be sure that we have created our application top.
select * from fnd_application where application_short_name = 'XXST';
select * from fnd_product_installations where APPLICATION_ID = 50101;
select * from dba_users where username = 'XXST';
Note: The thing that we have done for a system that is with one application machine and one database machine. If you have more than one application servers that you will have to create application top in your other non shared application.
References:
1-Creating a Custom Application in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)
2-
3- We then rename the following files accordingly, such as
mv izuprod.txt xxstprod.txt
mv izuterr.txt xxstterr.txt
4- Change the details in the newprods.txt so that all references of "izu" to
5- We then create a tablespace. In our example our tablespace name will be TSXXST
CREATE TABLESPACE TSXXST DATAFILE
'/u01/install/PROD/data/tsxxst01.dbf' SIZE 1024M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
DEFAULT
COMPRESS BASIC
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE USER XXST
IDENTIFIED BY xxst
DEFAULT TABLESPACE TSXXST
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 1 Role for XXST
GRANT CONNECT TO XXST;
ALTER USER XXST DEFAULT ROLE ALL;
-- 13 System Privileges for XXST
GRANT ALTER ANY OUTLINE TO XXST;
GRANT ALTER SESSION TO XXST;
GRANT ANALYZE ANY TO XXST;
GRANT CREATE ANY OUTLINE TO XXST;
GRANT CREATE CLUSTER TO XXST;
GRANT CREATE MATERIALIZED VIEW TO XXST;
GRANT CREATE SEQUENCE TO XXST;
GRANT CREATE SESSION TO XXST;
GRANT CREATE TABLE TO XXST;
GRANT CREATE TRIGGER TO XXST;
GRANT CREATE TYPE TO XXST;
GRANT DROP ANY OUTLINE TO XXST;
GRANT QUERY REWRITE TO XXST;
-- 2 Tablespace Quotas for XXST
ALTER USER XXST QUOTA UNLIMITED ON APPS_TS_TX_DATA;
ALTER USER XXST QUOTA UNLIMITED ON TSXXST; 7- Then xxstprod.txt will be changed so that all references of "izu" to
select decode(count ,0, 'Selected number is Available', 'Selected number 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
)
); 8- We then edit the last file xxstterr.txt so that all references are for xxst which our new custom top.
9- We then copy the files we have changed to the $APPL_TOP/admin folder.
cp newprods.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
cp xxstprod.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
cp xxstterr.txt /u01/install/APPS/fs1/EBSapps/appl/admin/.
10- Then we are finally able to run adsplice under the $APPL_TOP folder so that we run autoconfig and create our custom application.
>cd $APPL_TOP/admin
>adsplice
11- Remember to check apply the following SQLs so that we might be sure that we have created our application top.
select * from fnd_application where application_short_name = 'XXST';
select * from fnd_product_installations where APPLICATION_ID = 50101;
select * from dba_users where username = 'XXST';
Note: The thing that we have done for a system that is with one application machine and one database machine. If you have more than one application servers that you will have to create application top in your other non shared application.
1-Creating a Custom Application in Oracle E-Business Suite Release 12.2 (Doc ID 1577707.1)
