Creating a custom schema

When we create custom objects, we need to put them in a custom schema. Oracle E-Business Suite (EBS) has its own schemas for each of its modules, such as HR or AP. The schema is linked to the application defined in EBS. For each standard schema we extend, we would create a custom schema. A custom schema will begin with XX , so that we can identify any extensions that have been applied to an environment, and avoid any objects being impacted by any patches that are applied. So, for example, we are extending HR, so we will create a custom schema called XXHR .

We are going to create a schema with the following details:

SCHEMA Name	XXHR
TOP Name	XXHR_TOP
Application	XXHR Custom Application
Data Group	Standard
Request Group	XXHR Request Group
Menu	XXHR_CUSTOM_MENU
Responsibility	XXHR Custom
APPL_TOP	/oracle/apps/r12/visr12/apps/apps_st/appl
Instance Name	VISR12
Server Name	oraclevisionr12

There are several tasks...