Registering the Oracle Journals VBA Functions Using RegAsm

Before you begin creating and editing VBA functions for Oracle Journals for Financial Management, you must register the Oracle Journals for Financial Management DLL using RegAsm.

To register the Oracle Journals DLL using RegAsm:
  1. Note the file location of the Oracle Journals DLL (Journals.dll); generally, located in:
    %APPDATA%\Oracle\SmartView\extensions\Bin\Oracle.SmartView.SVFMJournal\bin
    
  2. From Windows Explorer, navigate to the Oracle Smart View for Office installation directory; generally located in:
    C:\Oracle\SmartView\bin
    
  3. Copy the Oracle.SmartView.Interop.SVRC.dll file from this location to the Oracle Journals file location noted in step 1.
  4. As administrator, open a command prompt and navigate to one of the following locations:
    • For Microsoft Office 64-bit:

      C:\Windows\Microsoft.NET\Framework64\v4.0.30319
      
    • For Microsoft Office 32-bit:

      C:\Windows\Microsoft.NET\Framework\v4.0.30319
      
  5. Execute the following command:
    regasm /codebase /tlb <file path from Step 1>\Journals.dll

    You should see this message:

    "Assembly exported to %APPDATA%\Oracle\SmartView\extensions\Bin\Oracle.SmartView.SVFMJournal\bin\Journals.tlb and the type library was registered successfully."
    

    Any warnings can be ignored.