Enabling Calc on the Fly

For ad hoc, service administrators enable calc on the fly in the web application; users enable it in User Preferences. For Forms 2.0, form designers enable calc on the fly in the required forms.

Enabling Calc on the Fly for Ad Hoc Grids

Service administrators can enable member formulas for calc on the fly in the web application and users can enable them in users preferences. The member formulas are referred to as "user formulas" in the web application settings. These formulas must be enabled at following levels, so that users can use them for performing calc on the fly.

• Enable at the application level: As a service administrator, select the Yes option from the Enable User Formulas in Ad Hoc list present under Other Options in Settings. For more information, see:
  • What Application and System Settings Can I Specify? in Administering Planning
  • What Application and System Settings Can I Specify? in Administering and Working with FreeForm
  • Specifying Application SettingsSpecifying Application Settings in Administering Financial Consolidation and Close
  • Specifying Application Settings in Administering Tax Reporting
  • Application Settings in Administering and Working with Enterprise Profitability and Cost Management
• Enable at the user preference level: As a user, select the Yes option from the Enable User Formulas in Ad Hoc list present under Display in User Preferences. Note that this user preference setting overrides the application setting set by service administrators. For more information, see:
  • Setting Your Display Preferences in Working with Planning
  • Setting Your Display Preferences in Working with FreeForm
  • Setting Your Display Preferences in Working with Financial Consolidation and Close
  • Setting Your Display Preferences in Working with Tax Reporting
  • Display Preferences in Administering and Working with Enterprise Profitability and Cost Management

Enabling Calc on the Fly for Forms 2.0

Calc on the fly is available only in Forms 2.0 for applications on which the Redwood Experience has been enabled.

• Enable Forms 2.0: To work in Forms 2.0, select the Forms 2.0 option from the Forms Version list in Settings. For more information, see:
  • About Forms Versions in Working with Planning
  • About Forms Versions in Working with FreeForm
  • About Forms Versions in Working with Financial Consolidation and Close
  • About Forms Versions in Working with Tax Reporting
  • About Forms Versions in Administering and Working with Enterprise Profitability and Cost Management

  Note:

  Forms 2.0 is available only for applications on which the Redwood Experience is enabled. For more information, see Customizing EPM Cloud Appearance in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
• Enable Calc on the Fly: Select the Enable Calc on the Fly check box under the Grid Properties section in the Layout tab of a form. Note that this setting needs to be enabled for each form on which you wish to perform calc on the fly. For more information, see:
  • Setting Form Grid Properties in Administering Planning
  • Setting Form Grid Properties in Administering FreeForm
  • Setting Form Grid Properties in Administering Financial Consolidation and Close
  • Setting Form Grid Properties in Administering Tax Reporting