Previous	Next		Index	Navigation	Glossary	Library

User, System Administrator, and Flexfields Help (11/19/97)

• User, System Administrator, and Flexfields Help

• Users Window
• Responsibilities Window
• Menus Window
• Form Functions Window

• Monitor Users Window
• Audit Windows

• System Profiles Window

• Request Groups Window
• Data Groups Window
• Concurrent Programs Windows

• Concurrent Manager Windows
• Concurrent Request Types Window

• Printer Types Window
• Printers Window
• Print Styles Window
• Printer Drivers Window

• ORACLE Users Window
• Concurrent Conflicts Domains Window
• Applications Window

• Administering Folders Windows

• Document Sequences Windows

• Currencies Window

• Oracle System Administration
• Managing Oracle Applications Security
• Product Specific Function Lists
• Security Reports
• User and Data Auditing
• Oracle Applications Help
• Applications DBA Duties
• Managing Concurrent Programs and Requests
• Organizing Programs into Request Sets
• Defining Program Incompatibility Rules
• Defining Data Groups
• Copying and Modifying Program Definitions
• Printers
• User Profiles
• Managing Concurrent Processing
• Reviewing Requests, Request Log Files, and Report Output Files
• Defining Managers and their Work Shifts
• Specializing Managers to run only certain programs
• Document Sequences
• Alert
• Loaders
• Overview of Standard Request Submission
• Getting Started and Using Oracle Applications
• Reports

• Windows

• What Is System Administration?
  • System vs. Database Administrator

• Overview of Oracle Applications Security
• Defining a Responsibility
  • Additional Notes About Responsibilities
• Defining a Request Security Group

• Responsibilities Window
  • Responsibilities Block
  • Function and Menu Exclusions Block
  • Self-Service Applications Security

• Users Window
  • Users Block
  • Responsibilities Block
  • Securing Attributes

• Users of a Responsibility Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Active Responsibilities Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Active Users Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Reports and Sets by Responsibility Report
  • Report Parameters
  • Report Headings

• Overview of Function Security
  • Terms
  • Forms and Subfunctions
  • Functions, Menus, and the Navigate Window
  • How Function Security Works

• Implementing Function Security
  • Defining a New Menu Structure
  • Notes About Defining Menus
  • Preserving Custom Menus Across Upgrades
  • Special Function for Oracle HRMS, Oracle Sales and Marketing
  • Summary of Function Security

• Form Functions Window
  • Form Functions Block

• Menus Window
  • Menus Block
  • Menu Entries Block

• Function Security Reports
• Menu Report
  • Report Parameters
  • Report Heading
  • Column Headings

• Overview of User and Data Auditing
  • Auditing User Activity
  • Auditing Database Row Changes

• Auditing User Activity
  • Major Features
  • Setting Up Sign-On Audit
  • Using the Application Monitor
  • About This Record Window
  • Notifying of Unsuccessful Logins
  • Sign-On Audit Reports

• Prerequisites
• Monitor Users Block

• Signon Audit Concurrent Requests Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Signon Audit Forms Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Signon Audit Responsibilities Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Signon Audit Unsuccessful Logins Report
  • Report Parameters
  • Report Heading
  • Column Headings
• Signon Audit Users Report
  • Report Parameters
  • Report Heading
  • Column Headings

• Reporting On AuditTrail Data
  • AuditTrail
  • Setting Up Release 11 AuditTrail
  • Audit Trail Update Tables Report
  • Release 11 AuditTrail Tables, Triggers and Views
  • Changing Your Audit Tables
  • Reporting on Audit Information
  • Disabling AuditTrail and Archiving Audit Data

• Audit Installations Window
  • Audit Installations Block

• Audit Groups Window
  • Audit Groups Block
  • Audit Tables Block

• Audit Tables Window
  • Define Audit Tables Block
  • Audit Columns Block

• Overview of Oracle Applications Help for HTML
  • Help File Architecture
  • Customizing Oracle Applications Help
  • Help Targets in Oracle Applications

• Overview of Setting User Profiles
  • Major Features
  • Setting User Profile Options
  • Using Profile Options as a Parameter or Segment Default Value
  • Examples of User Profile Options
• User Profile Option Values Report
  • Report Parameters
  • Report Headings

• System Profile Values Window
  • Profile Values Block
  • Find System Profile Values Block

• Overview of Concurrent Programs and Requests

• 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 using Codes
  • Customizing the Submit Requests Window
• Report Group Responsibilities Report
  • Report Parameters

