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):||22 June 2016|
|PDF File Size:||18.57 Mb|
|ePub File Size:||4.40 Mb|
|Price:||Free* [*Free Regsitration Required]|
When you accept this value, you can perform detailed budgeting to GL accounts with this segment value.
You may need to convert any existing application data that uses value descriptions, since you will no longer have descriptions or segment qualifiers for your segment values. That is, a structure consists e-buiness all the segments that would appear at one time after the structure has been chosen. Any value you define must conform to the criteria you defined for your value set.
Flexfield Value Set Security
If you attempt to freeze a flexfield in which two segments share the same segment number, the flexfield does not compile. You also specify segment value qualifiers, rollup groups, and child value ranges.
When opened, both types of flexfield appear as a pop-up window that contains a separate field and prompt for each segment. Steps other than actually creating the grants, such as planning and creating the roles, are the same in both cases.
You use Global Data Elements to set up global segments that you want to use in every segment structure. Users see the dates in the dates in their preferred format while entering data, querying data and using the List of Values. 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.
Current Time The default value is the current time or the current date and time, depending on the maximum size of the segment. The results of a security grant are not what is expected—more results are present than expected.
To specify a range that contains only a single value, enter the same value for both Low and High. Hiding segments will adversely e-busindss your application features such as Mass Allocations.
This window is also used to enter information for Translatable Flexfielsd value sets. You can use the Minimum Value and Maximum Value fields e-ubsiness define a range of valid values for your value set. Rollup groups are used to create summary accounts for reporting purposes.
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. You may use table aliases if desired.
Usually an application needs some method of identifying a particular segment for some application purpose such as security or computations. If you want to generate a database view for this structure, enter a view name. The special variables you can use include: If e-businwss, you need not define this descriptive flexfield at all. If you decide later that you want to implement flexfield value set security as part of your Separation of Duties controls, you can delete such grants revoke privileges or end-date the role assignments or the grants.
When you do, your flexfield compiles automatically to improve on-line performance. All three valuesand are now grandchild values of instead of See Special Validation Value Sets for information on using this region. That is, the value must not exceed the maximum length you define for your value set, and it must meet any format requirements for that value set. You can share value sets among segments in different flexfields, segments in different structures of the same flexfield, and even segments within the same flexfield structure.
Securing Flexfield Value Sets in EBS | Oracle E-Business Suite Technology Blog
Then you group your assets by asset key so you can find them without an asset number. For example, you can make your new grant apply to a different responsibility than the original grant applied to.
Examples of Minimum and Maximum Values If flexfieds value set uses Char format, with Numbers Only and maximum size of 3, then your minimum value is ” and your maximum value is ”. Check “Enable Security” if you want segment security to be applied to parameters note that this field is display only if the value set does not have security enabled.
Oracle E-Business Suite Flexfields Guide
You may need to contact your system administrator or database administrator to run the SQL query. You should not use fields that could contain an infinite number of unique values, such as a PO Number field or a date field unless that date field has a list of a few particular dates, such as quarter end dates, that would never change. You can also use value sets for report parameters for your reports that use the Standard Request Submission feature.
The Segment Values window automatically creates your dependent default values at the time you create your independent values. For example, if you disable old cost centers and enable new ones frequently, you would “use up” cost center values quickly. We get a confirmation message for the grant creation and click OK. For example, in a value set with a Character format type, is less than 99 even though they appear to be numbers.
You might use these to store additional information about each journal entry, such as a source document number or the name of the person who prepared the entry. You would then define context-sensitive segments for just those countries that need context-sensitive segments.