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.
|Country:||Bosnia & Herzegovina|
|Published (Last):||1 November 2011|
|PDF File Size:||16.55 Mb|
|ePub File Size:||13.23 Mb|
|Price:||Free* [*Free Regsitration Required]|
The three choices are: You can use a rollup group to identify a group of parent values for reporting or other application purposes.
Normally, you should use the values form Oracle Application Object Library provides, Define Segment Values, to contain parent values and rollup group information together with child usite contained in your validation table as described in the previous section.
You must have access to the Key Flexfields Segments form to view the key flexfields that use the value set.
Securing Flexfield Value Sets in EBS | Oracle E-Business Suite Technology Blog
If you make any changes to your value set after you have used your flexfield or concurrent program that uses this value set, you must either change responsibilities or exit to the operating system and log back in before you can see your changes take effect.
Changing to a Non-validating “None” Value Set When you replace an old value set with a new non-validating “None” type value set, these types of changes do not cause a problem with existing flexfield data so long as the format conditions are not violated character, number, date, numbers only, uppercase only, and so on.
Enter the name of the value set you want your flexfield to use to validate this segment.
Most of these object instance sets require specific parameter values to be specified as part of the grant. Define your value set. For ease of use, we recommend that you set the Description Size for each of your Accounting Flexfield segments to flexfieldd or less so that your flexfield window does not scroll horizontally. You should use this window to define values that belong to Independent, Dependent, Translatable Independent, Translatable Dependent, or Table value sets.
However, you want to make the values in the context field list of values conditional on some oacle data striping. Your three value sets might be defined as follows: For descriptive flexfields, see Defining Descriptive Flexfield Segments.
We recommend that you do not use this role, but create and use more limited roles of your own as part of your Separation of Duties controls. Create an “all-value-sets, all-privileges, all-users” grant complete backwards compatibility, described later.
In defining value sets to be used for Oracle Reports parameters that must contain a number in which precision is entered as part of the value, you must define these value sets with the format e-bysiness Character with the Numbers Only option selected.
Oracle Human Resources uses flexfield qualifiers to control who has access to confidential information in flexfield segments. You must specify values for all of the parameters shown for a given object instance set. Enter a value manually into the segment once the flexfield window has popped open.
Flexfield value set flexfjelds is also not currently supported by the Setup Workbench in the Oracle Product Information Management product.
Securing Flexfield Value Sets in EBS 12.2
You can make your segments depend on more than one segment cascading dependencies. A descriptive flexfield can get context information from either a field somewhere on the form, or from a special field a context field inside the descriptive flexfield pop-up window. To use this feature, you must first have privileges to the relevant flexfield segment or concurrent program parameter form.
If you are defining a value set that uses a validation table, orcale maximum size should reflect the size of the column you specify as your value column. If you do not define any descriptive flexfield segments, you cannot use descriptive flexfields within your windows, but there is no other loss of functionality. Make sure the descriptive flexfield is visible, that those conditions are met, and that your cursor is in the same block as the flexfield.
You should always include the table names or aliases in your clause when you refer to a column, even if you are using only one validation table and have not e-bueiness an alias for that table in the Table Name field.
Changing your existing structures may also adversely affect the behavior of any cross-validation rules or shorthand aliases you have set for your structures, so you should be sure to manually disable or redefine any cross-validation rules using the Cross-Validation Rules window and shorthand aliases using the Shorthand Aliases window to reflect your changed structures.
You should not specify a hidden ID column for value sets you use with your Accounting Flexfield or most other key flexfields. Oracle E-Business Suite does not allow you to assign a value set whose values would not fit in the flexfield table.
However, oracel you want complete backwards compatibility, where all users with access to the Segment Values form can modify all value sets, the simplest way to do this is the following procedure:. Here is an example:. That restriction includes values for value sets created by the same user.
For example, you may want to pass concatenated Accounting Flexfield segments as a parameter to a report. There are two main types of flexfield information: When you register your validation table, Oracle Application Object Library checks your table to see if these columns exist.
The value is a parent value of as well, and also has the child values of and You can create a new segment for your flexfield by inserting a row. For example, say the segment separator is a period. The value from the previous step defaults in. Most descriptive flexfields simply provide a certain number of segment columns you can use for whatever you need to fill your organization’s needs. Have “intelligent fields” that are fields comprised of one or more segments, where each segment has both a value and a meaning.
However, unique ID numbers are easier to maintain in a e-businesss database application because only one column is required for the ID number, while multiple columns would be required for an intelligent key one for vor section or segment of the code. Table-validated value sets let you use your own application flexfie,ds as value sets for flexfield segments and report parameters instead of the special values tables Oracle Flezfields Suite provides. If you have legacy systems, you may need to build a program to import your legacy values into Oracle E-Business Suite tables.
In this case, we will create a grant to a responsibility directly instead of using a role.