Add Key Flexfield Columns
You can add a key flexfield type column to a view from the tables available in the view. However, you cannot add key flexfield columns to an LoV view.
To add a key flexfield column
On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.
Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.
Under Columns, click Add, modify & suppress columns, and then click Next. The Modify View » <view label> » Add, modify & suppress columns page appears showing the list of columns available in the view.
In the Add Column list, select the Key flexfield column type, and click Add Column. The Add KFF Column page appears.
In the Column label box, type a label for the key flexfield column that you want to add to the view.
In the Description box, provide a description for the column, which can contain a maximum of 200 characters.
In the Select a key flexfield type list, click a key flexfield that you want to associate with the column. The following key flexfields are available:
Account Aliases
Accounting Flexfield
Asset Key Flexfield
Bank Details KeyFlexField
Category Flexfield
Cost Allocation Flexfield
Grade Flexfield
Item Catalogs
Item Categories
Job Flexfield
Location Flexfield
People Group Flexfield
Personal Analysis Flexfield
Position Flexfield
Sales Orders
Stock Locators
System Items
Territory Flexfield
If you have selected the Item Categories type, the Functional area for Global list will be displayed. Do one of the following:
NOTE: The Functional area for Global list will appear only if the Item Categories key flexfield is selected and the support for generating the global form of the view is enabled.In the Functional area for Global list, click a functional area that you want to associate with the new key flexfield column.
If the key flexfield column returns information about more than one functional area, in the Functional area for Global list, click NONE.
Identify the query in which you want to add the key flexfield column. If the view contains multiple queries, a tab will appear for each query, and the Apply to all queries check box will be available. Select the Apply to all queries check box if you want to add the column with the same settings to all queries. Each query tab also displays the following information:
The profile condition associated with the column. You cannot specify a profile option for a column that is being added because the functionality is not presently supported by the NoetixViews Workbench.
Text indicating that the query is used in at least in one form of the view.
Text indicating that the query pertains to the version of your Oracle E-Business Suite instance.
For all queries or a selected query, do one of the following:
If you have selected the Item Catalogs, Stock Locators, or System Items type in step 7, in the Select the alias for the code combination table <table name> list, click the code combination table for the selected key flexfield. The <table name> indicates the code combination table corresponding to the selected key flexfield.
If you have not selected the Item Catalogs, Stock Locators, or System Items list in step 7, inthe Select the code combination table <table name> or a table with foreign key reference to the code combination table list, click a table in which the key flexfield information is available. The <table name> indicates the code combination table corresponding to the selected key flexfield. If a code combination table is available in the list for the selected key flexfield and you select the table, the primary key column of the selected code combination table will be automatically listed under You have selected a code combination table.
If you have not selected a code combination table in the previous step, in the Select a foreign key column list under You have selected a non-code combination table, click a foreign key column. This list will not be available if a code combination table was selected in the previous step.
Under How do you want your KFF columns displayed in the view?, click one of the following options to specify the condition for generating segment columns corresponding to the selected key flexfield:
Include concatenated values: Includes the concatenated values of all the segment columns. If this option is selected, the Include concatenated segment values column check box is automatically selected.
Include concatenated and individual values: Includes the concatenated and individual values of all the segment columns. If this option is selected, the Include individual segment value columns and Include concatenated segment values column check boxes along with the check boxes corresponding to all the available qualifier columns, if any, are automatically selected.
Include concatenated and individual values and descriptions: Includes the concatenated values, concatenated descriptions, individual values, and individual descriptions of all the segment columns. If this option is selected, the Include individual segment value columns, Include concatenated segment values column, Include individual segment description columns, and Include concatenated segment descriptioncolumn check boxes are automatically selected.
NOTE: The Include concatenated and individual values and descriptions option will be available only if a code combination table is selected.
If you want to generate the global form of the view and specify additional options, select the I want to use the advanced options for Global check box.
Select one or more of the following check boxes corresponding to the additional options:
NOTE: Some options may have been already selected depending on the settings you selected in step 12. You can override these options according to your requirement.Include individual segment value columns: Includes columns corresponding to individual segment values for the selected key flexfield.
Include concatenated segment values column: Includes a column corresponding to the concatenated segment values for the selected key flexfield.
Include individual segment description columns: Includes columns corresponding to the individual segment descriptions for the selected key flexfield.
Include concatenated segment description column: Includes a column corresponding to the concatenated segment descriptions for the selected key flexfield.
If you have selected the Accounting Flexfield in step 7, the check boxes corresponding to the qualifier columns configured in your Oracle E-Business Suite instance will be displayed and automatically selected. You can override these options according to your requirement. The qualifier columns supported for the Accounting Flexfield are as follows:
Intercompany Segment
Management Segment
Natural Account Segment
Cost Center Segment
Secondary Tracking Segment
Balancing Segment
If you have multiple queries, and if you are adding the same column individually to different queries, repeat steps 10 through 15.
Click OK. The Modify View » <view label> » Add, modify & suppress columns page appears with the new key flexfield column that is appended to the list of columns in the view with the state "ADDED".
Repeat steps 4 to 17 to add more key flexfield columns. You can also perform other customizations on view columns, such as addition or modification of columns of any type. For information about these tasks, see the respective topics under Manage View Columns.
In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.
Click Save. The customizations are saved, and the Modify View» <view label> page appears.
IMPORTANT: The column label can contain a maximum of eight characters, must begin with a letter, and can contain only letters, numbers, and underscores. The label cannot be the same as that of an existing key flexfield column. However, the label can match with that of an existing column of a non-key flexfield type with different capitalization.
IMPORTANT: When you add a column to a view that contains multiple queries, you must add the column with the same data type to all queries in the view. If the table that you have selected from the view is not part of one or more queries, a placeholder column of the same data type will be added to the view by the NoetixViews Workbench.
IMPORTANT: When the view contains multiple queries, and if you have selected the Apply to all queries check box, the Select the code combination table <table name> ora table with foreign key reference to the code combination table list or the Select the alias for the code combination table <table name> list will display only those tables that are present in all queries. The list will not display any tables that contain composite primary keys. Also, if you select a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.
Now, you can choose to perform any other customizations on the same view or go to the home page.