General Guidelines for Flex Forms

You can modify both row and column members in flex forms.
Any modification to a flex form will not be persisted between sessions.
When a user modifies a flex form, the modified grid layout will only be persisted in the context of the current session. Reopening a flex form reverts the flex form layout to its original state.
You may insert and delete rows and columns in a flex form using the Insert and Delete options on the right-click menu in Excel.
Access permission settings are honored in flex forms.
Valid intersections are honored in flex forms.
Business rules may be run on flex forms.
When a flex form with a business rule or Groovy rule to add a new dimension member (member on-the-fly) is executed from the form, the new member will not appear on the flex form after a refresh. To see the new member on the flex form, you must relaunch the flex form from the Smart View Panel.
Flex forms can be opened as flex forms from a Task List.
There is limited support for spreading in flex forms.
Spreading is supported only in cases where the Account dimension is on rows and the Period is a column dimension and the Period column is not a flex dimension.

Note:

During form design, the Smart View option, Show invalid members for flex form, must be disabled.
You may delete rows and columns using the Delete key. However, when deleting rows or columns containing multiple dimensions, be sure to select all the dimension members in the row or column before pressing Delete.
In the following example, there are three row dimensions on a flex form, Accounts, Market, and Year:

D-Acc US Market FY18

D-Acc US Market FY19

D-Acc US Market FY20

To remove the row for FY18 using the Delete key, be sure to select all three dimension members, D-Acc, US Market, and FY18 using the Ctrl key or Shift key, then press Delete.
Copy and paste is limited to the scope of the form definition. Flex forms must adhere to the hierarchies as defined in the form. Therefore, you cannot have any flex form members that are not part of the defined row or column members of the form.
Subtotaling calculation scripts and currency conversion calculation scripts will be generated and executed based on the original form definition.
In the form definition, if Enable flex form for rows, Enable flex form for columns, or both, are selected, a flex form opened as a simple form can preserve comments in cells outside the form after refresh.
However, when opened as a flex form:
- If both the Enable flex form for rows and Enable flex form for columns options are selected, then comments are not preserved.
- If only the Enable flex form for rows option is selected, then comments entered to the right of the form are preserved after refresh. Comments are not preserved if they are entered directly below the form.
- If only the Enable flex form for columns option is selected, then comments entered below the form are preserved after refresh. Comments are not preserved if they are entered to the right of the form.
When working with flex forms with multiple dimensions on rows or columns (when two or more dimensions with multiple members are placed on a row or columns):
- By design, + and - for expand/collapse are not supported for flex forms. Instead, use the Expand/Collapse command on the right-click Smart View context menu.
- During form definition, to place dimensions members on separate rows or columns, in Member Selection on the flex form, choose Place selection in separate rows or Place Selection in Separate Columns. See Selecting Members for Forms in Administering Planning.
When a user adds a member that is a parent or child of a member already present on a flex form and refreshes, the child member will be collapsed, even in cases where the Dimension property, Start expanded, is selected during form design. To the user, it may look like the child member was removed, but the child member can be viewed by expanding the parent using the Expand/Collapse commands on the Smart View context menu.
When entering numeric member names or shared members on a flex form, enter a single quotation mark ( ' ) before the member name.

For example, for a numeric member name, such as 4077, enter:

'4077

For shared members, enter member names in the format:

'[Parent].[Shared Member]

For example:

'[Sales Director 2].[410]

'[Default_Sales Director 2].[Default_International Sales]
When a flex-enabled form is opened in an ad hoc mode, the row dimension indentation is lost on submitting data. Refreshing the data restores the indentation to normal.
User variables, dynamic user variables, dynamic user variables with attributes, and substitution variables are supported on flex form rows and columns. Users should change variables on the POV and perform a refresh for the rows and columns to update them to the new members.
Excluded members may be entered on flex form rows or columns. Members that are excluded in the form definition can be entered on flex form rows and users are able to enter values and submit.
In the form definition, when Enable flex form for rows, Enable flex form for columns or both are enabled, then the Segment properties Hide and Read-only are not supported for either rows or columns. Hide and Read-only are supported only in simple forms.
An administrator can configure action menus to run business rules or open a flex form or simple form from a flex form (or simple form). The action menu items are accessed from the right-click Smart View context menu. The action menu items may be defined to appear on the right-click menu anywhere on the flex form or when right-clicking, for example, in specific dimensions, members, rows, columns, or cells.

Right-click menus that are available in the web application for the POV and Page dimensions are not available on flex forms in Oracle Smart View for Office.

In Administering Planning, for information on setting up action menu items for flex forms, see Administering Action Menus; for additional information on flex forms, see Designing Flex Forms.