Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

AOL – Descriptive Flex Field ( Deep Drive)

Posted on August 22nd, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

As we have seen DFF provide customizable expansion space in the form to capture additional information, which are not provided at present. A DFF describes an application entity, providing form and database expansion space that can be customized.

Why Descriptive Flex fields

  • Customers require more data to be stored than what Oracle provides
  • Oracle gave us additional “space” in most tables to store this data
  • Descriptive Flexfields will survive an upgrade

Global vs Context Sensitive

  • Global Data Elements mean the question will be asked for every occurrence of the Descriptive Flexfield.
  • Context Sensitive Elements are questions asked “depending” on the answer to some other question. This “other” question can use a Reference field from above for its answer.

How Segments Use Underlying Columns

  • A DFF uses columns that are added onto a database table. The table contains any columns that its entity requires.
    The DFF columns provide ‘blank’ columns that you can use to store information which is not already stored in another column of that table.
  • A DFF requires one column for each possible segment and one additional column in which to store structure information(i.e. The context value).
  • You can define as many segments in a single structures as you have DFF columns in your table.
    The DFF columns are usually named as ATTRIBUTEn, where n is a number.

Implementing Descriptive Flexfileds
For implementing DFF it requires five steps:

  • Define DFF columns in your Database table
  • Register your table with AOL/ Pl/SQL scripts
  • Register Your DFF with Oracle AOL
  • Create Your DFF in Your Form
  • Add DFF routines to Your Form

Drawbacks of DFF

  1. Disk space is wasted.
  2. DFF has limited segment for global as well as context-sensitive attribute.
  3. No query possible on DFF segment values.
Related Posts

Posted in AOL, Beginner | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.