Data source types: Oracle Hyperion Financial Management
During a financial period, you may need to adjust data after it is entered or loaded into base-level entities. Oracle Journals for Financial Management 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.
With Oracle Journals, you can:
Create double-sided journal entries by using debits and credits
Balance entries, or permit single-sided, out-of-balance entries
Create recurring journals that are repeated for a number of future periods
Create auto-reversing journals that generate reversing entries in the next time period
Use the journal approval process to provide accountability
After creating a journal, you submit it to your supervisor for approval before posting it to the database.
In Oracle Smart View for Office, Oracle Journals for Financial Management is an extension that supports a subset of the Journals functionality found in the Financial Management web interface. Before you can use Oracle Journals, you must install and enable the extension. After connecting to a Financial Management data source, right-click a Financial Management application to view two journal commands in the Action Panel:
Manage Journals—Launches the Manage Journals dialog box. When you select a journal to work with, the Oracle Journals ribbon is displayed.
Create Journal—Launches the Create Journal dialog box.
When you select a journal to work with or create a journal, the Oracle Journals ribbon is displayed. Ribbon actions are available to you on a context basis; for example, if the journal is available for editing, the Edit button is enabled.
With the Oracle Journals for Financial Management extension in Smart View, you can perform these journal tasks:
Open a journal and view its properties, such as Status, Type, Balance Type, Group, and Class
Create a new blank journal or create a journal using a standard or recurring template
Create a journal from data grids or data forms opened in Excel using the right-click option in the grid or form, or the Create Journal command in the ribbon
Create an ad hoc query from within a journal.
Edit and save journals
Submit, Unsubmit, Approve, Reject, Post, Unpost, and Delete journals
Open an Entity Detail Report from data grids or data forms, and from an Entity Detail report, click on a journal to drill down for further details
Additionally, in Smart View, you can analyze posted journals to see the adjustments and totals in an ad hoc grid. You can analyze selected rows, or analyze the entire journal.
Get started by installing the Oracle Journals for Financial Management extension, following the instructions in Installing the Oracle Journals Extension.
Note:
The Oracle Journals for Financial Management extension works with Smart View version 11.1.2.5.500 and later, and with Financial Management 11.1.2.4.100 and later.