Re: flexfields definition?

bob sullivan wrote.
> Can anyone enlighten me on the subject of flexfields?

Flexfields are used by Oracle Applications, like Oracle Financials, and are an extension to Oracle Forms. It is used heavily to allow for customizing Applications. Like in General Ledger, the whole ledger structure has been defined using flexfields. Doing so, Oracle Applications can display input screens for any setup. Like one company would have accounts like 'XX-NNNNN', where XX is the department and NNNNN a cost center. Another company might use 'XX-Y-ZZ-NNN' where XX is a country code, Y a division, ZZ a department and NNN the account. Both definitions could even be used in the very same installation of Oracle Applications, simply by using flexfields.

Using Flexfields, you can also easily add extra fields (Descriptive Flexfields) to Oracle-provided forms. The data entered in such columns is virtually added to the underlying tables. That is: if one defines a flexfield for Private Phonenumber and Birthday on some Customer Data form, then the flexfields are added to each row of the Customer table. The data is not really stored in the same table, but using the Application Object Library it easy to find the corresponding data in the flexfield tables.

Arjan. Received on Sun Mar 21 1999 - 04:17:04 CST