Oracle E-Business Suite Flexfields Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Flexfield Concepts

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

Warning About Changing Data

Types of Flexfields Information

Planning and Defining Key Flexfields

Additional Terms and Concepts for Key Flexfields

Intelligent Key

Combination

Combinations Table

Qualifiers

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

Implementation

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

Qualifiers

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

Reports

Cross-Validation Rules Window

Defining Cross-validation Rules

Defining Cross-validation Rule Elements

Key Flexfields in Oracle E-Business Suite

Overview

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

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

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

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

Terms

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

Index

Oracle E-Business Suite Flexfields Guide

Contents