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

Get Oracle E-Business Suite R12 Core Development and Extension Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.