If your flexfield definition is frozen that is, the Freeze Flexfield Definition check box is checked , this window becomes display-only. You can define as many segments as there are defined segment columns in your flexfield table. You can create a new segment for your flexfield by inserting a row. Note: If your flexfield definition is frozen, the Segments window fields are not updateable. Before defining segments, use the Key Flexfield Segments window or the Descriptive Flexfield Segments window to define your flexfield structure.
|Published (Last):||14 August 2019|
|PDF File Size:||6.53 Mb|
|ePub File Size:||3.64 Mb|
|Price:||Free* [*Free Regsitration Required]|
Creating a Flexfield View Using Flexfield Views to Write a Report When you want to write a report on Oracle E-Business Suite data, you typically want to report on information that is not directly related to flexfields, but that includes flexfields data as part of that information. The information you want is about the orders themselves, such as the name of the client who placed the order, the date of the order, the number of objects ordered, and so on. However, part of the order is information about what objects your client ordered, and that information is in the form of a flexfield: your Part Number Key Flexfield.
It would not contain columns for the individual segments of the key flexfield. However, your report would not be very meaningful to its readers without the segment values for your part number and your readers are not likely to know the unique ID number associated with each part number flexfield combination. You need a way to display the part number combinations instead of the unique ID numbers in your report about orders.
You use your key flexfield view for this purpose. The columns shown in bold print are columns that particularly pertain to the flexfield itself. You should note the differences between the boldfaced columns in the underlying table and those in its view. These other columns all appear in your flexfield view because they are not columns used by the Accounting Flexfield directly. HEAVY structure has five segments as well, square footage cargo, number of axles, transmission type, insurance company, and insurance policy number.
The resulting view contains a total of eleven segment columns, rather than twelve, for the three structures. See: Descriptive Flexfield Segments. Some assets, such as asset number , while they belong to structures with enabled segments, do not have values filled in for the descriptive flexfield. Prudential Paris Stor. OPEN 69 Conf. Prudential 58 Rome Stor. Display segment values, prompts, or descriptions from multiple flexfield structures or contexts in the same report.
Display segment values, prompts, or descriptions from different flexfields in the same report. Display two or more flexfield segment values, prompts, or descriptions, concatenated with delimiters, in the correct order. This includes description information for dependent, independent, and table validated segments. Restrict output based upon a flexfield range low and high values.
Prevent reporting on flexfield segments and values that users do not have access to flexfield value security. Specify order by, group by, and where constraints using one or more, or all segment columns. Related Topics.
Key Flexfields in Oracle E-Business Suite
Welcome to Release This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Computer desktop application usage and terminology. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Documentation Accessibility Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology.
Planning and Defining Descriptive Flexfields
Overview of Setting up Flexfields Key Flexfields Most organizations use "codes" made up of meaningful segments intelligent keys to identify general ledger accounts, part numbers, and other business entities. Each segment of the code can represent a characteristic of the entity. Both of these part numbers are codes whose segments describe a characteristic of the part. Although these codes represent the same part, they each have a different segment structure that is meaningful only to the organization using those codes. The Oracle E-Business Suite stores these "codes" in key flexfields.
Reporting on Flexfields Data
See: Value Sets. You cannot create a new flexfield using this window. You can change the flexfield title by typing in a new name over the old name. You see this name whenever you select a descriptive flexfield and as the window title whenever a user enters your descriptive flexfield. Freeze Flexfield Definition The default value for this field is unchecked flexfield definition not frozen. Do not freeze your flexfield if you want to define new structures, set up or modify your flexfield segments, or change the appearance of your descriptive flexfield window. You cannot make most changes while the flexfield is frozen.