• Defining Program Incompatibility Rules
  • Incompatible and Run Alone Programs
  • Concurrent Conflicts Domains
  • Enforcing Incompatibility Rules

• Defining Data Groups
  • Introduction to Data Groups
  • Using Data Groups
  • Modifying Data Groups

• 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
• 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
  • Incompatible Programs Window
  • Concurrent Program Parameters Window

• Data Groups Window
  • Data Groups Block
  • Application-ORACLE Username Pairs Block

• Overview of Concurrent Processing
  • Concurrent Requests, Programs, and Processes
  • Life cycle of a concurrent request

• How To View Request Status and Output
• How to Modify Request Diagnostic Output
• Setting End User Report and Log File Access Privileges
• Enabling the Report Review Agent
• Defining the Reports Viewer
• Types of Log Files
• Operating System Access to Report Output Files

• Changing the Status of Concurrent Requests
  • Changing a Request's Phase and Status
  • Changing the Priority of a Pending or Inactive request

• Managing Concurrent Processing Files and Tables
  • Maintenance Suggestions
• Purge Concurrent Request and/or Manager Data Program
  • Report Options

• Concurrent Processing User Profile Settings

• Defining Managers and their Work Shifts
  • Work Shift Definitions
  • Using Work Shifts to Balance Processing Workload
  • Using Time-Based Queues
• 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
  • Database Instances, Manager Location, and File Distribution
  • Examples of Parallel Concurrent Processing
  • Parallel Concurrent Processing - Single Database Instance with
  • Parallel Concurrent Processing - Oracle Parallel Server with
  • Parallel Concurrent Processing - Single Database Instance
  • Parallel Concurrent Processing - Node 1 acts as Database Server,
  • Installing Parallel Concurrent Processing

• Administer Concurrent Managers Window
  • Administer Concurrent Managers Block
  • Concurrent Processes Window
  • 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

• Nodes Window
  • Nodes Block

• Overview of Printers and Printing
  • Executive Summary
  • Oracle Reports and Applications Printing
  • Printer Types, Print Styles, and Printer Drivers
  • Sequence of Printing Events
  • Setting Character-Mode vs. Bitmap Printing
  • Defining Printer Types and Registering Printers
  • Print Styles
  • Printer Drivers

• Setting Up Your Printers
  • Printing Setup Interrelationships
  • Printer Setup Information Is Cached On Demand

• Customizing Printing Support in Oracle Applications
  • Creating Custom Printer Drivers
  • Using Initialization and Reset Strings
  • Using a Spool File
  • Creating Custom SRW Drivers

• Postscript Printing in UNIX
  • Example - Using Enscript to Print Postscript

• 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

• Printer Types Window
  • Printer Types Block
  • Printer Drivers Block

• Printers Window
  • Printers Block

• Print Styles Window
  • Print Styles Block

• Printer Drivers Window
  • Printer Drivers Block

• Overview of Applications DBA Duties
  • ORACLE Usernames
  • Registering an ORACLE username

• ORACLE Users Window
  • Prerequisites
  • ORACLE Users Block

• Concurrent Conflicts Domains Window

• Applications Window
  • Prerequisites
  • Applications Block

• Network Test Window

• Administering Folders

• Languages Window
  • Languages Block

• Territories Window
  • Territories Block

• 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
  • Access Block

• Document Categories Window
  • Document Categories Block

• Sequence Assignments Window
  • Sequence Assignments Block

• Zoom and Customizing Oracle Applications
• Customizing Oracle Applications with the CUSTOM Library
  • Writing Code for the CUSTOM Library
  • Events Passed to the CUSTOM Library
  • When to Use the CUSTOM Library
  • Coding Zoom
  • Support and Upgrading
• CUSTOM Package
  • CUSTOM.ZOOM_AVAILABLE
  • CUSTOM.STYLE
  • CUSTOM.EVENT
• Example of Implementing Zoom Using the CUSTOM Library
  • Modify the Form
  • Modify the CUSTOM Library

• Profile Options in Oracle Application Object Library

• Message Dictionary Generator
  • Message Repositories
  • Examples of Message Dictionary Generator Usage
  • Script File Format
• Function Security Loader
  • Supported Operations
  • Function Security File Format
  • Sample Function Security File

• User Profile Loader
  • Supported Operations
  • Profile File Format
  • Sample Profile File

• User Profile Value Loader
  • Supported Operations
  • Profile Value File Format
  • Sample Profile Value File

