Creating and Building Optimization Records

To create and build optimization application records:

1. Create the optimization application record definitions using PeopleSoft Application Designer.

   1. Select Start, and then Programs, and then PeopleSoft 8.xx, and then Application Designer.

   2. Enter your signon information, and click the OK button.

      The Application Designer window appears.

   3. Select File, and then New from the tool menu.

   4. Select the Record option, and click the OK button.

2. For every optimization application record that is readable, create an optimization delete record by cloning the optimization application record.

   Clone the record by performing a Save As operation on the optimization application record and renaming the optimization delete record to be similar to the original optimization application record. Use a naming convention for all optimization delete records. For example, the optimization delete record for the record QE_R_HOLIDAYS might be named QE_R_HOLIDAYDEL.

   Alternatively, use a sub-record definition that is shared by the optimization application record and the delete record.

   Note:

   Oracle strongly recommends that you keep the optimization application record and its associated optimization delete record in sync with each other.

3. For every optimization application record that is readable, associate that record with its optimization delete record using the these steps:

   1. In PeopleSoft Application Designer, open the optimization application record.

   2. Select File, and then Definition Properties.

   3. Select the Use tab in the Record Properties dialog box.

   4. Enter the name of the optimization delete record in the Optimization Delete Record field.

4. Open (or create) a project and insert all the optimization application records and optimization delete records into the project.

5. Create the tables from these records.

   1. Select Build, and then Project.

      The Build dialog box appears, showing the optimization application records and optimization delete records in the project.

   2. Select the Create Tables check box, and make sure that theCreate Triggers check box is clear.

   3. Click the Build button.

6. Create optimization database triggers from these records.

   1. Select Build, and then Project.

      The Build page appears, showing the optimization application records and optimization delete records in the project.

   2. Select the Create Triggers check box.

   3. Click the Build button.

Note:

Optimization delete records can be used by several analytic types. When a record is deleted from an analytic type, the associated delete record is not needed if this record is not used elsewhere.