Enabling DFF In Oracle Standard Forms



1. Identify Descriptive fields used in a form .



Go to Help -> Diagnostic -> Examine ->Block($DESCRIPTIVE FLEXFIELD)

2. Open Descriptive flexfield segment




Go to Setup ->Flexfields ->Descriptive ->Segments


3. Enable Descriptive Flexfield.




·Define Code , name & description for new descriptive flexfield
·Un-check Freeze Flexfield Definition
 


4. Define Segments for a flexfield
.Define Segment Name and Attibute.
.Define Valuset if any.


5. Compile the Flexfield


.Check Freeze Flexfield Definition.
.Compile the Flexfield to see effect on standard oracle form.



6. Flexfield on form




No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...