• Overview of Oracle Alert
  • Basic Business Needs
  • Oracle Alert Runtime Features
  • Alert Definitions
• Predefined Alerts
  • Using Predefined Alerts
  • Customizing Predefined Alerts
• Oracle Alert Precoded Alerts
  • Terms
  • Oracle Alert DBA Alerts
  • Applications DBA Alerts Descriptions
  • Oracle Alert Purging Alerts
  • Oracle Alert Purging Alerts Descriptions
  • Oracle Alert Purge Mail Alert
  • Oracle Alert Purge Mail Alert Description

• Setting Up Oracle Applications System Administrator
  • Setup Checklist
  • Setup Flowchart
  • Setup Steps

• Oracle Applications^TM System Administrator's Character Mode Forms and Corresponding GUI Windows

• Using Oracle Applications
• Getting Started
• Oracle Applications User Interface Basics
• Entering and Querying Data
• Customizing the Presentation of Data
• Using Flexfields
• Running Oracle Applications Reports and Programs
• Monitoring Oracle Applications Reports and Programs
• Working with Attachments
• Using User Profiles
• Oracle Applications Common Windows
• Oracle Applications from Character to GUI
• Oracle Applications Reports and Processes
• Oracle Workflow Concurrent Programs

• Personal Profile Values Window
• Product Specific Profile Options

• Request Set Windows

• Submit Request Window
• Schedule
• Upon Completion
• Submit Request Set Window

• Requests Window Window

• Navigate Window

• Signon Window

• Attachments Windows
• Defining Product Specific Documents

• Oracle Applications Wizards

• Overview of Oracle Applications
  • Basic Business Needs
  • Basic GUI Terminology
• Starting Oracle Applications
  • Starting and Logging On
  • Choosing a Responsibility
  • Opening a Form from the Navigate Window
  • Using the Navigator's Functions Region
  • Using the Top Ten List
  • Using the Navigator's Documents Region
  • Changing Your Security Access
• Using Menus
• Using Keyboard Shortcuts
• Getting Help
• Exiting Oracle Applications

• Oracle Applications User Interface
  • Screen
  • Window
  • Window Title
  • Oracle Applications Window
  • Modal Window
  • Form
  • Block
  • Field
  • Region
  • Record
  • Current Record Indicator
  • Message Line
  • Status Line
  • Toolbar
  • Alternative Regions
  • Master-detail Relations
  • Drill Down Indicators
  • Combination Blocks
• Navigating in Oracle Applications
  • Navigating Within a Window
  • Navigating Between Windows
  • Navigating Within a Combination Block
  • Navigating to Another Form
  • Navigating to a Custom-Defined Form
• Using Window Functions
  • Refreshing a Window
  • Printing a Window
  • Saving Your Work
  • Closing a Form
• Interpreting Messages
• Linked Forms

• Using Editing Functions
  • Cutting, Copying, and Pasting Text in a Field
  • Clearing Data
  • Duplicating Data From a Previous Record
  • Creating and Deleting Records
  • Creating Translations for a Record
  • Invoking an Editor for a Field
  • Learning About a Record
• Using a List of Values
  • Basic Business Needs
  • Major List Features
  • Choosing a Value from a List
  • Modifying a List
• Using the Calendar to Enter Dates
  • Basic Business Needs
  • Using the Calendar Window
• Searching for Information
  • Basic Business Needs
  • Using Query Find
  • Performing Query-by-Example and Query Count
  • Reviewing Records
  • Using a Direct Entry Window to Retrieve a Record
  • Selecting Multiple Records

• Customizing the Presentation of Data in a Folder
  • Basic Business Needs
  • Using Folder Tools
  • Querying Records in a Folder
  • Customizing the Layout of a Folder
  • Managing Folder Definitions

• Overview of Flexfields
  • Basic Business Needs
  • Definitions
  • Major Features
• Entering Data into Flexfields
  • Entering Data in a Descriptive Flexfield Window
  • Entering Data Directly in a Key Flexfield
  • Data Entry in a Key Flexfield Window
  • Using Shorthand Aliases in a Key Flexfield
  • Entering Data in a Range Flexfield
• Searching for Data Using Flexfield Criteria

• Overview of Reports and Programs
  • Overview of Concurrent Processing
  • Overview of Standard Request Submission
  • Basic Business Needs
  • Definitions
  • Major Features
• Concurrent Processing Options
• Using Standard Request Submission
  • Submitting a Request
  • Rerun a Prior Request
  • Submitting a Request Set
  • Defining Request Sets
  • Who Can Use a Request Set

