Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

How to use Descriptive Flex Fields (DFF) in forms

Posted on August 24th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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:

  • Define DFF fields in the custom tables

ATTRIBUTE1…ATTRIBUTE15 and ATTRIBUTE_CATEGORY are the normal fields used for DFF

  • Register the table with Oracle AOL
  • Register the DFF with Oracle AOL

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:

  • Create DFF fields in the custom form

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.

  • Next is to call Flexfield Routines to add DFF built-ins in the form to invoke DFF.
    • This consist of these steps:

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 ');

Related Posts

Posted in AOL, Beginner | 4 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. hemant Says:

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

  2. sanjit anand Says:

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

  3. Krishna Says:

    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. Steve Says:

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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.