Extracting Journals

You can extract journals, recurring journals, and journal templates from an application. You can select the Scenario, Year, Period, Entity, and Value dimensions for which to extract journals. You can select the journal status, journal type, and journal balance type to extract.

When you extract journals, they are saved to an ASCII file that supports multibyte character sets (MBCS). By default, journal files use the JLF file extension. After you extract journals, you can view and modify the journal information in a text editor.

You can extract automated consolidation journals to external systems, however you cannot re-import them into Oracle Hyperion Financial Management. When you extract these journals, the Balance type is blank for automated consolidation journals.

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

To extract journals:

1. Select Consolidation, then Extract, and then Journals.
2. Specify a Scenario and Year from which to extract journals.
3. Optional: Select a Period from which to extract journals.
4. Optional: Select one or more Entity and Value dimensions to extract.

   To extract automated consolidation journals, you must select [Proportion] and/or [Elimination] as the Value member.

   Note:

   For the Period, Entity, and Value dimensions, if you do not select specific members, the system assumes that you want to extract all members for the dimension. However, if you specifically select members, the system displays a plus sign (+) next to the dimension to indicate multiple selections.

5. 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.

6. Select Journal Types to extract:

   • Templates

   • Recurring Templates

   • Journals

7. Optional: Enter the Label and Group for the journals to extract.

   You can use the percent sign (%) as a wildcard.

   For automated consolidation journals, in the Label field, you can query on the Nature value of the audit transaction that you specified in the consolidation rule. You cannot use a number for the label.

8. Select the journal Status, Type, and Balance Type to extract, or select All.
9. Click Extract.
10. Follow the download instructions displayed in the browser.

The instructions vary depending on the Web browser that you are using. Make sure to save the file in the Web directory that you set up.