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 ...

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 live online training, plus books, videos, and digital content from nearly 200 publishers.