Oracle E-Business Suite Flexfields Guide


Title and Copyright Information

Send Us Your Comments


Flexfield Concepts

Overview of Flexfield Concepts
      Key Flexfields
      Descriptive Flexfields
      Benefits of Flexfields
      Basic Flexfields Concepts
Overview of Setting Up Flexfields
      Data Entry and Ongoing Maintenance
Warning About Changing Data
Types of Flexfields Information

Planning and Defining Key Flexfields

Additional Terms and Concepts for Key Flexfields
      Intelligent Key
      Combinations Table
      Types of Key Flexfield Forms
      Dynamic Insertion
      Other Key Flexfield Features
Planning Your Key Flexfield
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
      Reporting Attributes Zone

Planning and Defining Descriptive Flexfields

Descriptive Flexfield Concepts
      How Segments Use Underlying Columns
Context Fields and Reference Fields
      Context Fields
      Using Value Sets With Context Fields
      Reference Fields
      Synchronizing the Context Field Value with the Reference Field Value
Different Arrangements of Segments
Planning Your Descriptive Flexfield
Descriptive Flexfield Segments Window
      Defining Descriptive Flexfields
      Defining Descriptive Flexfield Structures
      Context Field Values
Identifying Descriptive Flexfields in Oracle E-Business Suite

Values and Value Sets

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 with 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
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
Using Translatable Independent and Translatable Dependent Value Sets
      Limitations on Translatable Value Sets
      Converting Independent/Dependent Value Sets to Translatable Independent/Dependent Value Sets
Using Special and Pair Value Sets
Defaulting Flexfield Values
      Precedence of Default Values, Shorthand Entry Values, and COPY Values in Key Flexfields
Changing the Value Set of an Existing Flexfield Segment
Value Set Windows
      Overview of Value Set Windows
      Defining Value Sets
      Dependent Value Set Information Window
      Validation Table Information Window
      Special Validation Routines Window
      Value Set Usages
Segment Values Window
      Segment Values Block
      Defining Segment Values
      Defining Hierarchy and Qualifiers Information
      Hierarchy Details Buttons
      Define Child Ranges
      View Hierarchies
      Move Child Ranges
Rollup Groups Window
      Defining Rollup Groups

Using Additional Flexfield Features

Overview of Shorthand Flexfield Entry
      Enabling Shorthand Entry
      Defining Shorthand Aliases
      Disabling or Enabling a Shorthand Alias
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
Cross-Validation Rules Window
      Defining Cross-validation Rules
      Defining Cross-validation Rule Elements

Key Flexfields in Oracle E-Business Suite

Key Flexfields by Flexfield Name
Key Flexfields by Owning Application
Tables of Individual Key Flexfields in Oracle E-Business Suite
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

Standard Request Submission

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

Reporting on Flexfields Data

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
Examples of Flexfield Views
      Key Flexfield Views Examples
      Descriptive Flexfield View Example
Oracle Reports Flexfield Support API
      General Methodology
      Basic Implementation Steps
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

Key Flexfield Routines for Special Validation

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

Account Generator

Overview of the Account Generator
      Account Generator Process Diagram
      How the Account Generator Works
      Where the Account Generator Derives Segment Values
The Account Generator in Oracle E-Business Suite Products
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
Choosing the Process for a Flexfield Structure

Business View Generator

Business View Generator for Oracle Business Intelligence System