Creating DFF in a Custom Form

1. Go to Application Developer -> Flex Fields -> Descriptive -> Register
Enter all the details and click on Columns.
Enable the columns and save.
2. Now go to Segments menu.
Search for the created DFF.
Select the Global Data Elements and click on Segments.
Create the new segments and save
3. Now the DFF is ready to use in the Form builder.
4. Create a Text Item
   SubClass Information : TEXT_ITEM_DESC_FLEX
   LOV : ENABLE_LIST_LAMP
   Validate from List : No
   Database Item : No
5. Now create a package in Program Units section as
PACKAGE BODY <package> IS
 procedure <procedure>(Event in varchar2) is
 BEGIN
IF EVENT = ‘WHEN-NEW-FORM-INSTANCE’ THEN
FND_DESCR_FLEX.DEFINE(BLOCK => <Data Block Name>,
     FIELD => <DFF Field Name>,
     APPL_SHORT_NAME => ‘SQLAP’,
     DESC_FLEX_NAME => <DFF Name registered in the Application> );
  END IF;
 END;
END;
6. Create below triggers:
WHEN-NEW-FORM-INSTANCE – > package.procedure(‘WHEN-NEW-FORM-INSTANCE’);
WHEN-NEW-ITEM-INSTANCE -> FND_FLEX.EVENT(‘WHEN-NEW-ITEM-INSTANCE’);
Oracle apps provides the API named, FND_FLEX, for Descriptive flexfield events. You can to write all the block level triggers to have consistent normal behaviour of the descriptive flexfield.
WHEN-VALIDATE-ITEM ->  FND_FLEX.EVENT(‘WHEN-VALIDATE-ITEM ‘);
PRE-QUERY ->  FND_FLEX.EVENT(‘PRE-QUERY’);
POST-QUERY ->  FND_FLEX.EVENT(‘POST-QUERY’);
WHEN-VALIDATE-ITEM ->  FND_FLEX.EVENT(‘WHEN-VALIDATE-RECORD’);
PRE-INSERT ->  FND_FLEX.EVENT(‘PRE-INSERT’);
PRE-UPDATE ->  FND_FLEX.EVENT(‘PRE-UPDATE’);
  • January 8, 2018 | 16 views
  • Comments