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: Samushicage Jukazahn
Country: Vietnam
Language: English (Spanish)
Genre: Spiritual
Published (Last): 28 December 2016
Pages: 326
PDF File Size: 2.34 Mb
ePub File Size: 1.58 Mb
ISBN: 146-7-41796-392-8
Downloads: 48902
Price: Free* [*Free Regsitration Required]
Uploader: Zulujind

Hierarchy Details Buttons The Hierarchy Oracpe buttons open the windows you use to define and maintain detailed information about your value hierarchies.

You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories. If you attempt to use a single column for more than one segment in the same structure, you cannot save your changes or compile your structure. Each segment has a name and a set of valid values. If a user has multiple grants to the same value set through different pathwaysand those grants provide dlexfields privileges, the resulting privileges are the union of the privileges of the grants, as shown ssuite the following picture.

Relationship Between Independent and Dependent Values. You also use this window to define validation routines for a Pair value set.

As with any flexfield, planning how your flexfield pop-up window should look and f,exfields is the most important step. In some cases, however, you may have an existing table of the values that would be valid context field values but would not all have corresponding context-sensitive segments for example, a table of countriesand you do not want to duplicate the forr of the existing table by creating a new context field value for each existing value in your table each country name, for example.


Application name and table name uniquely identify your table.

Oracle E-Business Suite Flexfields Guide

For certain types of changes to value hierarchies, a concurrent request is submitted to rebuild the value hierarchies.

Special Validation Value Sets for information on using these validation types. For example, Oracle Assets uses a key flexfield called the “Asset Key Flexfield” and refers to one of its combinations as “an asset key” or “an asset key flexfield”. If you are missing any values that had been in the original value set, your users will get error messages upon querying up old code combinations whose values are now missing. Planning Your Descriptive Flexfields. Enter a description for your value.

For example, if you have a list of countries where you want all the countries to be valid context field values, but only a few of the countries have related context-sensitive segments, you would use a value set that includes your entire list of countries.

Because each key and descriptive flexfield has a different purpose, you should be sure to understand the purpose and requirements for the flexfield you want to define.

Since all three valuesand are not fo values, you give this range a range type of Child. Additional Columns Field What you specify here should be of the general syntax: But, if you enter information into database tables using database tools, you may store invalid information. There are two main types of flexfield information: If yes, you need to define a reference field note that some descriptive flexfields do not provide reference fields.

The table below illustrates how the segment values would appear in the combination. In this case, you leave the flexfield window without seeing any context-dependent structures. You use the flexfield code and the owning application to identify a flexfield when you call it from a custom form. Suppose you already defined all of your context field values, and you do not need another table.


If you leave this field blank, the maximum value for this value set is automatically the largest value possible for your value set. You can also view and maintain segment value hierarchies for the Accounting Flexfield or for any custom application flexfields that use the value hierarchies feature.

Oracle E-Business Suite Flexfields Guide

First we create a role using the User Management responsibility. You can click in the Qualifiers field to bring up the Segment Qualifiers window and see the qualifiers.

You must freeze and compile your flexfield definition before you can use your flexfield. The first segment describes the object, a note pad, the second segment describes the color of the object, yellow, and so on.

A Translatable Independent value set is similar to Independent value set in that it provides a predefined list of values for a segment. Usually an application needs some method of identifying a particular segment for some application purpose such as security or computations. These segments appear before any context field or context-sensitive segments in the flexfield window. If the segment or parameter is displayed, the Fot Column appears with the parameter flezfields segment prompt as the column title.

You may also see this message if you do not have access to any value sets specified by criteria you have already entered in prior fields in the Find window.