| about flexfields [message #126707] |
Wed, 06 July 2005 05:02  |
mukka_ramesh
Messages: 19
Registered: June 2005
|
Junior Member |
|
|
When we are creating flexfields for key flexfild we will use the segments and for descriptive flexfields we are using attributes.
1)What is the difference between segments and attributes?
2)once we created a key flexfild for that we can't add some more segments?
|
|
|
|
| Re: about flexfields [message #126926 is a reply to message #126707] |
Thu, 07 July 2005 07:16  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
On the documentation CD available for download from under Top Tech Docs on Metalink and from OTN, there is a manual called "Oracle Applications Flexfields Guide". I urge you to take a look at this as flexfield are one of the fundamental parts of the Oracle E-Business Suite (EBS).
Now to your questions. It is important to understand the difference between key flexfields (KFFs) and descriptive flexfields (DFFs).
For each KFF there is an associated table that hold all combinations of codes (or segments) that have ever been used (and in some cases not used). The tables where the KFF is used then only store a unique identifier to the relevant record in the table with the combinations. Example: The account code combination used in GL. This has a table of combinations GL_CODE_COMBINATIONS. A table referring to it is GL_JE_LINES. It contains the field CODE_COMBINATION_ID which is the unique identifier in GL_CODE_COMBINATIONS.
DFFs are not shared between several tables. They are usually stored in fields called ATTRIBUTE1 -- ATTRIBUTE15 in the same table as all the other information displayed in the block of the form where the [] of the DFF is displayed.
To your second question: You can add new segments, but you need to be careful. It might create data inconsistencies or require some form of conversion. It could also affect cross-validation rules, shorthand aliases etc.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
