Defining Application Options for Financial Consolidation and Close
Define application and dimension details for Financial Consolidation and Close applications.
To define Financial Consolidation and Close application options:
Table 2-10 Financial Consolidation and Close Application Options and Descriptions
Option | Description |
---|---|
Load Type |
Defaults to "Data" for loading numeric data only. |
Journal Status |
The journal status indicates the current state of the journal. The status of a journal changes when you create, submit, approve, reject, or post the journal. Available options:
|
Journal Type |
Select the type of journal to load. Available options:
|
Journal Post As |
Select the method for posting journal entries: Available options:
|
Create Drill Region |
Select Yes to create a drill region. Drillable region definitions are used to define the data that is loaded from a general ledger source system and specify the data drillable to Data Management. In data grids and data forms, after the regions have been loaded, cells that are drillable are indicated by a light blue icon at the top left corner of the cell. The cell context menu displays the defined display name, which then opens the specified URL. A region definition load file consists of the following information:
|
Enable Zero Loading | Select Yes to load 0 values during a multiple period load. |
Enable Data Security for Admin Users |
Enables data validation when an administrative user loads data. In this case, all data validations in the data entry form are enforced while loading data. Due to the enhanced validations, the performance of data load will be slower. When the ‘Enable Data Security for Admin Users’ is set to No (default value), then data loads by the administrator are performed using the Outline Load Utility (OLU). In this case, performance is fast but you are unable to get a detailed error report for any rows that are ignored for any reason. Note: When running any of the Workforce Incremental rules (for example, OWP_INCREMENTAL PROCESS DATA WITH SYNCHRONIZE DEFAULTS), ensure that then target option Enable Data Security for Admin Users is set to No. This option can only be set by an administrator. When this option is set to Yes, data is validated for administrator and non-administator data loads in the same manner. Validations include: security checks, intersection validations, read-only cells, dynamic calc cells, etc. In addition a detailed error list for any rows that are rejected or ignored is available and no additional Planning permissions are needed. However, performance may be slower even for administrators. |
Enable Drill from Summary |
Select Yes to drill down from summary members in a Planning data form or report and view the detail source data that make up the number. After enabling this option and loading the data with the Create Drill Region option set to Yes, the Drill icon is enabled at the summary level. Drill is limited to 1000 descendant members for a dimension. Note: Summary level drill downs are not available for the Scenario, Year, and Period dimensions. For these dimensions, you must perform a drill through on the leaf members. Summary drill is available for local service instances only. It is not available between cross service instances or hybrid deployments. |
Movement |
Specify the movement dimension that indicates the automated cash flow reporting dimension used through hierarchies and system calculations. By default, the system provides members in the Movement dimension to maintain various types of cash flow data, and FX to CTA calculations. If no movement, then specify as FCCS_No Movement. Otherwise, select the desired movement member. Example of Movement Dimension Members:
|
Multi-GAAP |
Specify the multi-GAAP dimension used to report your financial statements in both local GAAP and in IFRS or another GAAP. This dimension tracks the local GAAP data input as well as any GAAP adjustments. |
Data Source |
Specify the data source dimension. The default value is "FCCS_Managed Source." |
Purge Data File |
When a file-based data load to Essbase is successful, specify whether to delete the data file from the application outbox directory. Select Yes to delete the file, or No to retain the file. |
Member name may contain comma |
If the member name contains a comma, and you are loading data to one of the following services, set this option to Yes, and then load the data:
|
Workflow |
Select the data workflow method. Available options:
|
Drill View from Smart View |
Specify the custom view of columns from the Workbench when displaying customized attribute dimension member names in Oracle Smart View for Office drill-through reports. Note: When drilling into Smart View, Data Integration uses the last used view on the Drill landing page. If no last used view is found, Data Integration uses the default view selection in this setting Custom views are created and defined in the Workbench option in Data Integration. When the custom view has been defined and then specified in the Drill View from Smart View field, in Smart View you can click the drill-through cell and select Open as New Sheet, and the drill-through report opens based on the view defined in the Workbench. If no views are defined on the Application Options page, the default view is used, meaning that attribute dimensions do not display customized member names in Smart View. For more information, see Defining a Custom View in the Workbench |
Default Import Mode |
Sets the default import mode when you execute a data load rule in Data Management or run an integration in Data Integration. Available options:
|
Default Export Mode |
Sets the default export mode when you execute a data load rule in Data Management or run an integration in Data Integration. Available options:
|