1. Working with Financial Consolidation and Close
  2. Working with Consolidation Journals
  3. Importing Consolidation Journals

Importing Consolidation Journals

You can import Consolidation journals and groups to load them in to the system. You can import:

  • Working journals

  • Posted journals (if workflow is not enabled)

  • Journal Groups

You can also load journal data through Data Management by defining a journal data rule. Both Excel and text-based journal load are supported. See Administering Data Management for Oracle Enterprise Performance Management Cloud.

To import a journal, you must be assigned the application role of Consolidation Journals - Create. You must also have access to all the entities in the template.

Before you import journals, you must create journal files. See Creating Consolidation Journal Files.

An administrator can enable a journal workflow for creating, submitting and approving journals. If the Journal Workflow is enabled, you can only import Working journals. If the Journal Workflow is disabled, you can import Working and Posted journals.

When you import Posted journals, the system creates Working journals in the system if the period is not opened, and the status is changed from Posted to Working during import.

You can import multiple journal groups and journals in a single file. You import Journals using the Replace mode, which clears all data for a particular journal label before importing the new journal data.

Importing journals is a sequential process. You should specify the Journal Group first, since the journal group can be referred to in journals. If importing a specific group or journal fails, the import process continues importing the other groups and journals.

Importing Journal Groups

During the import process, the system creates a new journal group if a journal group with the same name does not exist in the system.

If a journal group with the same name already exists, the import process deletes the existing journal group, and creates the new journal group with the new details.

Importing Journals with the Workflow Enabled

If the Journal Workflow is enabled, you can only import Working journals. Journals progress through the Workflow, for example, from Working to Posted status. A journal with a Working status can be new or can already exist in the system. When you import journals, the system replaces the journals that already exist in the system.

Importing Journals with the Workflow Disabled

If the Journal Workflow is disabled, you can import Working and Posted journals.

Table 9-1 Importing Journals Actions with Workflow Disabled

Import Journal Status Journal Workflow Journal with same label already exists Journal Import Process action
Working Enabled/Disabled No Create a new journal
Working Enabled/Disabled Yes with Working status Replaces the journal
Working Enabled/Disabled Yes with Submitted, Approved or Posted status Fails to process the journal
Posted Disabled No Create a new journal
Posted Disabled Yes with Working status Replaces the journal and posts it
Posted Disabled Yes with Posted status Fails to process the journal

To import journals:

  1. On the Home page, click Consolidation Journals, then select Manage Journals.

  2. From the Actions menu, click Import.

  3. From the Journal Import screen, click Create.

  4. Select the location of the import file or files:

    • Local—Loads the import file or files from a location on your computer. Click Browse to select the import file.

    • Inbox—Loads the import file or files from the server. Enter the name of the file.

  5. For File Type, select an option:

    • Comma delimited

    • Tab delimited

    • Other. Enter the delimiter character that is used in the import file.

  6. If the selected location is Local:

    • Click Import.

    • From the "Job submitted successfully" confirmation, click Close.

  7. If the selected location is Inbox:

    • Click Save as Job to save the import operation as a job, which you can schedule to run immediately, or at a later time.

    • Enter a job name and click Submit.

    • To import the file, click Import

    • From the "Job submitted successfully" confirmation, click Close.

  8. You can view the import status in the Jobs console. On the Home page, click Application, and then click Jobs.