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 readme file, readme_4_1.txt.

We will be creating a database package that we will use in some of the following recipes in this chapter. Finally, we will create a sequence that will be used to generate a unique number for new records. For all the database objects, there is a script provided called 4842_04_01.sh. The following recipe provides details on how to run the script.

How to do it...

To create the database objects, perform the following tasks:

1. Create a local directory, C:\packt\scripts\ch4, where the scripts are downloaded to.
2. Open Putty and connect to the application tier user.
3. Create a new directory ...