Loading Journals

You can load working, rejected, submitted, approved, and posted journals as well as standard and recurring journal templates. You cannot load automated consolidation journals because they are created by the consolidation process.

Before you can load journals, you must first open the periods to which to load journals. See "Managing Periods" in the Oracle Hyperion Financial Management User's Guide.

Journals are loaded using the Replace mode, which clears all data for a particular journal label before loading the new journal data. You must load posted journals to periods that are open. If you load a posted auto-reversing journal, an approved reversal is automatically generated in the next period, and you must manually post the generated reversal.

By default, journal files use the JLF file extension. The load process accepts other file extensions such as TXT or CSV, however, Oracle recommends that you use the JLF file extension.

When you change the default load options, the options are updated for all the rows. You can use the Override option to enable a specific row and update the options for that row.

When the load process is complete, a link displays for the log so that you can view any errors.

Note:

Oracle recommends that you add Oracle Hyperion Financial Management to the exceptions for your Web pop-up blocker. When you perform some tasks such as loading data, a status window pops up showing the task status. If you have a pop-up blocker enabled on your computer, the status window is not displayed.

To load journals:

  1. Select Consolidation, then Load, and then Journals.
  2. For Delimiter, enter the delimiter used to separate the journals data in the file. These characters are valid: 
    , ~ @ $ % & ^ | : ; ? \

    Note:

    Use a character that is not used in the file name or in any other way in the file. For example, if you use the comma in an entity description, you cannot use the comma as the delimiter.

  3. Optional: If you are using Firefox as the browser, you can load multiple files. Select Multiple selection if it is not already selected, and click Browse to locate the files.

    You can select a maximum of 10 files at one time. The system then populates the detail rows with the selected files.

    You can also drag and drop files into the File Selection Content area.

  4. Optional: Click Add to add more rows for loading journals.

    Tip:

    To delete a row, select a row and click Delete.

  5. Optional: To override the default file settings for a row, click Override.

    Tip:

    To reset the load options to the default values, click Reset.

  6. Click Load.

    Note:

    If you reload existing files, the system displays a warning prompt asking if you want to use them again. If you do, click Yes.