- OracleApps Epicenter - http://www.oracleappshub.com -

How to use Descriptive Flex Fields (DFF) in forms

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.

Steps 1:

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.

Step 2:

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

FND_DESCR_FLEX.DEFINE(
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-QUERY');
  • FND_FLEX.EVENT('POST-QUERY');
  • FND_FLEX.EVENT('Pre-Query');
  • FND_FLEX.EVENT('When-Validate-Record');
  • FND_FLEX.EVENT('Post-Query');
  • FND_FLEX.EVENT('When-New-Item-Instance');
  • FND_FLEX.EVENT('Pre-Insert');
  • FND_FLEX.EVENT('When-Validate-Item');
  • FND_FLEX.EVENT('Pre-Update ');

4 Comments (Open | Close)

4 Comments To "How to use Descriptive Flex Fields (DFF) in forms"

#1 Comment By hemant On September 3, 2008 @ 6:30 am

is their any why to register non apps table to apps?

#2 Comment By sanjit anand On September 3, 2008 @ 6:57 am

use the api ad_dd.register_table and ad_dd.register_column to register non apps table.

#3 Comment By Krishna On January 6, 2009 @ 1:22 am

Hi,

I have a custom form which has a DFF. DFF has 9 segments. Based on some conditions, I need to set 1’st segment value to a constant. Any idea of how to do this.

Thank you
Krishna

#4 Comment By Steve On February 14, 2009 @ 10:55 am

Is it possible to transfer a payables dff to a general ledger dff field?