Support for Time Period Spreading and Grid Spreading in Flex Forms

Oracle Smart View for Office (Mac and Browser) now supports spreading of data for time periods and grid spreading in flex forms. This ability was earlier restricted to regular forms only.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

To perform time period spreading, first select the Spreading Enabled check box in the Data tab in Smart View Options and then enter the new value that you need to spread across time periods as per the defined spreading rules.

To perform grid spreading, you can enter a value or percentage to increase or decrease an existing value or enter a new spread value. The value is spread to the related cells as per the selected spread pattern.

Business Benefit: Users now have the same capability of spreading data in flex forms, just the way they use spreading in regular forms.

Tips And Considerations

Spreading is supported only in cases where the Period dimension is not a flex enabled. If the Period dimension is in a column, then flex should not be enabled on columns. Similarly, if the Period dimension is in a row, then flex should not be enabled on rows.

Key Resources