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: Mejas Tygolkis
Country: Nepal
Language: English (Spanish)
Genre: Health and Food
Published (Last): 19 September 2005
Pages: 108
PDF File Size: 2.45 Mb
ePub File Size: 3.3 Mb
ISBN: 936-7-69281-185-7
Downloads: 48922
Price: Free* [*Free Regsitration Required]
Uploader: Kashura

You specify child values by entering a set of ranges. Function security controls whether a user e-busimess access to a specific page or form, as well as what operations the user can do in that screen.

Values never change; descriptions can. This combination guarantees each transaction to Inventory is unique. Without the displayed context field, your flexfield must determine the context field value from the reference field or your default value.

There are two ways to find the value set ID number once you have the value set name:. For example, you may need to define new flexfield structures or disable old structures.

Oracle E-Business Suite Flexfields Guide

Your changes are saved automatically when you compile. Thoroughly plan your values and value sets. You also determine the appearance of your descriptive flexfield window, including the size of the window, the number and order of the segments, and the segment descriptions and default values. You risk corrupting your database and damaging all your applications. VALUE is the displayed value for the segment. How do you want to break down reporting on your descriptive flexfield data?


Plan your flexfield value set security who should have what roles, value sets, privileges, and so on. If the value set is a table-validated value set, the values in this Code field correspond to the values in the ID column of the value set.

Define a value set that uses your validation table. This behavior is unlike that for required flexfield segments, suit the default value will be entered regardless of whether the user opens the flexfield window. If you plan to use additional features such as cross-validation rules or flexfield value security, you define those additional features at this point.

This is the only change made, and values are not affected. Typically, you set up context suitw values by typing them into the Descriptive Flexfield Segments window individually, and you then set up context-sensitive segments for each context field value.

For example, if you have a default context e-buwiness value structure choicebut you have a context field as well, your default value will appear in the f,exfields field but the user can choose a different value instead. That is, a security rule that applies to a parent value does not “cascade down” to its child values. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to use for segment identification.

Values are stored with exactly this number of digits following the radix character, with zeroes added or rounding applied as needed. Apply your rollup group name to particular values using the Segment Values window. The form also contains flexfislds hidden context field that holds the structure choice, regardless of whether you choose to display a context field in the pop-up window.


If your structure’s concatenated length exceedsyou may experience truncation of your flexfield data in some forms.

You can define as many segments as there are defined segment columns in your flexfield table. If possible, avoid using a SQL expression in place of a column name because support for SQL expressions will be obsolete in a future release.

Standard Request Submission

Usually an application needs some method of identifying a particular segment for some application purpose such as security or computations. You use Oracle Application Object Library flexfield routines for these special value sets.

The meaning of a value in this value set does not depend on the value of any other segment. Specifying Parent lets you create tree-structured hierarchies. When you enter No, you can neither assign GL accounts with this segment value to budget organizations nor define budget formulas for GL accounts with this segment value.

Max Value Enter the maximum value a user can enter in a segment that fflexfields this value set. With this type of value set, a user can enter the report parameter and then see the “normal” behavior of a key flexfield, such as the key flexfield window and segment validation associated with that key flexfield.

If the combinations table contains mandatory columns that are not maintained by the flexfield, dynamic inserts would not be possible. Existing combinations or existing data that use values outside the valid range are treated as if they contain expired segment values.