FLEXFIELDS,DFF,Removing existing DFF,Key Flex Fields

FLEX FIELDS

==========

 Flex field are made up with Attribute columns or Segment columns .

which are more flexible than the normal fields.

Flex fields are two types

1)DFF (Descriptive Flex Field)

2)KFF (Key Flex Field)

DFF:   It will be used to capture the Additional information from the end user  without change the code in the form and without Alter the DB object. ATTRIBUTE Columns will be used to Capture the DFF data.

           

Eg :

EMP Form(old )                     Emp Table

Emp No :                                 empno

Emp Name :                             ename

Sal       :                                   sal

Additional fields         

Project :

Designation :

Loc      :

                        [  ]   à called as flex fields

Additional fields will be stored into attribute columns ( attr1, attr2, …..attr15)

Data Type of attribute columns is varchar2

If DFF is available then need not down load the form and customize the form

Pre-Requisite to create DFF:

1) Application Name   2) Form Name

Purchasing Vision Operations ( USA ) à Items à Master Item à M1

Help à Diagnostics à Examine à Password : apps

                        Block : $DESCRIPTIVE_FLEXFIELD$

                        Filed : mtl_system_items.DF

                        Value : Items (Inventory)

                                    Here Item is a title

                                             Inventory  Application

Copy the Value = Items (Inventory) into some notepad

System Administrator à Application à Flex Fields à Descriptive à Segments à

Enter the Application : Inventory                     Title : Items

Query it ( ctrl + F11 )

Un Check Freeze Flex Field definition

Place the cursor at Global Data Elements  and Select Segments

Add the require

Number           Name               Window Prompt         Column           Value Set

50                    Company         Company                     Attribut4          100 Characters

Select Open and Check Required ( as desired )

Save the above

Check Freeze Flex Filed Definition à OK à Compile à OK àOK àWarning OK à

Close the form

Checking for DFF

Purchasing Vision Operations ( USA ) à Items à Master Item à M1

Removing existing DFF: ( Query with the following )

Enter the Application : Inventory                     Title : Items

Query it ( ctrl + F11 )

Un Check Freeze Flex Field definition

Place the cursor at Global Data Elements  and Select Segments

Uncheck the Displayed  and Enabled

Save the above

Check Freeze Flex Field definition  à OK à Compile à OK à Warning OK à

Key Flex Fields :

KFF: it will be used to Capture the Key information from the User in code language for every code there will be a  specific meaning. SEGMENT Columns will be used Capture the KFF Data

We can find all the flex field details in Application Developer Responsibility

General Ledger Vision Operations ( USA ) à Setup à Financialsà Flexfieldsà Keyà Segments

CTRL+F11 for all KFF

Down arrow key and select Application : General Ledger       Flexfiled Tiltle : Accounting Flexfield

Create New Flex Filed ( + )

Un Check  Freeze Flexfiled Definition

Select Period ( - )   à Select Segments

Save the above

Place the cursor in the first line COMPANIES

Select   Flexfiled Qualifier

COMPANIES : Intercompany Segment  ( Check )

BRANCHES : Balancing Segment ( Check )

ACCOUNTS : Natural Account Segment

Save the above  and close form

Check Freeze Flexfield Definition à OK à Compile à OK à OK

]Creating Values for the above flex fields

General Ledger Vision Operations ( USA ) à Setup à Financialsà Flexfieldsà Keyà Values

Enter the Structure : LGS_INDIA_KFF

Select Find as shown below