Oracle E-Business Suite R12 Core Development and Extension Cookbook

Installing the database objects

Create the database objects for this chapter before you start by using a script provided. The code comes with the following readme file: readme_3_1.txt.

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. For all of the database objects there is a script provided called 4842_03_01.sh. The following section provides details of how to run the script.

How to do it...

To create the database objects, perform the following steps:

1. Create a local directory C:\packt\scripts\ch3 where ...