O'Reilly logo

Oracle E-Business Suite R12 Core Development and Extension Cookbook by Andy Penver

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required