Instantiating an Oracle Journals for Financial Management Extension Object

The Oracle Journals for Oracle Hyperion Financial Management extension exposes its automation interface through COM.

To make an automation call, an Oracle Journals for Financial Management COM object must first be instantiated.

All Oracle Journals for Financial Management automation functions are defined in the IJournalVBA interface, and the JournalVBA class implements those functions. Therefore, in any Oracle Journals automation call, you must include the variable declarations that are described in the following procedure.

Note:

Before you begin this procedure, you must first complete the steps in Registering the Oracle Journals VBA Functions Using RegAsm, and second, Preparing to Work with Oracle Journals for Financial Management Functions.

To create the variable declarations that will be included in all functions:
  1. Declare a variable of type IJournalVBA.
  2. Set the variable to an object of type JournalVBA.

    The resulting lines are:

    Dim jObj As IJournalVBA
    
    Set jObj = New JournalVBA
    
  3. Include the lines from the previous step in each of your functions.

You are ready to begin creating and working with the Oracle Journals for Financial Management functions. See Oracle Journals for Financial Management Extension Functions for a complete listing of the functions available and their usage.