Exporting Journal Templates

You can export Standard and Recurring journal templates. The groups used by the templates will also be exported.

Any user with the User role and above can export journal templates, but only if they have write access to all the dimension members in the template.

You can also export journal templates through Migration. The templates are exported as part of Journals under the Relational Data artifact. See Administering Migration for Oracle Enterprise Performance Management Cloud.

The following sections are examples of the export file format.

Journal Group Section

This file section uses the syntax to define journal groups.

!GROUP=<journal group>,<journal group description>

Templates Section

!TEMPLATES=<label>,<template group>,<template type>

!DESC=<template description>

!DIMENSION_ORDER=<entity name>,<account name>,<icp name>,<movement name>,<datasource name>,<multigaap name>,<custom1 name>,<custom2 name>

<entity>,<account>,<icp>,<movement>,<datasource><multigaap>,

<custom1>,<custom2>,<amount type>,<amount>,<template entry description>

Example:

!DIMENSION_ORDER=Entity,Acount,Intercompany,Movement

!TEMPLATE=template31,group1,RECURRING

Mexico Sales,CTA,,,,,

Mexico,Sales,CTA,,,C,200,

Mexico,Sales,CTA,,,D,100,

!TEMPLATE=test1,group1,RECURRING

Mexico Sales,Surplus,,,,,

Canada Sales,Surplus,,,,,

Canada Sales,Surplus,,,,,

To export journal templates:

1. On the Home page, click Journals.
2. Click Journal Templates.
3. From the Actions menu, click Export.
4. From the Template Export screen, click Create..
5. Select the location of the import file or files:
   • Local——Saves the export file to a location on your local computer.
   • Outbox——Saves the export file to the server.
6. Select the journal templates to export.
7. For File Type, select an option:
   • Comma delimited—Creates a comma-delimited .csv file.
   • Tab delimited—Creates a tab-delimited .txt file.
   • Other—Creates a .txt file. Enter the delimiter character that you want to use in the export file.
8. From Templates, select Standard, Recurring, or both.
9. Optional: To filter templates by Data Source, select a Data Source member.
10. Optional: To filter templates by Currency, select a Currency, or select All.
11. Optional: To filter journals by Balance Type, select Balanced or Unbalanced. This option is only available if Unbalanced Journals is enabled.
12. If the selected location is Local:
    1. Click Export.
    2. Select the location to save the file and then click OK.
13. If the selected location is Outbox:
    1. Click Save as Job to save the export operation as a job, which you can schedule to run immediately, or at a later time.
    2. Enter a job name and click Submit.
    3. To export the file, click Export
    4. Select the location to save the file and then click OK.
14. You can view the export status in the Jobs console. On the Home page, click Application, and then click Jobs.