Oracle E-Business Suite R12 Core Development and Extension Cookbook

Creating a custom schema

When we create custom objects, we need to put them in a custom schema. Oracle has its own schemas for each of its modules such as HR or AP. The schema is defined within Oracle EBS as an application. For each standard schema we extend, you create a custom schema. A custom schema will begin with XX so that we can identify any extension that has been applied to an environment. So, let's say we are extending HR; 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