Oracle E-Business Suite System Administrator's Guide - Configuration

Setup Steps

Introduction to Oracle Applications Manager

Introduction to Oracle Applications Manager

Oracle Applications Manager Setup

The Site Map

Configuration Overview

Defining Concurrent Programs and Requests

Overview of Concurrent Programs and Requests

Controlling Access to Concurrent Programs and Limiting Active Requests for a User

Organizing Programs into Request Sets

Defining Request Sets

Request Sets and Owners

System Administrator Request Set Privileges

Request Set Incompatibilities

Sharing Parameters in a Request Set

Request Sets Report

Report Parameters

Report Headings

Organizing Programs into Request Groups

Request Security Groups

Using Codes with Request Groups

Customizing the Submit Requests Window

Customizing the Submit Requests Window using Codes

Report Group Responsibilities Report

Report Parameters

Defining Program Incompatibility Rules

Incompatible and Run Alone Programs

Concurrent Conflict Domains

Enforcing Incompatibility Rules

Custom Concurrent Programs

Log and Output Filenames

Oracle Tool Concurrent Programs

Pro*C Concurrent Programs

Host Language Concurrent Programs

Submitting Concurrent Requests (CONCSUB)

Copying and Modifying Program Definitions

Copying and Renaming a concurrent program

Alter Program Priority

Modifying an Incompatible Programs List

Concurrent Program Parameters

Control the Behavior of Request Parameters

Example of modifying a program's parameters

Conflict Domains

Defining Logical Databases

Concurrent Program Details Report

Report Parameters

Report Headings

Concurrent Programs Report

Report Parameters

Report Headings

Request Groups Window

Request Groups Block

Requests Block

Concurrent Program Executable Window

Concurrent Program Executable Block

Stage Function Parameters Window

Concurrent Programs Window

Concurrent Programs Block

Copy to Window

Session Control Window

Incompatible Programs Window

Concurrent Program Parameters Window

Data Groups Window

Data Groups Block

Application-ORACLE ID Pairs Block

Concurrent Conflicts Domains Window

Concurrent Programs HTML UI

Search for Concurrent Programs

Create Concurrent Program

Concurrent Program - Add Parameter

Defining Concurrent Managers

Defining Managers and their Work Shifts in the Oracle Forms UI

Work Shift Definitions

Using Work Shifts to Balance Processing Workload

Using Time-Based Queues

Creating Services within Oracle Applications Manager

Completed Concurrent Requests Report

Report Parameters

Report Headings

Work Shift by Manager Report

Report Parameters

Report Headings

Work Shifts Report

Report Parameters

Report Headings

Specializing Managers to Run Only Certain Programs

Introduction to Specialization Rules

Defining Specialization Rules

Examples - Using Specialization Rules

Defining Combined Specialization Rules

Using Combined Rules

Differences Between Specialization and Combined Rules

Grouping Programs by Request Type

Controlling Concurrent Managers

Manager States

Controlling Managers from the Administer Managers form

Controlling the Internal Concurrent Manager from the Operating System

Overview of Parallel Concurrent Processing

What is Parallel Concurrent Processing?

Parallel Concurrent Processing Environments

How Parallel Concurrent Processing Works

Managing Parallel Concurrent Processing

Defining Concurrent Managers

Administering Concurrent Managers

Administer Concurrent Managers Window

Administer Concurrent Managers Block

The actions you can choose for controlling a manager are:

Reviewing a Specific Manager

Concurrent Processes Window

Viewing Log Files

Concurrent Requests Window

Request Diagnostics Window

Concurrent Managers Window

Concurrent Managers Block

Work Shifts Window

Specialization Rules Window

Work Shifts Window

Combined Specialization Rules Window

Combined Specialization Rules Block

Specialization Rules Block

Concurrent Request Types Window

Concurrent Request Types Block

Viewer Options Window

Viewer Options Block

Nodes Window

Nodes Block

Setting Up and Starting Concurrent Managers

Concurrent Managers

Setting Up Concurrent Managers

Starting the Concurrent Managers

Restarting the Concurrent Managers

Shutting Down the Concurrent Manager Service (Windows)

Removing the Concurrent Manager Service (Windows)

File Conventions

Directory Privileges

Printing

Printers

Printers and Printing

Overview

Printer Types, Print Styles, and Printer Drivers

Sequence of Printing Events

Setting Character-Mode vs. Bitmap Printing

Setting Up Your Printers

Printing Setup Interrelationships

Printer Setup Information Is Cached On Demand

Printer Setup with Pasta

Overview

Setup for Basic Printing with Pasta

Defining Configuration Files for Specific Printers

Using a Different Configuration File as the Default

Modify an Existing Printer Type to Use Pasta

Add a New Printer Type to Use Pasta

Setting Margins

Printing a Report Generated Using the noprint Option

Generating Other Formats Using the Preprocessing Option

Font Source

Language-Specific Font Support

Configuration File Options

Command Line Parameters

Using PrintForms

Create the PrintForm

Common UNIX Printing System (CUPS) Integration

Customizing Printing Support in Oracle E-Business Suite

Hierarchy of Printer and Print Style Assignments

Hierarchy of Printer Assignments

Hierarchy of Print Style Assignments

System Administrator Printer and Print Style Settings

End User Printer and Print Style Settings

Postscript Printing in UNIX

Printer Types Window

Printer Types Block

Printer Drivers Block

Printers Window

Printers Block

Print Styles Window

Print Styles Block

Layout Block

Printer Drivers Window

Printer Drivers Window Fields

