Oracle Applications

Oracle for Beginners

Key Flexfields

Posted by shameemakhtar on June 23, 2009

Platform: 11.5.10, R12

Key Flexfield Architecture

Key Flexfield is a very important concept in Oracle. It allows you to define Key Structures in each Module. This gives you the flexibility to model your objects according to your requirements. Some examples of flexfields are as follow:

Accounting Flexfield in General Ledger.

Job, Position and Grade Key Flexfield in Human Resources.

Key Flexfield Architecture

Key Flexfield Architecture

A flexfield is a structure that you define for a Flexfield Title. The Flexfield Structures are registered within an application.

A structure will compose of one or more segments. Each segment will be attached to a value set which you would have defined. If required you will qualify the segment in question.

Define Key Flexfield Structure

System Administrator –> Flexfield –> Segments

Note: KFFs are accessible from other Modules as well.

Key Flexfield Segments

Key Flexfield Segments

Query for the Key Flexfield in question. As an example I have queried the ‘Training Resources’ KFF.

Training Resources KFF

Training Resources KFF

Add your structure, then click on ‘Segments’ to define the segments.

Segments Summary

Segments Summary

Click on ‘Value Set’. Define your value set. The Value Set determines what values will be available for the segment in question. Specify the ‘Value Validation’.  Save the value set, close the form and attach it to the segment as shown above.

We have various ways of validating the values.

(Detailed document to follow on Value Sets)

Define Value Sets

Define Value Sets

Define Value Sets

In this case, the validation is based on a table. Click on ‘Edit Information’ to define it.

Validation Table Information

Validation Table Information

When you are done, click on ‘Open’ on the ‘Segment Summary’ Form. Specify whether it is required. By default all segments are marked as required.

Segments

Segments

Flexfield Qualifiers

Click on ‘Flexfield Qualifiers’ to qualify the segment. This is not valid for all Key Flexfields. Accounting Flexfield has Flexfield Qualifiers and is illustrated below.

Flexfield Qualifiers

Flexfield Qualifiers

Once you are done with all the segments close the ‘Segments Summary’ Form to return to the ‘Key Flexfield Segments’ window.

Compile Key Flexfield Structure

Compile KFF

Compile KFF

To be able to use the KFF, you need to freeze the structure. To freeze the structure, check the ‘Freeze Flexfield Definition’ and click on ‘Compile’. A request is launched to compile the structure. The structure is now available in your application.

Note: The ‘Allow Dynamic Inserts’ checkbox enables KFF values to be generated while using the application. If you don’t allow dynamic insert, then you need to define all the valid value combinations for your structure before you can use these values in your application.

Shameem Bauccha

24 June 2009

Advertisements

9 Responses to “Key Flexfields”

  1. […] Key Flexfields […]

  2. FIFA 12 said

    Battlefield 3…

    […]Key Flexfields « Oracle Applications[…]…

  3. Discount Office 2010 Product Key…

    […]Key Flexfields « Oracle Applications[…]…

  4. Office 2010 Serial Key…

    […]Key Flexfields « Oracle Applications[…]…

  5. Hey! I could have sworn I’ve been to this site before but after checking through some of the post I realized it’s new to me.
    Anyways, I’m definitely happy I found it and I’ll be bookmarking and checking
    back frequently!

  6. Way cool! Some extremely valid points! I appreciate you
    writing this post plus the rest of the website
    is also really good.

  7. I read this post completely concerning the comparison of
    latest and preceding technologies, it’s awesome article.

  8. I got this website from my buddy who told me regarding this web
    site and at the moment this time I am browsing
    this web site and reading very informative articles at this time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s