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: | Dujas Zololar |
| Country: | Greece |
| Language: | English (Spanish) |
| Genre: | Travel |
| Published (Last): | 11 May 2014 |
| Pages: | 341 |
| PDF File Size: | 10.78 Mb |
| ePub File Size: | 12.94 Mb |
| ISBN: | 283-2-20041-244-4 |
| Downloads: | 26014 |
| Price: | Free* [*Free Regsitration Required] |
| Uploader: | Nisar |
Your maximum value may not be longer than the maximum size you specify for this value set. Plan your flexfield value set security who should have what roles, value sets, privileges, and so on.
Key Flexfields in Oracle E-Business Suite
You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme.
Max Value Enter the maximum value a user can enter in a segment that uses this value set. Enter formatting information appropriate to your format type, including information such as whether your values should include numbers only and whether they must fall within a certain range.
We recommend that you allow parent values for segments in your Accounting Flexfield. You can share value sets across key and descriptive flexfields. If not, you cannot define and move child value ranges for this value, and you cannot assign this value to a rollup group.
Planning and Defining Descriptive Flexfields
Suppose you already defined all of your context field values, and you do not need another table. These permissions are used in the Segment Values form to determine what actions a user can do with values in the form.
If your end user enters an invalid segment value, a list of valid values appears automatically so that the user can choose a valid value. You typically define your individual suitd only after your flexfield has been completely defined and frozen and compiled. Precedence of Default Values, Shorthand Entry Values, and COPY Values in Key Flexfields There are four ways you can put a value into a key flexfield segment in order of precedence, where the first overrides the second, which overrides the third, e-businesss in turn overrides the fourth: You also use this window to define validation routines flexcields a Pair value set.
You should fully document your flexfield plans before you sit down to define your orqcle using your Oracle E-Business Suite setup forms. The results of a security grant are not what is expected—not all expected results are present. For a full discussion of these features, see the Using Additional Flexfields Features chapter.
For most value sets, when you enter values into a flexfield segment, you can enter only values that already exist in the value set assigned to the segment. For example, the value 20 will be “larger” than the value The Soft Coded KeyFlexfield holds legislation specific information.
For example, the descriptive flexfield in an application window may be used to capture different information based on which country is specified in a field on that window.

Enter security context if needed. If you are defining values for a value set used with the Accounting Flexfield, you must define segment qualifier information for each value. This separator will appear whenever your application forms display concatenated segment values or descriptions.
For value sets that contain numeric values Number format, or Character format with Numbers Only selectedthis attribute represents the number of digits after the radix character.
Securing Flexfield Value Sets in EBS | Oracle E-Business Suite Technology Blog
You design your category flexfield to record the information you want. If so, you can choose the Down button in the Navigate to view any values that e-bueiness children of this value. This window stores your parent values and rollup groups for you and does not add them to your validation table. This second view is generated only if you enter a view name for your structure in the View Name field.

Keep in mind that your values will change over time. You should prevent dynamic inserts if you want to enter new valid flexfield only from a single application window you create to maintain your specific combinations table. For example, your Oracle General Ledger product needs to be able to identify which segment in the Accounting Flexfield contains balancing information and which segment contains natural account information.
Indicate whether you want to require a value for this segment. You cannot make most changes while your flexfield is frozen.
Oracle E-Business Suite Flexfields Guide
If you have context-sensitive segments, your descriptive flexfield needs context information a context value to determine which context-sensitive segments to show. It sounds like you have a good sense of where this needs to go. The table below illustrates how the segment values would appear in the combination.
