The Oracle E-Business Suite products provide many key flexfields as integral parts of the products. This chapter contains tables with basic information for many . 4 Values and Value Sets. 5 Using Additional Flexfield Features. 6 Key Flexfields in Oracle E-Business Suite. 7 Standard Request Submission. For flexfields and report parameters in Oracle E-Business Suite, values in value sets can affect functionality such as the rollup of accounting data, job grades.

Author: Goshicage Nidal
Country: Namibia
Language: English (Spanish)
Genre: Finance
Published (Last): 25 May 2012
Pages: 265
PDF File Size: 20.58 Mb
ePub File Size: 18.92 Mb
ISBN: 421-2-96521-835-6
Downloads: 61449
Price: Free* [*Free Regsitration Required]
Uploader: Vile

Enter a default value for the segment. Segments can be seen at business group, payroll or assignment level. It is possible that Oracle Human Resources will use the other segments of this flexfield in the future.

The value sets you define using these windows appear in lists of values you see when you define flexfield segments using the Key Flexfield Segments window or the Descriptive Flexfield Segments window. Define a value set that uses your validation table. If you are defining the first structure for your flexfield, select the default flexfield structure that appears automatically.

You can make your segments depend on more than one segment, creating cascading dependencies. In the Functional Administrator responsibility, we navigate to the Grants page and click Create Grant. The special variables you can use include: Security Administration Setup” row.

Usually you use this option to ensure that character values that appear to be numbers will be sorted and appear in order as if they were actually number values for cross-validation rules, value security rules, and reporting, for example. You can define a range of values for a value set that already contains values.

Oracle E-Business Suite Flexfields Guide

Examples of Validation Types None You use a None type value set when you want to allow users to enter any value so long as that value meets the value set formatting rules. If you are creating a Dependent, Translatable Dependent, Table, Special or Pair value set, choose the Edit Information button to open the appropriate window.


Oracle E-Business Suite reserves certain naming patterns. To define segment values: You can think of a segment qualifier as an “identification tag” for a value. You must have access to the Descriptive Flexfields Segments form to view the descriptive flexfields that use the value set.

Because the conditions you specify for your value sets determine what values you can use with them, you should plan both your values and your value sets at the same time.

Key flexfields also offer additional features that help your fpexfields maintain valid combinations and make data entry easier for your users. If you set the Right-Justify and Zero-Fill Numbers flag to Yes, the values in your value columns should also be right-justified and zero-filled; that is, there should be an exact match in formatting.

A range flexfield supports low and high values for each key segment rather than just single values. Define your independent value set. Changing your separator once you have data in such tables may invalidate that data and cause application errors. If your flexfield definition is frozen oraacle is, the Freeze Flexfield Definition check box is checkedthis window becomes display-only.

Flexfield Concepts

You can define as many segments as there are defined segment columns in your key flexfield combinations table. Use this block to define valid context field values that also serve as structure names for this descriptive flexfield.

If you do not see the descriptive flexfield you want, it may be because your form has special logic that prevents the flexfield from being read by Examine, such as logic that makes the flexfield appear only under certain conditions.

You can even add to the descriptive flexfield later as you acquire new categories of assets.

Concatenated Description Size specifies the number of characters long a segment value description should be when a window displays it as part of e-busines concatenated description for the concatenated flexfield values. In the Key Flexfield Segments form, we query our flexfield structure and see what value set is attached to the Company segment.


E-busoness, to display Suppose you already defined all of your context field values, and you do not need another table. If yes, you need to define a reference field note that some descriptive flexfields do not provide reference fields. E-bysiness window stores your parent values and rollup groups for you and does not add them to your validation table. If a context field value is required, your flexfield does not allow you to leave the flexfield window without entering oracoe valid value.

The maximum number of segments you can have within a single structure depends on which descriptive flexfield you are defining. If your table has not been registered, you must then enter all your validation table information in this region without using defaults. C or later must be applied before you use this feature with any object instance sets other than “All value sets” which does not require any parameters.

VALUE of the prior segment. This value is the default for any segments that use this dependent value set. Your flexfield does not display disabled segments. Your flexfield automatically displays this default value in your segment when you enter your key flexfield window. Flexfield value security controls what values a user can enter into a flexfield segment or report parameter by responsibility during routine data entry in many transaction screens across Oracle E-Business Suite.

If you selected “All Value Sets”, you will not see any parameters.