Driver Method Region

Driver Method Parameters Region

Oracle E-Business Suite Help

Setting Oracle E-Business Suite Help Profile Options

Customizing Oracle E-Business Suite Help

Downloading and Uploading Help Files

Linking Help Files

Updating the Search Index

Customizing Help Navigation Trees

The Help Builder User Interface

Customizing Help in a Global Environment

Using Oracle Tutor

Oracle E-Business Suite DBA Duties

Overview of Oracle E-Business Suite DBA Duties

ORACLE Schemas

Registering an ORACLE Schema

Initialization Code

Resource Consumer Groups in Oracle E-Business Suite

Assigning Resource Consumer Groups

Hierarchy of Resource Consumer Group Assignments

Oracle E-Business Suite Password Management

FNDCPASS Utility

FNDCPASS Example

AFPASSWD Utility

AFPASSWD Usage

Using Case-Sensitive Database Passwords

ORACLE Users Window

ORACLE Users Block

Applications Window

Prerequisites

Applications Block

Network Test Window

Administering Folders

Query Optimization in Oracle E-Business Suite

Oracle E-Business Suite and Query Optimization

Gathering Statistics for the CBO

Gather Table Statistics

Backup Table Statistics

Restore Table Statistics

Gather Schema Statistics

Gather Column Statistics

Gather All Column Statistics

Purge FND_STATS History Records

FND_STATS Package

CREATE_STAT_TABLE Procedure

BACKUP_TABLE_STATS

BACKUP_SCHEMA_STATS Procedure

RESTORE_SCHEMA_STATS Procedure

RESTORE_TABLE_STATS Procedure

RESTORE_COLUMN_STATS Procedure

ENABLE_SCHEMA_MONITORING Procedure

DISABLE_SCHEMA_MONITORING Procedure

GATHER_SCHEMA_STATS Procedure

GATHER_INDEX_STATS Procedure

GATHER_TABLE_STATS Procedure

GATHER_COLUMN_STATS Procedure

GATHER_ALL_COLUMN_STATS Procedure

ANALYZE_ALL_COLUMNS Procedure

LOAD_XCLUD_STATS Procedure

PURGE_STAT_HISTORY Procedure

CHECK_HISTOGRAM_COLS Procedure

VERIFY_STATS Procedure

Oracle E-Business Suite and Oracle Real Application Clusters

Introduction to Oracle Real Application Clusters

Prerequisites

Migrating to Oracle RAC

Establishing the Oracle E-Business Suite Environment for Oracle RAC

Configuring Parallel Concurrent Processing with Oracle RAC

Document Sequences

What is a Document Sequence?

Defining a Document Sequence

Defining Document Categories

Assigning a Document Sequence

Document Numbering vs. Document Entry

Document Sequences Window

Document Sequences Block

Document Categories Window

Document Categories Block

Sequence Assignments Window

Sequence Assignments Block

Assignment Region

Document Flexfield

Logging

Overview

How to Configure Logging

Developer Tools

Web Enabled PL/SQL Window

PL/SQL Object Block

Portlet Generator

Integration with Application Development Framework

Administering Process Navigation

Overview of Process Navigation

What is Oracle Workflow?

What are Seeded Processes?

Modifying Your Menu

Creating Process Navigator Processes

Administering Globalization

Overview of Globalization Support

Language Values for User Sessions

Language Values for User Sessions using AppsLocalLogin.jsp

Language Value from Login External to Oracle E-Business Suite

Language Values for Oracle Workflow Notifications

Date Formats in NLS Implementations

Support for Calendars

Numeric Format Support

Multilingual External Documents

Translations Window

Currencies Window

Languages Window

Languages Record

Natural Languages Window

Natural Languages Record

Territories Window

Territories Block

Integration of Oracle E-Business Suite with Other Products

Integration of Oracle E-Business Suite with Other Products

Oracle Application Server with Oracle E-Business Suite

Introduction

Using Oracle Application Server 10

Loaders

Generic Loader

Overview

FNDLOAD Executable

Configuration File

Data File

Oracle Application Object Library Configuration Files

Attachments Setup Data Configuration File

Concurrent Program Configuration File

Flexfields Setup Data Configuration File

Flexfield Value Sets

Descriptive Flexfields

Key Flexfields

Folders Configuration File

Lookups Configuration File

Messages Configuration File

Profile Options and Profile Values Configuration File

Request Groups Configuration File

Security Information Configuration File

Message Dictionary Generator

Message Repositories

Usage

Generic File Manager Access Utility (FNDGFU)

Usage

Example of FNDGFU Upload

Purging Generic File Manager Data

Purge Obsolete Generic File Manager Data

Program Parameters

Functional Administrator and Functional Developer Tasks

Overview of Functional Administrator and Functional Developer Responsibilities

Oracle Self-Service Web Applications

Overview of Oracle Self-Service Web Applications (HTML-based Applications)

Oracle Self-Service Web Applications Architecture

Web Applications Dictionary Overview

Setting the Folder Mode

Web Applications Dictionary Tasks

Defining Objects

Assigning Attributes to Objects

Defining Attributes

Defining Unique Keys

Defining Foreign Keys

Defining Regions

Creating Region Items

Time Zone Support

User-Preferred Time Zones

Time Zone Concepts

Upgrade Considerations

Implementation Details

Controlling Access to the Oracle Forms-based Applications Diagnostics Menu

Controlling Access to the Oracle Forms-based Applications Diagnostics Menu

Index

Oracle E-Business Suite System Administrator's Guide - Configuration

Contents