Tuesday 11 September 2012

Implementing DFF in Forms




1)Open the form where DFF is Implemented. and Query the Data

2)find the DFF name from Help Menu =>Diagnastcs =>Examine
       Select  $DESCRIPTIVE_FLEXFIELD$ in the Block field
       select  DFF name in the "Field"
       we will get the DFF Title in the Value field.
 Copy the DFF title

3)goto Application Developer Responsibility.
 flexfield=>Descriptive=>register

4)Query the records by using the  DFF Title.
 Select columns button and find wether Attribute
  columns are enabled or disabled.

5)Goto Segments form and Query the records by using Title.

6)Uncheck the Check box called "freeze Flexfield Defination"

7)Select Segents button and enter the new fields and save transactions.

8)Check the check box called "freeze Flexfield Defination"
and click the Compile Button.

9)System will change the DFF structure and creates



a descriptive flexfield View.





1)define the field in the Canvas
    change the field property database items as "no"

2)Define the Package like follows.

Package Specification:
----------------------
PACKAGE DFF_PKG IS
  PROCEDURE DFF_PROC(EVENT VARCHAR2);
END;
Package Body:
-------------
PACKAGE BODY DFF_PKG IS
    PROCEDURE DFF_PROC(EVENT VARCHAR2) AS
    BEGIN
        IF (EVENT = 'WHEN-NEW-FORM-INSTANCE'       ) THEN
   
         FND_DESCR_FLEX.DEFINE( BLOCK =>  'WIP_ITEMS10',
                 FIELD             =>  'DFF_TEXT',
                 APPL_SHORT_NAME   =>  'WIP',
                     DESC_FLEX_NAME   =>     'WIPDFF');
                 
        END IF;
        END DFF_PROC;
 
END;

3)Call this Package from WHEN-NEW-FORM-INSTANCE Trigger
   packagename.Procedure name('WHEN-NEW-FORM-INSTANCE');
   DFF_PKG.DFF_PROC('WHEN-NEW-FORM-INSTANCE');
4)Call another API from WHEN-NEW-ITEM-ISNATCE Trigger
fnd_flex.event('WHEN-NEW-ITEM-INSTANCE');
-It will Populate the DFF in the Form.



Give me your Feedback.......

No comments:

Post a Comment

Note: only a member of this blog may post a comment.