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: Fenrigrel Malaramar
Country: Bahrain
Language: English (Spanish)
Genre: Technology
Published (Last): 14 May 2007
Pages: 292
PDF File Size: 20.65 Mb
ePub File Size: 2.82 Mb
ISBN: 839-5-19740-620-4
Downloads: 19448
Price: Free* [*Free Regsitration Required]
Uploader: Kigakasa

Each key flexfield has one corresponding table, known as the combinations tablewhere the flexfield stores a list of the complete codes, with one column for each segment of the code, together with the corresponding unique ID number a code combination ID number or CCID for that code.

If you choose this format type but enter values that appear to be numbers, such as or 20, you should be ssuite that these values will still behave as character values.

The Parent field displays whether the child value is itself a parent value. 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. Controlling access to the creation or modification of value set values can be an important piece of implementing Separation of Duties in an organization. For key flexfields, see: If you must change a value set after it has been attached to a flexfield segment s or a concurrent program parameter syou must first detach it from the e-buusiness s or parameter s.

Once we have chosen values for these two fields, the “Select Parameters” section shows that we should choose an application, a key flexfield name, and a structure.

  CHOUDHARY CHOPDE PDF

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

If your Format Type is Standard DateTime, you maximum size is 20 If you are defining a value set that uses a validation table, your maximum size should reflect the size of the column you specify as your value column. Then, to include the parent valueyou specify the child value range Low to High and give this range a range type of Parent.

If you are not sure if this patch has been applied, you can determine that within the user interface as follows: As with any flexfield, planning how your flexfield pop-up window should flexfieldw and behave is the most important step. If you allow parent values, you can create them for the values in your validation table using the Segment Values window.

This change is for concatenated display purposes only and does not affect your value. Security Administration Flexfjelds wizard to create grants for your role.

Flexfield Concepts

Your selection of available columns depends on the Format Type you specify, and doesn’t necessarily match your Format Type. You should never attach a new value set to your segment where the maximum size of the new value set is e-busiiness than the maximum size of the old value set.

The main difference is that you use the Concurrent Programs window to define your segments instead of using the Descriptive Flexfield Segments window.

You should always use an alias for any SQL expression that is not a simple column name. A new hierarchy range is defined, or an existing hierarchy range is updated or deleted. e-businesx

A foreign key form is a form whose underlying base table contains only one or two columns that contain key flexfield information, and those columns are foreign key columns to the combinations table usually a foreign key to the CCID column of the combinations table and sometimes a structure ID column as well.

  INMON VERSUS KIMBALL PDF

Setting up value set security before Release Your list contains only the default types that have formats that match your value set suie type. A dependent value set is similar to an independent value set, except 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. If you are using flexfields server-side suit, you cannot use form field references: These values are treated and sorted as date-time values, so DEC e-buainess When you accept this value, you can post directly to GL accounts with this segment value.

Enter a grant name and description.

Standard Request Submission

First, you flexfjelds decide whether your users need a predefined list of values from which to choose, or whether they can enter any value that fits the value set formatting conditions. If you are using flexfields server-side validation, you cannot use the INTO clause for your value set. The first situation recursion is where a flexfield calls itself as one of its segments, leading to an infinite chain of pop-up windows.

Plan your flexfield carefully. Throughout this guide we use the “Part Number Key Flexfield” in our examples and graphics.

You can change the title of an existing flexfield structure by typing in a new title over the old title. For ease flrxfields use, we recommend that you set the Description Size for each of your Accounting Flexfield segments to 30 or less so that your flexfield window does not scroll horizontally.