Loading Journals

Many external general ledger systems can generate ASCII text files containing journal information that you can load into a Financial Management application. If necessary, you can edit the file before loading it into your Financial Management application.

Sample journal (.jlf) files that you can use to model your journal file are in the EPM_ORACLE_HOME/products/FinancialManagement/SampleApps directory.

Journals are loaded using the Replace mode, which clears all data for a journal label before loading the new journal data. Financial Management administrators can load working, rejected, submitted, approved, and posted journals as well as standard and recurring journal templates.

Note:

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

You can only replace working and submitted journals. You cannot overwrite approved or posted journals.

  To load journals:

  1. Open a Financial Management application.

  2. In Browser View, expand Tasks, and then select Load Tasks.

  3. Select Load Journals.

  4. In Journal File, enter the file name to load, or click Browse and find the file to load.

  5. In Delimiter Character, specify the character that is used to separate information in the file.

  6. Specify other settings as needed. Consult online help for assistance.

  7. Click Load.