Posted on August 24th, 2007 by Sanjit Anand | Print 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 field2. 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
September 3rd, 2008 at 6:30 am
is their any why to register non apps table to apps?
September 3rd, 2008 at 6:57 am
use the api ad_dd.register_table and ad_dd.register_column to register non apps table.
January 6th, 2009 at 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
February 14th, 2009 at 10:55 am
Is it possible to transfer a payables dff to a general ledger dff field?