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.
|Published (Last):||12 December 2018|
|PDF File Size:||6.53 Mb|
|ePub File Size:||14.1 Mb|
|Price:||Free* [*Free Regsitration Required]|
If you do derive your context field value from a reference field, however, we recommend that you do not allow your user to see or change that value in the flexfield window. If you define and save a value set and then immediately re-query it, you can delete it.
If you want context-sensitive segments, do you want to have the form automatically determine which descriptive flexfield structure to display based on the value of a field somewhere on the form? When you define your Accounting Flexfield, you must specify which flexfield qualifiers apply to which segments. You can specify minimum oradle maximum boundary values for these value sets in the current NLS date format while defining the value set.
Standard Request Submission
We recommend that you set up flexfield value set security to restrict privileges for modifying value sets to specific users as described previously. When you are planning your flexfields, you should consider the following oraclf and their corresponding decisions:. You must also recompile your flexfield after you enable or disable shorthand entry using the Shorthand Aliases window. Like Jobs, a Position is an optional component of the Employee Assignment.
The maximum size applies to your translated values e-businss well as the hidden values.
You do this by specifying: One request per value set that the change affects the value set attached to the segment for which you are defining or maintaining values may be submitted.
For example, you might create a value set with format type of Number where the user can enter only the values between 0 and Enter the name of an independent value set on which this dependent value set depends.
Do you want to share values among segments in different structures or among different flexfields? Thanks for your narration and sharing. In this structure, the parent value has the child values, and ; the value is in turn a parent to the valuesand Separation of Duties SoD is one of the key concepts of internal controls and is a requirement for many regulations including: Since all three valuesand are not parent values, you give this range a range type of Child.
Then you group your assets by asset key so you can find them without an asset number. It includes further discussion of flexfields concepts and provides additional concepts that are specific to descriptive flexfields. The planning phase fod be broken into smaller, though still interrelated, steps:. Since report parameters are a special type of descriptive flexfield segment, we use the terms “report parameters” and “segments” somewhat interchangeably, especially in descriptions of flexfield setup forms.
If your value set is a Translatable Independent or Translatable Dependent value set, this value is “hidden” from the user in the flexfield windows.
For ease of maintenance, you should carefully plan your value hierarchy structures before you define your values, so that your structures follow a logical pattern you can expand later as you need more oracls. You may have instances where, when querying existing records, you want the context field value to match the original reference field value, but with new records, you want the context field value to be derived from the current reference field value.
Decide What Your User Needs. There are four ways you can put a value into a key flexfield e-busineess in order of precedence, where the first overrides the second, which overrides the third, which in turn overrides the fourth:. You must save the value set definition of your independent value set before you can select it in this field.
Planning and Defining Descriptive Flexfields
If the field contains Parent, any parent values that fall in the specified range are considered to be children of your parent value. Value sets that use this mechanism will not be compatible with a future release of Oracle E-Business Suite. You can use the Stock Flexfeilds Flexfield to capture more information about stock locators in inventory. An alteration of the flexfield structure can create data inconsistencies.
Oracle E-Business Suite Flexfields Guide
Enter a default flexfilds for your dependent value set. Both of these part numbers are codes whose segments describe a characteristic of the part. You have several other options from which to choose. The Company segment is the balancing segment, so we want to keep strict controls on who can insert and update values for it.