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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.