Consolidating Data

You can launch the Consolidation or Translation process from a form, and you can view the data status in a data grid. Oracle Financial Consolidation and Close Cloud provides a predefined Data Status grid, which contains entities in the rows, and periods in the columns. The data in the grid is based on the Scenario/Entity/Period/Currency information from the form.


Translation is performed as part of consolidation. For details on the translation process, see Translating Data.

To consolidate data, you must be a Service Administrator, Power User or User, and must also have Write access to the Parent entity to be consolidated.

When you select a base entity to consolidate, the system performs the calculation for the entity only. It does not consolidate to its parent entity.

When you select a parent entity, all descendants of the parent are also consolidated.

If you consolidate data for a period and the data for prior periods has not been consolidated, the data for the prior period is also consolidated. If you select to consolidate the December period and any prior periods are impacted, the system starts consolidation from the first impacted period.

The consolidation process runs for entities that are Impacted. When the process is complete, the status of each successfully consolidated entity changes to OK.

You can use the Force Consolidate option to force consolidation to run on selected cells. For example, if the consolidation process did not properly complete due to an external factor (a database crash, or the user stopped the process), it will leave entities in a processing status. The system may also display an error message that a "failed consolidation needs to be reset". In these cases, you use the Force Consolidate option, which consolidates all entities with data.

You can view the consolidation status in the Jobs console. If you want to run consolidation but there is already a consolidation process running, you can run Force Consolidate.

To consolidate data:

  1. On the Home page, click Data.
  2. From the Forms list, click Data Status.
  3. Select the point of view.
  4. Select a cell for which to run consolidation.
  5. From the Actions drop-down menu, select Business Rules.
  6. From the Business Rules dialog, click Consolidate.
  7. Optional: To force the consolidation process to run for all selected cells, click Force Consolidate.

    You can also run Force Consolidate from the Rules card. See Consolidation and Translation Rules.

    If running from a form, you can add Force Consolidate to the Business Rules option of the Form design. See Selecting Business Rules.

  8. When the consolidation process successfully completes, the system displays a confirmation message. Click OK.
  9. To check consolidation status, open the Jobs console. See Viewing Consolidation Progress.