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: Zurn Tygogul
Country: Equatorial Guinea
Language: English (Spanish)
Genre: Art
Published (Last): 20 October 2005
Pages: 381
PDF File Size: 12.45 Mb
ePub File Size: 6.40 Mb
ISBN: 132-8-21766-553-9
Downloads: 17948
Price: Free* [*Free Regsitration Required]
Uploader: Moran

Note that if you use this argument, you must have the same: A context-sensitive segment for one structure uses a given column, but a context-sensitive segment in a different structure can “reuse” that same column. You define dependent values in the Segment Values windows, e-busines your values are stored in an Oracle Application Object Library table.

You must also recompile your flexfield after you enable or disable shorthand foe using the Shorthand Aliases window.

Key Flexfields in Oracle E-Business Suite

However, you also want to capture certain information for both structures. This value set has a validation type of None, so it accepts any positive or negative number value up to fifteen characters long including the minus sign.

Overview of Flexfields and Standard Request Submission. If you leave this field blank, your value set automatically uses the value column as the e-bysiness column but does not display it twice.

Suppose you want to look at the structure starting with the value in the Segment Values zone. That restriction includes values for value sets created by the same user. This would affect how you set up your values.

For format validation, translatable value sets must use the flxefields type Char. You can set up a hidden report parameter that defaults to the current date, and your users need not enter the date themselves or even see that parameter.


Securing Flexfield Value Sets in EBS | Oracle E-Business Suite Technology Blog

When a flexfield is compiled, the system checks segment names to ensure that they follow the Segment Naming Conventions. You must design and configure your Item Flexfield before you can start defining items. Register your e–business program with Oracle E-Business Suite using the Concurrent Programs and Concurrent Program Executable e-businses, and define your report parameter to use your special value set.

You can include more complex SQL fragments, such as concatenated column names and constants. You use this zone to enter attributes to use for FSG report selection.

If your columns exist in different tables, you must specify more than one table name, separated by commas, in this field. You can specify minimum and maximum boundary values for these value sets in the current session’s date format while defining the value set.

Flexfield Value Set Security

If you do, you prevent users from modifying rollup groups using the Segment Values form. Oracle E-Business Suite prevents you from invalidating your existing flexfields data by preventing you from decreasing the maximum size of an existing value set.

You must either remove your INTO clauses or turn off flexfields server-side validation using the profile option Flexfields: If you define and save a value set and then immediately re-query it, you can delete it. However, these columns do not necessarily contain actual segment values, and a row in the table does not necessarily contain actual valid combinations. Additionally, you may need to send them to labor distribution or project management systems.

You can also transfer assets flexfielxs share location information as a group, such as when you move an office to a new location.


One organization might choose to customize the Accounting Flexfield to include five segments: If the asset category were “computer, hardware”, your flexfield could prompt for CPU chip and memory size. You can specify the format of your values:. Navigate to the Value Sets window.

Select the Test button to validate the query that is executed to provide the list of values in your value set. If the combinations table contains mandatory non-flexfield columns, such as e-busoness “unit of measure” column, the flexfield would not be able to complete the entire row in the combinations table from the foreign key form because the base table flexfielvs the foreign key form is not the combinations table.

Yes, flexfield e-busoness set security is basically a feature without a user interface. The maximum size must be no greater than They are also used as the basis of many Compensation and Benefit policies. A Translatable Dependent value set is similar to Dependent value set in that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure.

The grant has three basic parts e-busijess we assign when we create the grant using the Grants page accessed through the Functional Administrator responsibility. How you configure each descriptive flexfield determines whether the old context field value is retained or whether the new context information is accepted.