Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Monday, 9 October 2017

What are the difference between KFF and DFF in Oracle Apps


Key Flex field

Descriptive Flex field

This field is Mandatory and there are 33 KFF in Oracle finance out of which accounting structure is the one of the KFF in GL module
This flex field is optional to capture the additional information. There is no such limit
KFF is application Specific
DFF is form Specific
Cross Validation Rules are Specific to KFF
Cross validation are not applicable to DFF

Aliases are applicable to KFF
Not applicable to DFF
KFF is Inbuilt (Oracle Provides)
We have to define DFF.

Share this article :


  1. Hi Dayakar,

    Your blog is such a complete read. I like your approach with What are the difference between KFF and DFF in Oracle Apps. Clearly, you wrote it to make learning a cake walk for me.

    Cursor for loop implicitly declares %ROWTYPE as loop index, opens a cursor, fetches rows of values from active set into fields in the record and closes when all the records have been processed.

    Greetings of the day!

    I need a help. I am working on a report now, in which I am using a materialized view, while refreshing it I am getting this error "out of process memory when trying to allocate 1094464 bytes", I have tried extending the temp tablespace memory but found the same error.

    I look forward to see your next updates.


  2. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  3. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.