Re: Flex Fields

From: Keith <kshu_at_tusco.net>
Date: 1998/02/28
Message-ID: <01bd43f0$d2dc31e0$101bdece@tusco.net>#1/1

Within Oracle Financials (at least Gui 10.7) there are 2 types of Flexfields; Key and Descriptive.
Key FFs are unique 'keys' that can, for instance denote one natural account from another. An example of
a Key FF follows:

                        Key Flexfield
Company   Division      Cost Center   Natural Accout    Product Code
=======   ======     ========    ===========   ==========
    01            100             1200              3010                

123456

A key flexfield in Oracle General ledgers would look like the above example or like this on screen:
01.100.1200.3010.123456
the 01 can denote your company
the 100 could denote your U.S. Division
the 1200 could denote your Electricity Cost Center the 3010 could be an Expense account
and 123456 could be your product that you produce that you are distributing the
  electricity cost over.
Flexfields are:

1. Unique
2. Are stored in the General Ledger's gl_code_combinations table
3. Have value sets for each segment. You will define each of these segments and provide value sets for each one of these segments. All valid "code combinations" are stored in gl_code_combinations table. Oracle provides a Define Flexfields class that is usually available in most of there training facilities. Altanta has a good facility and so does Chicago. I hope that this gives a little picture of a flexfield. They are what drive the Oracle Financials Suite, so a course will help immensely. Keith kshu_at_tusco.net

Don <dhauri_at_stny.lrun.com> wrote in article <34F6BCA7.10F9CE94_at_stny.lrun.com>...
> Can someone explain to me what a flex field is and how to use it in my
> own database designs.
>
> Are there any articles available on this topic?
>
>
Received on Sat Feb 28 1998 - 00:00:00 CST