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):||25 July 2013|
|PDF File Size:||10.35 Mb|
|ePub File Size:||5.32 Mb|
|Price:||Free* [*Free Regsitration Required]|
Defining Your Validation Table. Implementing Separation of Duties requires minimizing the possibility that users could modify data across application functions where the users should not normally have access. Plan your flexfield carefully. If yes, you need to define context-sensitive segments. Because we have just created a grant for the similar Belgium Accounting Flex structure, we can take a shortcut and duplicate that previous grant. In some cases, however, you may have an existing table of the values that would be valid context field values but would not all have corresponding context-sensitive segments for example, a table of countriesand you do not want to duplicate the contents of the existing table by creating a new context field value for each existing value in your table each country name, for example.
We click the Update icon. If you are using the Grants page instead of the wizard to set up your flexfield value set security, you also need to find the value set ID number for the value set.
You can completely customize the appearance of your flexfield pop-up flexfielss for each structure, including its title and the number, order, length, and prompts of its segments. The three Type fields automatically display the types of the columns you select. If you do not want your flexfield to validate this segment, you can use the Value Sets window to define a value set with a Validation Type of None, or you can leave this field blank.
Because these column sizes vary among flexfields, you need to know what column lengths are available for your flexfield. This is also true for Char format, Numbers Only value sets.
Setting up value set security before Release If you are defining any other Oracle E-Business Suite siite flexfield, you can skip the Indexed check box. This special value set ensures that you enter a positive or negative number, instead of any set of characters, in your flexfield segment.
Though you do not necessarily define a structure for all the values the reference field could contain, a field that has thousands of possible values may not be a good reference field. Enter a unique context field value xuite known as the flexfield structure name under the Code column. If you have legacy systems, you may need to build a program to import your legacy values into Oracle E-Business Suite tables.
If a context field value is required, your flexfield does not allow you to leave the flexfield window without entering a valid suits. Oracle Assets uses the asset key flexfield to group your assets by non-financial information. Indicate whether a context field value is fof.
If you do not have access to Examine, you must use a SQL query in the database to find the ID value from the value set name. Select Apply in the Update Role page to apply your changes to the role adding the grant to the role.
Values and Value Sets
However, if later you needed to add more structures of context-sensitive segments, you could do so by enabling the context field or a reference field, disabling the default context field value, and defining your new context-sensitive segment structure.
Your SQL statement must return exactly one row and one column in all cases. Flexfield value security includes seed data that allows administrators to set up the security. Your flexfield can display different prompts and fields for different end users based on a data condition in your form or application data.
Orracle can simplify users’ report submission by defining hidden parameters and defaulting values users would otherwise need to enter.
Oracle E-Business Suite Flexfields Guide
The following picture shows the specific parameter values we specify as part of creating the grant:. A descriptive flexfield appears on a form as a single-character, unnamed field enclosed in brackets. The main difference is that you use the Concurrent Programs window to define your segments instead of using the Descriptive Flexfield Segments window.
Allow Budgeting Indicate fexfields to allow detailed budgeting to GL accounts with this segment value. For more information, see the Oracle General Ledger documentation.
Security Administration Setup” row. Note also that your Char format type value set remains Char even without alphabetic characters, and your values will behave and sort as character values. If you are creating additional, more specific grants, this grant will also make it seem like those grants are not functioning properly since everyone will already have access to everything.
For those application flexfields that support more than one structure such e-busoness the multiple charts of accounts in the Accounting Flexfieldyou can create a new structure for your flexfield by inserting a row. For example, if you disable old cost centers and enable new ones frequently, you would “use up” cost center values quickly.
Independent An Independent value set provides a predefined list of values for a segment. If you want to set a default value for this segment, identify the type of value you need. You can record and report on information which is directly related to a specific position rather than to the employee. The possible security types are: If payment processing is e-businews in Australia and the Australian Country Code: The other view is for the particular structure you are defining and freezing.
For example, consider the codes your organization uses to identify general ledger accounts.
Some key flexfields use segment qualifiers to hold extra information about individual key site values. There are three predefined permissions that are used in the permission sets listed above.