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):||11 May 2005|
|PDF File Size:||17.82 Mb|
|ePub File Size:||4.12 Mb|
|Price:||Free* [*Free Regsitration Required]|
For example, if your format type is Char, then is less thanbut if your format type is Number, is less than You can identify employee groups using the individual segments of the Job whenever you run a report or define a QuickPaint. However, these columns do not necessarily contain actual segment values, and a row in the table does not necessarily contain actual valid combinations. You should think of a flexfield qualifier as something the whole flexfield uses to tag its pieces, and you can think of a segment qualifier as something the segment uses to tag its values.
The following table lists the supported time formats and value set maximum sizes you can use:. To make our job easier, we first flexfiepds a small text document and copied the values we needed to and from the text document.
You specify child values by entering a set of ranges. A context-sensitive segment for one structure uses a given column, but a e-busineds segment in a different structure can “reuse” that same column.
Oracle E-Business Suite Flexfields Guide
You should never attach a new value set to your segment where the maximum size of the new value set is smaller than the maximum size of the old value set. Changing a flexfield for which you already have data may require a complex conversion process. E-businesz E-Business Suite prevents you from invalidating your existing flexfields data by preventing you from decreasing the maximum size of an existing value set.
If you are defining the Accounting Flexfield, you must display all segments. Register your table with Oracle Application Object Library as a table. You may also see this message if you do not have access to flexfeilds value sets specified by criteria you have already entered in prior fields in the Find window.
Your ranges behave differently depending on your value set format type. The values must exactly match the data. Both types of flexfield let you customize Oracle E-Business Suite features without programming. If the displayed length is less than the maximum length, the e-busines must scroll through the segment to see its entire contents.
All three valuesand are now grandchild values of instead of You use “Special” validation type value sets to provide a flexfield-within-a-flexfield. You might have a form where you take orders for parts, another form where you flexfislds parts, and yet another form where you ship parts.
That includes independent and dependent value sets for flexfields and report parameters. The context-sensitive segments may appear immediately if the appropriate context information is derived from a field before the user enters the descriptive flexfield.
Generally, you use value sets with hidden ID columns only for report parameters. However, we recommend that you create your own date value sets for any new flexfield segments. This option is very easy to set up, but it is not recommended because it defeats the purpose of the Separation of Duties feature. In this case, we will create a grant to a responsibility directly instead of using a role.
Profile The default value is the current value of the user profile option you specify here. Your three value sets might be defined as follows: You use special arguments to these routines so that they work e-businexs your report parameter window.
You set “Override Allowed” to Yes if you want a context field to appear in the descriptive flexfield pop-up window.
In fact, fields for forklift information would be cumbersome whenever a user in any organization tries to enter any asset that is not a forklift. If you are defining more than one segment in the same structure at one time, ensure that you use unique columns for each segment.
Standard Request Submission
You should not include any spaces, quotes, or other special characters in your value set name. This section discusses how you set up report parameter segments to pass values to your report using the Submit Flexfirlds form. We recommend using flexfield value set security as part of a comprehensive Separation of Duties strategy.
Indicate whether you want this segment to appear in the flexfield window. Use this oraclr to define child values for the value you defined in the Segment Values zone.
You freeze rollup groups using the Key Flexfield Segments window. You should never change the displayed column types. Typically, you would define different structures of descriptive flexfield segments for each value that the reference field would contain.
As time passes, you will suiite that you need to change your flexfield value set security grants and roles. You cannot use the Numbers Only feature or the Right-Justify and Zero-fill feature with translatable value sets. You define a context field differently as well. Suppose you want to look at the structure starting with the value in the Segment Values zone. If you are creating additional, more specific grants, this grant will also make it suute like those grants e-businese not functioning properly since everyone will already have access to everything.
If you use the same value set for parameter values, the values you define here also become valid values for your report parameter. For the Security Context in this example, we assign our grant to the group of users who have the “Payables, Vision Chile” responsibility.
We click on OK to acknowledge the Confirmation message, and then we see the responsibility information with our grant information. Dependent segments should occur after the segment they depend upon in the flexfield window.
These may be groups which are not identified by your definitions of other Work Structures.