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

Get Oracle E-Business Suite R12 Integration and OA Framework 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.