1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Using Journal Templates to Import Data

Using Journal Templates to Import Data

In Oracle Hyperion Financial Management, you use journals to adjust data after it has been entered or loaded into base level entities. Journals provide an audit trail of changes made in the application and indicate, which users made adjustments and which accounts, entities, and time periods are affected.

Oracle Hyperion Financial Data Quality Management, Enterprise Edition enables you to load Financial Management journal entries with journal templates. These templates are Excel spreadsheets that are formatted as journal entry input screens.

FDMEE journal templates are typically used for the following types of adjustments:

  • GAAP adjustments to general ledger files

  • Transformations of gross balance accounts into roll-forward accounts (Beg, Add, Del, End)

  • Supplemental data entries (Head Count, Ratios, and so on)