Oracle 11i E-Business Suite from the Front Lines

Chapter 2: 11i, 8i, and 9i New Features

Table 2.1: AFCHKCBO.sql Sample Output

Table 2.2: Create Materialized View Example

Table 2.3: Refresh Options for MVs

Table 2.4: Partitioning Raw Data

Table 2.5: Partition by Date

Table 2.6: Partition by Date, Subpartition by Location

Table 2.7: The GL_BALANCES Table

Chapter 3: The Surrounding Environment

Table 3.1: Vis Instance's apps.cmd file

Table 3.2: Vis.cmd

Table 3.3: Envshell.cmd

Table 3.4: Adovars.cmd

Table 3.5: Appsora.cmd

Table 3.6: Output Interpretation of /usr/bin/getconf _SC_CPU_VERSION

Chapter 4: Apache

Table 4.1: Extended Status Directive Statuses

Table 4.2: LogLevel Levels Available

Table 4.3: English Interpretations LogFormat Variable

Table 4.4: IndexOptions Options

Table 4.5: Possible ProxyVia Settings

Chapter 6: Other Services

Table 6.1: Oracle Forms Executables

Table 6.2: Reports Executables

Table 6.3: DAD File

Chapter 7: Printing

Table 7.1: HP LaserJet Printers Common Escape Strings

Table 7.2: Escape Character Translations

Table 7.3: Printer Parameters

Table 7.4: Environment Variables

Table 7.5: fpd2_unix.ctl

Table 7.6: SQL*Loader Output File

Chapter 8: AD and Other Utilities

Table 8.1: Most Common Utilities

Table 8.2: AR Entry in the newprods.txt File

Table 8.3: Description of Entries in the newprods.txt File

Table 8.4: Output from ADRELINK

Table 8.5: Output of Adrelink.sh Examples

Table 8.6: Output of Adrelink Examples Filelist

Table 8.7: FNDLOAD Parameters

Table 8.8: Output if ADJKEY -l Is Unable to Find a Valid Key

Table 8.9: Create a Key When One Is Available

Table 8.10: Creation of Security Key

Table 8.11: Adjkey -l Successfully Finding Key

Chapter 9: Installation and Migration

Table 9.1: Example Configuration File (Listing 1)

Table 9.2: Services Shutdown Commands

Table 9.3: Installed Minipack Levels

Table 9.4: Init.ora Renamed Parameters

Table 9.5: Obsolete Parameters

Chapter 10: Patching

Table 10.1: Portion of a Log File for a D Driver

Table 10.2: Backup Directory Structure

Table 10.3: OPATCH Parameter List

Table 10.4: Rollback Parameters for OPATCH

Table 10.5: Listing Installed Interim Patches Parameters

Table 10.6: Patch Charting Spreadsheet

Chapter 11: Cloning

Table 11.1: ADCLONE Arguments and Their Meanings

Table 11.2: Postclone Columns that May Need Altering

Table 11.3: Software Necessary to Support Rapid Clone

Table 11.4: Rapid Clone Tables to Check for Incorrect Values

Chapter 12: Concurrent Managers and Concurrent Programs

Table 12.1: Concurrent Manager Executable Descriptions

Table 12.2: Concurrent Manager Phase/Status Combination

Table 12.3: Report Optional Parameters

Table 12.4: Alphabetic Listing of Barbara Mathews' Programs

Table 12.5: Tables Used by Purge Concurrent Request Concurrent Program

Table 12.6: Detailed List of Parameters Accepted by Purge

Table 12.7: Running Concurrent Libraries at OS level, Windows

Table 12.8: STARTMGR Command with 10 Optional Parameters

Table 12.9: CONCSUB Parameters and Their Meanings

Table 12.10: Include/Exclude Rule, Logical Equivalent, and Precedent

Table 12.11: Includes/Excludes and Their Outcome

Table 12.12: RUN_COAL.sql

Table 12.13: Concurrent Program Executable Values for Run_Coal

Table 12.14: Concurrent Program Definition Values

Table 12.15: CMCLEAN.sql Source

Chapter 13: AutoConfig, Oracle Application Manager, and Other Management Tools

Table 13.1: AutoConfig Components

Table 13.2: ADCHKCFG File Statuses and Ramifications

Chapter 14: Odds and Ends

Table 14.1: 1.sql SQL Script for Validating Invalid Objects

Table 14.2: 3.sql SQL Script for Validating Invalid Objects

Table 14.3: 5.sql SQL Script for Validating Invalid Objects

Table 14.4: Calling Validation Scripts

Table 14.5: Performance Problem Resolution Document

Table 14.6: Applications Tuning Document