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

Post a Comment