Creating a Custom Application in Oracle E-Business Suite Release 12.1.3 and 12.2

Custom applications are required if you are creating new forms, reports, and so on.

Requirements and Defaults:

The procedure described in this document should be performed on the run file system when there is no active patching cycle.
Custom data and index tablespaces default to APPS_TS_TX_DATA and APPS_TS_TX_IDX respectively.

First down the Application services, then after starting the Process

Create Custom Application Using AD Splice:

1. Create tablespace with the below command

sqlplus “/as sysdba”
select NAME, FILE# from V$DATAFILE;

TEMP tablespace :
select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;

create tablespace XXEXAM datafile ‘/devdb/oracle/data/xxexam01.dbf’ size 1024M AUTOEXTEND ON NEXT 100M

2. New User creation:

create user xxexam identified by xxexam default tablespace XXEXAM temporary tablespace TEMP1 profile default account unlock;

product=xxexam
main _tablespace : APPS_TS_TX_DATA
Index tablespace : APPS_TS_TX_IDX

temp tablepace : TEMP1
default tablespace: APPS_TS_TX_DATA