Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Oracle Apps Flex fields

By Exforsys | on June 25, 2005 |
Oracle Apps

Oracle Apps 11i Tutorials : Oracle Flex fields

This chapter provides you with a conceptual overview of flexfields. The chapter covers the following topics The general features of flexfields, Flexfields terminology , The benefits of flexfields and Descriptive Flexfields.

Overview of Flexfields

Oracle flexfields is one of the most important parts of Oracle Applications. It is because of the flexfields that the Oracle Applications is so generic in nature and can be used to suit any industry or organization. A flexfield, as the name suggests, is a flexible data field that your organization can customize to your business needs without programming. A flexfield is a field made up of sub–fields, or segments. While flexfields do not require programming, they do allow you to perform significant customizations to the Oracle Applications, so they do require enough explanation for you to get the most out of the features they provide.

Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is a field you can customize to enter multi–segment values such as part numbers, account numbers, and so on. A descriptive flexfield is a field you customize to enter additional information for which your Oracle Applications product has not already provided a field.

Basic Business Needs

Oracle Applications flexfields let you satisfy the following business needs:

  • Have “intelligent fields”—fields comprised of one or more segments, where each segment has both a value and a meaning.
  • Rely upon your application to validate the values or the combination of values that you enter in intelligent fields.
  • Have the structure of an intelligent field change depending on data in your application.
  • Capture additional information if you so choose.
  • Customize data fields to your meet your business needs without programming.
  • Query intelligent fields for very specific information.

Key Flexfields

key flexfield is a field made up of segments, where each segment has both a value and a meaning. You can think of a key flexfield as an “intelligent” field that your business can use to store information represented as “codes.”

Most organizations use ”codes” made up of meaningful segments to identify general ledger accounts, part numbers, and other business entities. Each segment of the code can represent a characteristic of the entity. For example, consider an account number for a bank. A complete bank number may consists of various segments like the country code, area code, city code, branch code, account type, account number etc.

Bank Number : [01].[002].[08].[S].[124467]


Country Code City Code Branch Code Account Type(Savings/Current) Account #

 

 

 

The number of segments a bank requires to identify an account number uniquely is a requirement specific to the bank. Another bank might not require a country code if its presence is there only in one country. Key flexfields are used to identify such information uniquely.

A key flexfield is flexible enough to let you use any code scheme you want to describe an entity. When your organization initially installs an Oracle Applications product, your organization’s implementation team customizes all the key flexfields in that product to use meaningful code segments to describe each key flexfield entity. Your organization decides for each key flexfield, how many segments an entity has, what each segment means, what values each segment can have, and what each segment value means.

Your organization can also define rules that govern what combination of segment values are valid (cross–validation rules), or define dependencies among the segments. The result is that your organization can use the codes it needs rather than change its codes to meet someone else’s requirements.

The Accounting Flexfield in your Oracle Purchasing application is an example of a key flexfield that identifies a unique chart of accounts. One organization may choose to customize the Accounting Flexfield to have three segments called Company, Department, and Account, while another organization may choose to customize the flexfield to have five segments called Company, Cost Center, Account, Sub–Account, and Product.

A key flexfield appears on your form as a normal text field with an appropriate prompt. In figure 1 below, the Account field is actually the Accounting Key Flexfield.

Figure 1. Key Flexfield in a form

A window pops-up when you navigate to the key flexfield as shown in figure 2 and it would require you to enter the various segments defined for the key flexfield.

Figure 2. Key Flexfield Pop-up

Key Flexfields in Oracle Applications

The Oracle Applications products provide many key flexfields as integral parts of the products.

Here is a table listing all the key flexfields in Oracle Applications, ordered by the application that ”owns” the key flexfield. Note that other applications may also use a particular flexfield

Owner

Key Flexfield Name

Flexfield Code

Oracle Assets

Asset Key Flexfield

KEY#

Oracle Assets

