April 18, 2013

Interview Q & A -1: FlexFields

bishnupc / /

FLEX FIELD

What is the difference between key flexfield and Descriptive flexfield?

Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number, a cost centre etc
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.
And one more differenct that KFF displays like text item but DFF displays like [ ] .

Which procedure should be called to enable a DFF in a form?
FND_DESCR_FLEX.DEFINE
(BLOCK                                 => 'BLOCK_NAME'
                ,FIELD                                    => 'FORM_FIELD_NAME'
               ,APPL_SHORT_NAME      => 'APP_NAME'
               ,DESC_FLEX_NAME         => 'DFF_NAME'
               );

In Brief,
We need to follow the following steps in your form:
a) Create a displayed field to hold your concatenated segment values (the [ ] field).
b) Create fields (normally hidden) for each of the flexfield columns in your table (the
      one used for your flex).
c) In the form-level WHEN-NEW-FORM-INSTANCE,
call FND_DESCR_FLEX.DEFINE,
setting BLOCK parameter to the name of the block containing your [ ] field,
the FIELD parameter to the name of your [ ] field,
the APPL_SHORT_NAME parameter to the short name of your application and the DESC_FLEX_NAME parameter to the name of your descriptive flex.

In the form-level WHEN-NEW-ITEM-INSTANCE,
WHEN-VALIDATE-ITEM,
PRE-INSERT,
PRE-UPDATE,
POST-QUERY and
PRE-QUERY triggers place a call to FND_FLEX.EVENT as follows:
         FND_FLEX.EVENT ( 'TRIGGER_NAME');
where TRIGGER_NAME is the name of the trigger,
e.g. in the PRE-QUERY trigger .... FND_FLEX.EVENT('PRE-QUERY');
Which procedure should be used to make the DFF read only at run time?
FND_DESCR_FLEX.UPDATE_DEFINITION()

What is the difference between flexfield qualifier and segment qualifier?
Flexfiled qualifier identifies segement in a flexfield and segment qualifier identifies value in a segment.
There are four types of flexfiled qualifier
1)     Balancing segment qualifier
2)     cost center
3)     natural account and
4)     intercompnay
segemtn qualifier :-
1)     allow budgeting
2)     allow posting
3)     account type
4)     contral account and
5)     reconciliation flag

What are the components of DFF (like structure, segment)?
Howmany Key flexfiels are there in Inventory?
What is Value Set?
Value Sets define and store the valid items of data, which may be entered into a field. Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets. Oracle already comes with hundreds of Value Sets. We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose). In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set. Data in a Value Set can be of several types: 
  •  Independently loaded into a Value Set (through a standard form). 
  •  Resident in a table (to which we direct the Value Set definition). 
  •  There could be No Validation (any data can go into the field, but still subject to the formatting rules.) 
  •  Dependent on the value of data in a preceding Independent segment (loaded through a standard form). 
Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.
Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here