• Viewing Requests
  • Using the Requests Window
• Viewing Request Output and Log Files
• Monitoring Requests
  • Concurrent Request Phase and Status
  • Cancelling Requests
  • Changing Request Options

• About Attachments
  • Attachments Window
  • Adding an Attachment
  • Viewing an Attached Document
  • Deleting an Attachment
  • Copying an Attachment from Another Record

• Overview of User Profiles
  • Basic Business Needs
  • Major Features
  • Definitions
  • Determining User Profile Option Values
• Setting Your Personal User Profile

• Common User Profile Options

• Oracle Applications Main Menu Bar

• Advantages of 11
  • New Features of the Graphical User Interface (GUI)
  • Character Mode menus - GUI-Equivalents
  • Architectual Changes
  • Behavioral Differences
  • Default Key Mappings in GUI

• GLOSSARY

• Warning About Changing Data
• Types of Flexfields Information
• Overview of Flexfield Concepts
  • Key Flexfields
  • Descriptive Flexfields
  • Benefits of Flexfields
  • Basic Flexfields Concepts

• Overview of Setting Up Flexfields
  • Planning
  • Defining
  • Data Entry and Ongoing Maintenance
  • Reporting

• Intelligent Key
• Combination
• Combinations Table
• Qualifiers
• Types of Key Flexfield Forms
• Dynamic Insertion
• Other Key Flexfield Features
• Planning Your Key Flexfield
  • Key Flexfield Structure Planning Diagram
• Key Flexfield Segments Window
  • Defining Key Flexfields
  • Defining Key Flexfield Structures
  • Defining Segments
  • Choosing Your Value Set
  • Defaulting Segment Values
  • Segment Prompts and Display Lengths
  • Flexfield Qualifiers
  • Reporting Attributes Zone

• Descriptive Flexfield Concepts
  • How Segments Use Underlying Columns
  • Reference Fields
• Different Arrangements of Segments
• Planning Your Descriptive Flexfield
  • Descriptive Flexfield Structure Planning Diagrams
• Descriptive Flexfield Segments Window
  • Defining Descriptive Flexfields
  • Defining Descriptive Flexfield Structures
  • Context Field Values

• Identifying Descriptive Flexfields in Oracle Applications
  • Identifying Descriptive Flexfields

• Overview of Values and Value Sets
  • Planning Values and Value Sets
  • Choosing Value Formats
  • Value Formats
  • Decide What Your User Needs
  • Choosing a Validation Type for Your Value Set
  • Plan Values to Use Range Features
  • Value Set Naming Conventions
  • Predefined Value Sets
  • Defining Values and Value Sets
  • Relationship Between Independent and Dependent Values
  • Parent and Child Values and Rollup Groups
• Rollup Groups Window
  • Defining Rollup Groups
• Overview of Implementing Table-Validated Value Sets
  • Using Validation Tables
  • Defining Your Validation Table
  • Creating Grants and Synonyms for Your Table
  • WHERE Clauses and Bind Variables for Validation Tables
  • Bind Variables
  • Example of $FLEX$ Syntax
  • Precedence of Default Values, Shorthand Entry Values,
• Changing the Value Set of an Existing Flexfield Segment
• Using Special and Pair Value Sets

• Value Set Windows
  • Defining Value Sets
  • Dependent Value Set Information Window
  • Validation Table Information Window
  • Special Validation Routines Window

• Segment Values Block
• Defining Segment Values
• Defining Hierarchy and Qualifiers Information
• Qualifiers
• Hierarchy Details Buttons
• Define Child Ranges
• View Hierarchies
• Move Child Ranges

• Overview of Shorthand Flexfield Entry
  • Enabling Shorthand Entry
  • Defining Shorthand Aliases
  • Disabling or Enabling a Shorthand Alias
• Shorthand Aliases Window

• Overview of Flexfield Value Security
  • Effects of Flexfield Value Security
  • Understanding Flexfield Value Security
  • Activating Flexfield Value Security
• Define Security Rules Window and Assign Security Rules Window
  • Defining Security Rules
  • Defining Security Rule Elements
  • Assigning Security Rules

• Cross-Validation Rules
  • How Cross-Validation Works
  • Designing Your Cross-Validation Rules
  • Maintaining Your Cross-Validation Rules and Valid Combinations
  • Reports
• Cross-Validation Rules Window
  • Defining Cross-validation Rules
  • Defining Cross-validation Rule Elements

