Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Installing the database objects

Create the database objects for this chapter before you start, by using a script provided called 7126_02_01.sh.

Getting ready

We are going to create a table, view, and synonym for the new block we will create. We will also create a package that will handle all of the database transactions, such as insert, update, and delete. Finally, we will create a sequence that will be used to generate a unique number for new records. The next section provides details of how to run the script.

Tip

Create XXHR schema

If you have not done so already, create a new custom schema called XXHR. Please refer to Chapter 8, Utilities to create the schema if you have not done so already before running the database installation script given ...