Category Flexfield

CAT#

Oracle Assets

Location Flexfield

LOC#

Oracle General Ledger

Accounting Flexfield

GL#

Oracle Human Resources

Grade Flexfield

GRD

Oracle Human Resources

Job Flexfield

JOB

Oracle Human Resources

Personal Analysis Flexfield

PEA

Oracle Human Resources

Position Flexfield

POS

Oracle Human Resources

Soft Coded KeyFlexfield

SCL

Oracle Inventory

Account Aliases

MDSP

Oracle Inventory

Item Catalogs

MICG

Oracle Inventory

Item Categories

MCAT

Oracle Inventory

SalesOrders

RLOC

Oracle Inventory

Stock Locators

MTLL

Oracle Inventory

System Items

MSTK

Oracle Payroll

Bank Details KeyFlexField

BANK

Oracle Payroll

Cost Allocation Flexfield

COST

Oracle Payroll

People Group Flexfield

GRP

Oracle Receivables

Sales Tax Location Flexfield

MKTS

Oracle Receivables

Territory Flexfield

CT#

Oracle Service

Oracle Service Item Flexfield

SERV

Oracle Training Administration

Training Resources

RES


}

Descriptive Flexfields

Descriptive flexfields like the key flexfields provides further scope of customization in Oracle Applications.

Descriptive flexfields provide customizable ”expansion space” on your forms. Though the fields on an Oracle Applications form are more than enough to capture all the possible information from the user perspective, but still the users can feel the need of capturing additional information. A descriptive flexfield gives you room to expand your forms for capturing such additional information.

A descriptive flexfield appears on a form as a single–character, unnamed field enclosed in brackets ([ ]) as shown in figure 3 below.

Figure 3. Descriptive Flexfield on a form

Oracle Applications has provided space for descriptive flexfields on almost all the forms. Just like in a key flexfield, a pop–up window appears when you move your cursor into a customized descriptive flexfield. And like a key flexfield, the pop–up window has as many fields as your organization needs. Each field or segment in a descriptive flexfield has a prompt (figure 4), just like ordinary fields, and can have a set of valid values. The pop-up as shown in the figure 4 comes up when you click on the [ ] icon on the form in the figure3 above.

Figure 4. Popup for Descriptive Flexfield on a form

Further details about implementation and other features are provided in the implementation section later in the chapter.

« « Dialog Boxes in Visual Basic .NET
Oracle Apps Implementing Key Flex field and Descriptive Flex field » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 391 Followers
  • Popular
  • Recent
  • Oracle Apps 11i : Asset Management – Manual and Quick Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i Installation – System Requirements

    May 22, 2005 - 0 Comment
  • Special Triggers in the Template Form in Oracle Apps 11i

    July 3, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i – Using Rapid install and the Steps Before Apps Installation

    May 24, 2005 - 0 Comment
  • Oracle Apps 11i: Setting up Chart Of Accounts (COA)

    August 14, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Adjustments

    October 12, 2005 - 0 Comment
  • Single Node and Multi Node Installation Part 1

    May 28, 2005 - 0 Comment
  • Creating New Forms in Oracle Apps 11i

    July 17, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Transfers

    October 12, 2005 - 0 Comment
  • Oracle Reports 6i

    December 13, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Journal Entries

    October 16, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Retirements

    October 16, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Depreciation

    October 13, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Transfers

    October 12, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Adjustments

    October 12, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Mass Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Manual and Quick Additions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Books Regions

    October 9, 2005 - 0 Comment
  • Oracle Apps 11i : Asset Management – Asset Book Positioning

    October 9, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Oracle Reports 6i
  • Oracle Apps 11i : Asset Management – Journal Entries
  • Oracle Apps 11i : Asset Management – Retirements
  • Oracle Apps 11i : Asset Management – Depreciation
  • Oracle Apps 11i : Asset Management – Mass Transfers

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT