Specifying Application Settings

You use the Application Settings page to set preferences for your business process.

To set your business process settings:

  1. From the Home page, click Application, and then Settings.
    Application Settings
  2. Specify defaults for the following application settings:
    • Alias Setting--Select an Alias Table. Under Display Member Label As, select the option that enables the type of member data to be displayed on the Member Selector throughout your application, and enter the label that you want to display:
      • Default—The data determined by the form, grid, or dimension settings

      • Member Name—Only member names

      • Alias—Only member aliases, if defined

      • Member name: Alias —Names followed by aliases, if defined

      • Alias:Member Name—Alias, if defined, is followed by the names

    • Number Formatting--Set the formatting options for:
      • The thousands separator (none, comma, dot, or space)
      • The decimal separator (dot or comma)
      • The display of negative numbers (a minus sign before or after the number, or the number surrounded by parentheses)
      • The displayed color for negative numbers (black or red)

      You can change the number formatting in Application Settings. Your selections apply to all currencies, in all forms that you have access to in the current application. These choices override the settings for individual currencies set by the Service Administrator.

    • Approvals--Select whether to display aliases, show the approval units that are not started, and show approval units as aliases in approval notifications.
    • Notifications--Enable notifications for task lists, approvals, and job console.
    • Page--Set defaults for indenting members on a page and setting the number of items on the page drop-down.


      The Number of Items on the Page Drop-down option lets you shorten the member list so that the Search box can be more easily see. If the list is shortened to 10 members, for example, then you won't need to scroll to see the Search box.
    • Other Options--Set options for date format, attribute dimension data format, partial grid fetch size, and whether to suppress application management options in Oracle Smart View for Office, or Enable Consolidation Rules Logging.
    • Predictive Planning--Predictive Planning options for specifying the scenario or version to use for historical data values, and the prediction interval to use for worst case and best case values. Note that if no version member is specified for historical data, Predictive Planning uses Actual ([current]) as the basis for historical data, which results in using the first version on the form for the historical data.
  3. Specify options for the following System Settings:
    • Display Users' Full Names--If selected, the system displays the user's full name (for example, Victoria Hennings). If cleared, the system displays the user's ID (for example, VHennings).
    • Include Shared Members in Cube Refresh
    • Email Character Set
    • Business Rules Notification--If set to Yes, notifies users or groups when the rules (which are enabled for notification in Calculation Manager) are completed or encounter errors. In Notify These Users, select the users or groups to notify.
    • Allow Drill Down on Shared Members in Ad Hoc Form--Yes enables drilling on shared members in an ad hoc grid. No disables drilling on shared members in an ad hoc grid.
    • Minimize Approval Process Emails--Reduces the number of emails a user receives when using Approvals. The default is No.

      If Yes is selected, only one email notification (for the approved parent entity) is sent to the new owner of the unit. Separate email notifications aren't sent for every child entity in the unit hierarchy. If No is selected, owners that are set at parent nodes will receive emails for the selected note as well as an email for each child node.

    • Enable Use of the Application for --Determines whether users can access the application in administration mode, such as during backups. When you select Administrators, if any nonadministrative users are logged on to the application, they are forced off the system and will not be able to log on. To restore access to an application for all users, select All Users.
    • Assign Application Owner--Assign ownership of the application to another administrator.
    • Enable the Display of Substitution Variables--Set how substitution variables display in the Member Selection dialog box when users respond to runtime prompts in business rules. Display All displays all substitution variables. Display None displays no substitution variables. Enable Filtering displays only substitution variables that are valid for the runtime prompt.
    • Smart View Suppression Behavior--Choose a suppression behavior in Oracle Smart View for Office for cases where rows and columns contain missing data or zeroes.
      • Selecting Legacy suppresses rows, or columns, or both that contain No Data/Missing or Zero, but not both.
      • Selecting Standard suppresses rows, or columns, or both that contain both No Data/Missing and Zero.
    • Smart View Ad Hoc Behavior—Choose to enable enhanced ad hoc features and behaviors in Smart View:
      • Native (default)—Does not enable enhanced ad hoc features.

      • Standard—Enables enhanced ad hoc features.

        The enhanced ad hoc features and behaviors are:

        • In-grid POV—POV members are placed on the grid instead of in the POV toolbar.

        • Submit without refresh—Using the default Submit Data button in the Smart View ribbon, all cells in a grid are submitted, including all data cells that have been explicitly modified (made dirty) and those that were not modified. For this operation, all data cells are marked dirty and submitted. Once the submit operation is complete, the entire grid will be refreshed.

        • Free-form support—Supports empty columns and rows anywhere in a grid and changing the alias table. Additionally, supports member auto-refresh where deleted members are returned to the grid upon refresh.

        • Multiple-grid ad hoc—Supports multiple ad hoc grids on the same Excel worksheet. With multiple-grid ad hoc, you can submit data from any grid on the sheet. Grids based on aggregate storage cubes and block storage cubes are supported on the same sheet. Each grid is independent; for example, if required, you can change the alias table for only one grid on the sheet.

    • Export Planning Smart List textual data during daily maintenance for incremental data import—Choose whether to perform a complete export during the daily maintenance process or to create a business process backup:

      • Yes (default)—Performs a complete export, such that data, including the Planning Smart List data, can be incrementally imported to a business process. (This option may lengthen the maintenance process duration.)

      • No—Creates a business process backup during the maintenance process, such that data can be used as part of a full restoration

    • Link Accounts by Default—For block storage (input) cubes, select whether to cross-reference linked account members by default.

      • Yes (default)—Cross-references will be created on account members, and the business process will work the same way it has in earlier releases.
      • No—Cross-references will not be created for account members, which may improve the business process’s performance. With No selected, after Cube Refresh is run, all existing cross-references on account members will be deleted, and non-source cubes will no longer show data from the source cube.