• Key Flexfields by Flexfield Name
• Key Flexfields by Owning Application

• Tables of Individual Key Flexfields in Oracle Applications
• Account Aliases
• Accounting Flexfield
• Asset Key Flexfield
• Bank Details KeyFlexField
• Category Flexfield
• Cost Allocation Flexfield
• Grade Flexfield
• Item Catalogs
• Item Categories
• Job Flexfield
• Location Flexfield
• People Group Flexfield
• Personal Analysis Flexfield
• Position Flexfield
• Sales Orders
• Sales Tax Location Flexfield
• Oracle Service Item Flexfield
• Soft Coded KeyFlexfield
• Stock Locators
• System Items (Item Flexfield)
• Territory Flexfield

• Overview of Flexfields and Standard Request Submission
  • Planning Your Report Parameters
  • Using Flexfield Information in Your Report Parameters
  • Report Parameter Window Planning Diagrams

• Overview of Reporting on Flexfields Data

• Overview of Flexfield Views
  • Key Flexfield Concatenated Segment View
  • Key Flexfield Structure View
  • Descriptive Flexfield View
  • Creating a Flexfield View
  • Segment Naming Conventions
  • Using Flexfield Views to Write a Report
  • Key Flexfield Views Examples
  • Descriptive Flexfield View Example

• Oracle Reports 2.5 Flexfield Support API
  • General Methodology
  • Basic Implementation Steps
  • FND FLEXSQL
  • FND FLEXIDVAL

• Oracle Reports and Flexfields Report-Writing Steps
• Flexfield Report Examples
  • Report 1: Simple Tabular Report
  • Report 2: Simple Tabular Report With Multiple Structures
  • Report 3: Tabular Report
  • Report 4: Master-Detail Report
  • Report 5: Master-detail Report on Multiple Structures

• Syntax for Key Flexfield Routines

• Special Validation Value Sets
• Special Validation Events
• Defining Your Special Validation Function
• Example of Special Validation
• Example of Special Validation for a Single Segment
• Example of Pair Validation
• Using Variables with Special and Pair Validation

• Overview of the Account Generator
  • Terms
  • Account Generator Process Diagram
  • How the Account Generator Works
  • Where the Account Generator Derives Segment Values
• The Account Generator in Oracle Applications
• Overview of Implementing the Account Generator

• Customizing the Account Generator
  • Determine Characteristics of Combination
  • Decide From Where Each Segment Derives Its Value
  • Modify Your Account Generator Process
• Test Your Account Generator Setup

• Standard Flexfield Workflow

• Converting from FlexBuilder

• Choosing the Process for a Flexfield Structure

• Sequences
  • Prerequisites
  • Sequences Block

• Tables
  • Prerequisites
  • Tables Block
  • Detail Buttons
  • Table Columns Block
  • Indexes Window
  • Primary Keys Window
  • Foreign Keys Window

• Views
  • Prerequisites
  • Views Block
  • Columns Block

• Concurrent Program Libraries Window
  • Prerequisites
  • Concurrent Program Libraries Block
  • Concurrent Programs Block
  • Rebuild Library

• Register Descriptive Flexfields
  • Register Descriptive Flexfields Block
  • Reference Fields Window
  • Columns Window

• Register Key Flexfields
  • Register Key Flexfields Block
  • Qualifiers Window
  • Columns Window

• Forms Window
  • Prerequisites
  • Forms Block

• QuickCodes
  • QuickCodes Block
  • QuickCode Values Block

• Lookups
  • Lookups Block
  • Lookups Values Block

• Messages Window
  • Prerequisites
  • Messages Block

• Profiles Window
  • Prerequisites
  • Profiles Block

• Flexfields
• Overview of Flexfields and Flexfield Concepts
• Key Flexfields
• Key Flexfields Concepts
• Descriptive Flexfields
• Reporting on Flexfields Data
• Flexfields and Standard Request Submission
• Flexfield Views
• Oracle Reports 2.5 Flexfield Support API
• Values and Value Sets
• Implementing Validation Tables for Table Validated Value Sets
• Key Flexfields in Oracle Applications
• Flexfield Windows
• Special Validation Value Sets
• Account Generator

• Reviewing Notifications in the Notification Viewer

• Starting the Oracle Workflow Notification Mailer

• Running the Workflow Definitions Loader

• Running the Workflow Resource Generator

• Scheduling Workflow Background Engines

• Workflow Status Form