- OracleApps Epicenter - http://www.oracleappshub.com -
How to use Descriptive Flex Fields (DFF) in forms
Posted By Sanjit Anand On August 24, 2007 @ 9:56 pm In AOL,Beginner | 4 Comments
Implementing DFF in Form consist of two steps Process. The first steps consist of designing the table structure and registration and step 2 consist of enabling in the form.
ATTRIBUTE1â€¦ATTRIBUTE15 and ATTRIBUTE_CATEGORY are the normal fields used for DFF
For this you have to login into application with :
Application Developer -> Flex Field -> Descriptive -> Register
Then you should specify the name of the DFF (Say BTL_AR_DFF) and specify the associated table.
1. Create a form based on the custom table
- Copy TEMPLATE form has example descriptive flexfield which we can use
- Use the TEXT_ITEM_DESC_FLEX property class
- Attach ENABLE_LIST_LAMP_LOV for the field
2. Create a non-base table text item in the block with property class TEXT_ITEM_DESC_FLEX
3. Make sure that DFF is mapped to fields (ATTRIBUTE) of the table and is enabled.
1. Write, a form level trigger WHEN-NEW-FORM-INSTANCE to invoke the DFF as
Block => 'Name of the DFF block',
Field => 'BTL_DFF',
Appl_short_name => 'AR',
Desc_flex_name => 'BTL_AR_DFF',
Title => 'BPL AR More Info' );
2. Write, block level triggers PRE-QUERY and POST-QUERY as
- FND_FLEX.EVENT('Pre-Update ');
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/aol/how-to-use-descriptive-flex-fields-dff-in-forms/
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.