Browser version script Skip Headers

Oracle® Fusion Applications Post-Installation Guide
11g Release 1 (11.1.3)
Part Number E22380-04
Go to contents  page
Contents
Go to Previous  page
Previous
Go to previous page
Next

5 Financials

This chapter contains the following:

Setting Up Financial Reporting Center

Setting Up Oracle Document Capture and Oracle Forms Recognition

Setting Up Financial Transactions

Setting Up Financial Reporting Center

Financial Reporting Center Configuration: How It Works

The Oracle Fusion Financial Reporting Center provides entry to General Ledger balances financial reporting functions. It provides secure, self-service access to reports that use real time account information.

You can design traditional financial report formats such as balance sheets, profit and loss statements, and cash flow reports. You can also design nontraditional formats for financial or analytic data that include text and graphics.

The figure shows the main components
in the Financial Reporting Center: Financial Reporting, Account Monitor,
Account Inspector, Smart View, Financial Reporting Workspace, and
Financial Reporting Studio. These components use the Oracle Fusion
General Ledger preaggregated balances as the staring data.

Components

Financial Reporting Center is comprised of numerous components:

Setting up Your Financial Reporting Center: Critical Choices

Oracle Fusion Financial Reporting Center is a powerful tool for accessing, designing, and presenting financial reports and analytic data. The steps needed to configure and install the components in Financial Reporting Center consist of:

Configuring Financial Reporting Center

Users access reports through the folder structure in Workspace. Administrators should define the folder structure in Workspace considering security requirements for both folder and reports, as well as report distribution requirements for financial reporting batches. Security should be set up on folders and reports from Workspace so users can only view the folders and the reports that they can access.

For more information on configuring the Financial Reporting Client including user name, password, server, and report structure, see the following:

Configuring Workspace Database Connection

Administrators need to create database connections from Workspace so users can access the cubes from either Workspace or Financial Reporting Studio.

Note

Ledger setup has to be completed before the database connection can be created. Cubes are created as part of ledger setup. There is a separate cube for each combination of chart of accounts and accounting calendar. A database connection is needed for each cube.

Steps to define a database connection are:

  1. Start at the Navigator by selecting Financial Reporting Center > Launch Workspace

  2. From within Workspace > Navigator > BI Catalog > (main tab), select Tools > Database Connection Manager

  3. Select New button

  4. Enter a user friendly name for the connection

  5. Enter the Essbase server, user and password, and select Application (i.e. cube) and database

For more information on configuring Essbase database connections in Workspace see: Oracle Essbase Database Administrator's Guide for Oracle Essbase

Note

The database connection is available in both Workspace and Financial Reporting Studio. Optionally, it can be setup in Financial Reporting Studio when putting grids on a report. This should only be done by an administrator.

Installing Financial Reporting Studio

Financial Reporting Studio is client-based software. Report authors need to download the installation files in Workspace from Navigator -> Tools -> Download Desktop Integrator Installer to install Financial Reporting Studio.

After completing the installation, obtain financial reporting server information from your system administrator to connect from the local client to the Oracle Fusion instance.

For more information on configuring Financial Reporting Studio client for users, see the following:

Installing Smart View

Smart View is an Excel add-in that must be loaded to each client. Users need to download the installation files in Workspace from Navigator -> Tools -> Download Desktop Integrator Installer and select to install Smart View.

Note

Since Smart View is an add-in to Microsoft Office products, you can install Smart View only on Windows operating system.

Once Smart View is installed, it must be configured to connect to Oracle Fusion Applications. Obtain the Smart View Shared Connections URL information from your system administrator and enter it in Microsoft Excel using the following navigation path: Smart View -> Options -> Advanced -> Shared Connections URL..

For more information on configuring Smart View client for users, see the following:

Setting Up Oracle Document Capture and Oracle Forms Recognition

Installing Oracle Document Capture and Oracle Forms Recognition: Overview

Oracle Fusion Financials uses Oracle Document Capture to scan payables invoices and import expense receipts. Oracle Fusion Payables also leverages Oracle Forms Recognition for intelligent data recognition for invoice entry.

If you plan to implement Oracle Fusion Expenses and use automated receipt image processing, then you must set up Document Capture and configure it for expenses. If you have licensed Oracle Fusion Automated Invoice Processing, then you must set up Forms Recognition in addition to Document Capture, and configure both for payables.

Note

Document Capture for Expenses and Document Capture for Payables require separate installations and configurations on different computers for the default installation.

To set up Document Capture and Forms Recognition, perform these steps in the specified order:

  1. Configure Document Capture and Forms Recognition network shares

  2. Install and configure Document Capture and Forms Recognition on Windows desktop

Note

For details regarding users and privileges for the setup, refer to the installation guides of Oracle Document Capture and Oracle Forms Recognition.

Configuring the Oracle Imaging and Process Management Input Directory Network Share: Procedures

Oracle Document Capture and Oracle Forms Recognition save images to the Oracle Imaging and Process Management input directory for further processing. Since Document Capture and Forms Recognition are Windows-based products, you need to configure the input directory as a network shared directory so that Document Capture and Forms Recognition can save images to this location.

To install network sharing for Oracle Document Capture and Oracle Forms Recognition:

  1. Verify the Oracle Imaging and Process Management input directory

  2. Configure the Network File System (NFS) shared directory

  3. Configure the Windows mapped network drive for the input directory

1. Verify the Oracle Imaging and Process Management Input Directory

To verify the input directory:

  1. Log in to the Enterprise Manager on the Common Domain, as an Administrator.

  2. Log in and navigate to the Domain level.

  3. Select System MBean Browser.

  4. Open the oracle.imaging.config.bean.

  5. Look for the InputDirectories value.

2. Configure the Network Share for the Imaging and Process Management Input Directory

Enable the Imaging and Process Management input directory to be accessed by Document Capture or Forms Recognition running on Windows:

Note

The input directory can be created in a location that is not directly accessible to end users; no end user applications need access to this directory.

The storage host must grant input directory access to the Imaging and Process Management Input Agent running on the Common Domain host and at least one Windows user with login access to the server running Oracle Document Capture and Oracle Forms Recognition.

3. Configure the Windows Mapped Network Drive for the Input Directory

You must log in to the Windows desktop with a user ID that has explicit access to the input directory file share. The Oracle Forms Recognition Windows user can be different from the share Windows user.

This mapping is done on the Windows servers running Oracle Forms Recognition and Oracle Document Capture servers for Expenses only. The drive will not be mapped on individual user machines running Oracle Document Capture client for Invoicing.

  1. Open Windows Explorer.

  2. Right-click on the folder for the PC icon depicting a computer with same name as the PC.

  3. Select Map Network Drive.

  4. Select drive letter, for example Y.

  5. Specify the path for the shared directory on the storage host, using the UNC format: \\<host name>\<name>.

  6. Click OK and verify that the network share now appears in Windows Explorer as the drive letter you specified. If Windows Explorer is unable to create the mapped drive, the issue may be that CIFS is not enabled on the storage host.

  7. Verify that both Windows users and the Imaging and Process Management Input Agent user have read/write access to the Input directory and all of the files it contains. In particular you should ensure that the Imaging and Process Management Input Agent has the ability to read and delete any file written to the input directory by the Windows Oracle Forms Recognition user.

Configuring the Oracle Forms Recognition Project Network Share: Procedures

The Oracle Forms Recognition project directory contains directories and files shared by Oracle Document Capture, Oracle Forms Recognition Designer, Oracle Forms Recognition Verifier, and Oracle Forms Recognition Runtime Service. In a typical installation scenario, these applications are not installed on the same computer. However, the project directory must be stored in a shared directory accessible to each application, regardless of where it is installed.

To configure the Oracle Forms Recognition project network share, do the following:

  1. Configure the share for Oracle Forms Recognition project directory

  2. Configure the Windows mapped network drive for the project directory

1. Configure the Network Share for the Oracle Forms Recognition Project Directory

Enable the Oracle Forms Recognition Project directory to be accessed by Document Capture or Forms Recognition running on Windows.

Note

This directory must be accessible to invoice scanning workstations running Oracle Document Capture. These workstations are typically individual PCs but not servers in the server room.

Configure the storage host to share the Oracle Forms Recognition Project directory with the Oracle Document Capture and Oracle Forms Recognition users.

2. Configure the Windows Mapped Network Drive for the Project Directory

You must log on to the Windows desktop with a user ID that has explicit access to the Oracle Forms Recognition project file share.

Note

This mapping is done on the following:

Perform the following steps to configure the Windows mapped network drive:

  1. In Windows Explorer, identify the folder for the PC icon that displays the same name as that of the actual PC.

  2. Right-click the folder for the PC icon depicting a computer with same name as the PC.

  3. Right-click the folder and select Map Network Drive.

  4. Select a drive letter, for example X.

  5. Specify the path for the shared directory on the storage host, using the UNC format: \\<host name>\<name>.

  6. Click OK and verify that the network share now appears in Windows Explorer as the drive letter you specified. If Windows Explorer is unable to create the mapped drive, the issue may be that CIFS is not enabled on the storage host.

Installing and Configuring Oracle Document Capture and Oracle Forms Recognition on Windows - Part 1: Procedures

To configure Oracle Document Capture and Oracle Forms Recognition to run on Windows, perform the following tasks in the given order:

  1. Install Prerequisites

  2. Install Oracle Document Capture

  3. Configure Oracle Document Capture for Expenses

  4. Configure Oracle Document Capture for Payables

  5. Install Oracle Forms Recognition Designer and Verifier Service for Payables

  6. Install Oracle Forms Recognition Runtime Service for Payables

  7. Configure Oracle Forms Recognition Runtime Service for Payables

Note

Make sure that you have configured Oracle Document Capture and Oracle Forms Recognition network share before performing these steps. Steps 3 to 5 (configuring Document Capture, and installing and configuring Forms Recognition for Payables) are required only if you have licensed Oracle Fusion Automated Invoice Processing.

For more information on performing post-installation tasks, see the Oracle Document Capture Installation Guide and the Oracle Forms Recognition Installation Guide.

1. Install Prerequisites

Before you proceed with the installation and configuration of Oracle Document Capture and Oracle Forms Recognition, you need to fulfill the following prerequisites:

  1. Install and Configure Open Database Connectivity

    Note

    This step is not required for invoice scanning workstations.

  2. Create Data Link

    Note

    This step is not required for invoice scanning workstations.

  3. Install Java Runtime Environment

  1. To install and configure an Open Database Connectivity (ODBC) definition, make sure your Windows machine has a database client installed. For more information, see Oracle Database Software Downloads on Oracle Technology Network at http://www.oracle.com/technetwork. Perform this step on any computer running Oracle Forms Recognition Runtime Service, Designer or Verifier. The Oracle Database client is needed for ODBC support.

    1. Obtain read-only user ID and password for the Oracle Fusion database schema. Oracle Forms Recognition requires this to synchronize its list of vendors with the database and for any additional validation that you configure Forms Recognition to perform against the Oracle Fusion database.

    2. Ensure an ODBC driver is installed on your Windows machine.

    3. Open the Windows tnsnames file, typically found at: <oracle_home>\network\admin.

    4. Add a new entry for the Oracle Fusion database and save the file.

    5. Open Control Panel - Administrative Tools - Data Source (ODBC).

    6. Add a new system database source name (DSN) entry for the Oracle Fusion database and test the connection.

    7. Close the Control Panel.

  2. To create a data link, perform the following on any computer running Oracle Forms Recognition Runtime Service, Designer or Verifier. The contents of the data link are used later when updating the Oracle Forms Recognition project configuration file.

    1. Click the Windows Start menu button.

    2. Select Run.

    3. Enter Notepad into the Open field and click OK.

      Important

      Do not right-click on the desktop to create a new file. Windows will assign a hidden file type to the file that will interfere with the following steps.

    4. Click File - Save.

    5. Navigate to the Desktop folder.

    6. In the File name field, enter the following including quote marks: "<odbc_dsn>.udl".

      Substitute the actual ODBC data source name for <odbcdsn>.

      The file name is the ODBC data source name with the extension udl.

    7. Click Save.

    8. Find the file on the desktop and double-click on it to open the Data Link Properties dialog.

      If a text file is opened instead, you need to go back and carefully follow the instructions for creating this file again.

    9. Set Data Source: <ODBC data source name>

    10. Check the Use a specific user name and password option.

    11. Enter the read-only user name and password.

    12. Check the Allow saving password option.

    13. Click the Test Connection button.

    14. Click OK.

  3. Ensure that Java Runtime Environment (JRE) 1.6 or greater is installed. Perform this step on any computer running Oracle Forms Recognition Runtime Service, Designer or Verifier. For more information, see Java Downloads on Oracle Technology Network at http://www.oracle.com/technetwork.

2. Install Oracle Document Capture

Install Oracle Document Capture from the Companion DVD. You can find the installer at <repository_download_location>/installers/odc. Perform a complete installation. For more information on performing post-installation tasks, see the Oracle Document Capture Installation Guide.

Note

3. Configure Oracle Document Capture for Expenses

To configure Oracle Document Capture for Expenses:

  1. Ensure that the Oracle Document Capture Import-Export Utility is already installed.

  2. Copy the Oracle Document Capture metadata ZIP file - ExmExpenseReportCabinet.zip - from APPLICATIONS_BASE/fusionapps/fin/exm/odc to a temporary directory in the Windows desktop environment.

  3. Go to Start - Oracle Document Capture - Import-Export Utility and sign in (user name: ADMIN, password: admin).

  4. In the Utility, go to File - Import or click on the Import icon and start importing the expense metadata files one by one. Ensure that all files are imported.

    If Oracle Document Capture was a standard complete install, then the import process may fail for the recognition server, which is due to third party licensing issues. Go to Add/Remove Programs, run a Change action on the Oracle Document Capture installation, deselect the FaxPress Provider component for the Import Server, and run the import again.

  5. Create the underlying folder structure within Windows Explorer.

  6. Launch Oracle Document Capture (user name: ADMIN, password: admin).

  7. Go to Admin - File Cabinets.

  8. Expand Expense Reports - Commit Profile - Expense Report Commit Text.

  9. Change the text file folder and document folder according to the Oracle Imaging and Process Management input agent setup. For the packaged configuration, it is set to folder C:\ODC Projects\EXM\Export. This needs to be changed to the shared mapped drive of the Imaging and Process Management input directory. You can use the letter drive notation (for example: Y:/appmgr/Input).

  10. Launch Oracle Recognition Server. Open Programs - Oracle Document Capture - Oracle Recognition Server.

  11. Open Setup - Batch Jobs. Pause the server if this option is grayed out.

  12. In the General tab, blank out the value for Notify by email.

  13. Check Rename batch option and set New Prefix as ERR.

  14. In the Bar Codes tab, set Validation Rule to mask.

  15. Set Mask to 15 pound signs (#).

  16. In the Fields tab, change the document path in the metadata file through these fields:

  17. Launch Oracle Document Capture Import Server. Open Programs - Oracle Document Capture - Import Server.

  18. Launch Oracle Recognition Server. Open Programs - Oracle Document Capture - Oracle Recognition Server.

  19. Launch Oracle Document Capture Commit Server.

4. Configure Oracle Document Capture for Payables

The following procedure describes the Oracle Document Capture configuration for an invoice scanning workstation, for example, a PC connected to a scanner.

To configure Oracle Document Capture for Payables:

  1. Ensure that the Oracle Document Capture Import-Export Utility is already installed.

  2. Copy the Oracle Document Capture metadata ZIP files from APPLICATIONS_BASE/fusionapps/fin/ap/odc to a temporary directory in the Windows desktop environment.

  3. Go to Start - Oracle Document Capture - Import-Export Utility, and sign in (user name ADMIN, password: admin).

  4. In the Utility, go to File - Import, click Import and start importing the Payables metadata files:

  5. Launch Oracle Document Capture (user name ADMIN, password: admin).

  6. Go to System - Batch Setup.

  7. Go to System - Manage Macros and choose Category Electronic Document Provider, select macro AP-I/PM-Commit-Macro, and click the Design icon.

  8. Go to System - Manage Macros, choose Category Scan of ISIS, and select macro AP-OFR-Scan-ISIS-Macro. Click the Edit icon to open it, and then click the Play icon to run it.

  9. Close the macro editor.

  10. Close the Manage Macros dialog.

  11. Go to Admin - File Cabinets.

  12. Choose the Payables Invoice with OFR node from the tree view on the left hand side of the window.

    In the File Cabinet Index Fields panel, you should see a single row with field name URN:

    (URN, Alpha Numeric, 40, NA, NA, Yes)

  13. Expand on Commit Profiles under the node Payables Invoice with OFR.

    In the Commit Profiles panel, AP_INV_OFR should be checked.

  14. Select AP_INV_OFR in the left hand panel; Commit Driver should be set to Commit Text File.

  15. Click the Configure button next to the Commit Driver field to open the Commit Text File Settings dialog.

  16. Verify that Do not create Commit Text File is checked.

  17. Set the Document Folder field to <mapped network drive>\OFR_Projects\AP\Import.

  18. Verify that Create a folder per committed batch is checked and that Store in subfolders is not checked.

  19. Click OK .

  20. Choose Scanning - Manage Scan Profiles to open the Manage Scan Profiles window.

  21. Select Payables Invoice with OFR - Image Source .

  22. Set Default Import Folder to C:\images.

  23. Click the Save icon and close the Manage Scan Profiles window.

  24. Close Oracle Document Capture.

5. Install Oracle Forms Recognition Designer and Verifier Service for Payables

Install Oracle Forms Recognition Designer and Verifier for Payables from the Companion DVD. You can find the installer at <repository_download_location>/installers/ofr. During installation, deselect the Runtime Service so that you only install the Designer Application and Advanced Verifier. You will install the Runtime Service subsequently on a different machine.

You would need only one installation of the Designer. You will install one instance of Verifier on the same computer as Designer. If you will have additional concurrent Verifier users, you will need to install additional instances of Verifier on separate computers.

For more information on performing post-installation tasks, see the Oracle Forms Recognition Installation Guide.

6. Install Oracle Forms Recognition Runtime Service for Payables

Install Oracle Forms Recognition from the Companion DVD, and ensure that Oracle Forms Recognition and Oracle Document Capture are installed on two separate machines. You can find the installer at <repository_download_location>/installers/ofr. However, for Expenses, both Oracle Forms Recognition and Oracle Document Capture can be installed on the same server. During installation, deselect the Designer Application and Advanced Verifier options so that you only install the Runtime Service. The Designer Application and Advanced Verifier were already installed in the earlier step of the configuration process.

This instance of Oracle Forms Recognition should be installed on a secure server accessible only to administrators. Depending on the volume of invoices that you process and your desired processing window, you may need to install Oracle Forms Recognition Runtime Service on additional servers.

For more information on performing post-installation tasks, see the Oracle Forms Recognition Installation Guide.

Installing and Configuring Oracle Document Capture and Oracle Forms Recognition on Windows - Part 2: Procedures

To configure Oracle Document Capture and Oracle Forms Recognition to run on Windows, perform the following tasks in continuation of the tasks in Part 1.

7. Configure Oracle Forms Recognition Runtime Service for Payables

To configure Oracle Forms Recognition for Payables, perform the following steps.

  1. Copy project files to the shared projects directory

  2. Update Oracle Fusion Payables configuration files

  3. Update payables project initialization (INI) file

  4. Configure Oracle Forms Recognition designer

  5. Configure Oracle Forms Recognition runtime service

  6. Configure Oracle Forms Recognition runtime service manager

  7. Configure Oracle Forms Recognition Verifier

7.1 Copy Project Files to the Shared Projects Directory

You need to copy the project files from the Oracle Forms Recognition Designer installation to the mapped drive corresponding to the Oracle Forms Recognition project share. This allows the Runtime Service, Verifier and Designer to use a single project. To perform this step, you must log on to the machine where Designer is installed. The Oracle Forms Recognition project share should have already been mapped to a drive letter on this machine.

To copy project files to a working folder:

  1. Create a new OFR_Projects folder on the drive mapped to the shared projects directory.

  2. Copy <installation directory>:\Program Files\Oracle\Forms Recognition\Projects\AP to <mapped drive>:\OFR_Projects. The files in <installation directory>:\Program Files\Oracle\Forms Recognition\Projects\AP also serve as backups of the active files in <mapped drive>:\OFR_Projects.

7.2 Update Oracle Fusion Payables Configuration Files

To update Oracle Fusion Payables configuration files:

  1. On any computer with a drive mapped to the shared Oracle Forms Recognition project directory, navigate to <mapped drive>:\OFR_Projects\AP\Global.

  2. Rename the file AP_Packaged_Project_1004a.ini as a backup, and copy APPLICATIONS_BASE/fusionapps/fin/ap/ofr/AP_Packaged_Project_1004a.ini to <mapped drive>:\OFR_Projects\AP\Global.

  3. Rename the copied file from AP_Packaged_Project_1004a.ini to AP Packaged Project_1004a.ini such that the file name excluding the extension is identical to the project file: AP Packaged Project_1004a.sdp.

Installing and Configuring Oracle Document Capture and Oracle Forms Recognition on Windows - Part 3: Procedures

To configure Oracle Document Capture and Oracle Forms Recognition to run on Windows, perform the following tasks in continuation of the tasks in Part 2.

7.3 Update Payables Project Initialization (INI) File

To update the payables project INI file:

  1. Click the Windows Start menu button.

  2. Select Run.

  3. Enter Notepad in the Open field.

  4. Click OK.

  5. Open the data link (*.udl) that you previously created and saved to the desktop.

  6. From the *.udl file, copy the whole string starting with Provider=. Once you save the INI file, the UDL file is no longer needed and can be deleted.

  7. Open the AP Packaged Project_1004a.ini file (under <mapped drive>:\OFR_Projects\AP\Global) .

  8. Replace the connection string for the following line with the text copied from the UDL file: SQL_VL_01_ConnectionString=.

  9. Set ASA_OP_01_AlphaNum=YES.

  10. Update attribute ASA_VL_01_ImportODBCDSN with the system DSN name of the Oracle Fusion database.

  11. Update attribute with new SQL statement.

    ASA_VL_01_ImportODBCSelect=SELECT TO_CHAR ( PVS.VENDOR_ID )|| CHR(126) ||
    TO_CHAR ( PVS.VENDOR_SITE_ID ) VENDOR_INDEX,
     PVS.VENDOR_ID, PV.PARTY_NAME VENDOR_NAME,
     PVS.VENDOR_SITE_ID, LOC.ADDRESS1, LOC.ADDRESS2, LOC.CITY, LOC.POSTAL_CODE,
     LOC.STATE, LOC.COUNTRY, PVS.INVOICE_CURRENCY_CODE CURRENCY_CODE
     FROM FUSION.HZ_PARTIES PV, FUSION.HZ_PARTY_SITES PS ,
    FUSION.POZ_SUPPLIER_SITES_V PVS, FUSION.HZ_LOCATIONS LOC
     WHERE PV.PARTY_ID = PS.PARTY_ID AND PVS.PARTY_SITE_ID = PS.PARTY_SITE_ID 
    AND NVL (PV.PARTY_TYPE, 'NULL') <> 'EMPLOYEE' AND PVS.PAY_SITE_FLAG = 'Y' 
    AND NVL (PVS.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE AND NVL
    (PVS.INACTIVE_DATE, SYSDATE) >= SYSDATE AND PVS.LOCATION_ID =
    loc.location_id ORDER BY PVS.VENDOR_ID, PVS.VENDOR_SITE_ID;

     

  12. Update attribute ASA_VL_01_ImportODBCUser with the read-only user name.

  13. Update attribute ASA_VL_01_ImportODBCPWD with the read-only account password.

  14. Search for SRC_VL and update the following attributes as indicated. SRC_VL attributes not specifically shown below should by default be left blank.

    SRC_VL_ID=VENDOR_INDEX
    SRC_VL_SiteID=VENDOR_SITE_ID
    SRC_VL_Name=VENDOR_NAME
    SRC_VL_Address1=ADDRESS1
    SRC_VL_Address2=ADDRESS2
    SRC_VL_City=CITY
    SRC_VL_Zip=POSTAL_CODE
    SRC_VL_State=STATE
    SRC_VL_Country=COUNTRY
    SRC_VL_ExternalVendorID=VENDOR_ID
    
    

     

  15. Search for VND_ and update the following attributes.

    VND_OP_ValidateFromASSA=YES
    VND_OP_CheckConditionVendors=NO
    VND_VL_AlphNumSiteSeparator=~
    VND_OP_IgnorePOVendor=YES
    

     

  16. Search for the string CSV_VL_01_FormatLine1 and replace the portion starting with /slot/emsxxx . . . ./Input/ with the path set up as the Imaging and Process Management InputDirectories property. Keep the | character in front of the path and the portion starting with <%TNF>.tif>|||| . . . fully intact.

  17. Verify your changes.

  18. Save the file.

  19. Close the file.

7.4 Configure Oracle Forms Recognition Designer

To configure Oracle Forms Recognition designer:

  1. In Windows Explorer, double-click on <mapped drive>:\OFR_Projects\AP\Global\AP Packaged Project_1004a.sdp.

    Note

    You are using the shared project directory and not the installation directory.

  2. Log in. (By default, the user is administrator, and there is no password.)

  3. Choose Options - Settings to open the Settings dialog.

  4. Select the Input tab.

  5. Set both Batch-Root and Image Root directories to: <mapped drive>:\OFR_PROJECTS\AP\Batches

  6. Select the Runtime tab.

  7. Set Export Directory to the Imaging and Process Management input directory in the mapped network drive, for example y:\appmgr\Input.

  8. Click OK.

  9. Choose View - Definition Mode to open a tabbed panel on the left side of the window.

  10. Select the Classes tab and select the Invoices node.

  11. Click the Fields tab.

  12. Right-click on VendorASSA and choose Properties to open another tabbed pane on the right side of the window.

  13. On the left side of window, select the ODBC Import tab.

  14. From the droplist, select the ODBC DSN that you defined earlier.

  15. Click the Import button.

    Import updates field names in the Analysis tab and may display an error message. If so, this is expected and not a concern.

  16. Click the Analysis tab.

    1. Select the Enable alphanumeric identifier option.

    2. Select the ID radio button for the VENDOR_INDEX column and deselect the Search option for VENDOR_INDEX, VENDOR_ID, and VENDOR_SITE_ID.

    3. Update Class name format to [Vendor_ID]_[Vendor_Name].

    4. Ensure Field context format is:

      • [VENDOR_INDEX]

      • [VENDOR_NAME]

      • [ADDRESS1]

      • [ADDRESS2]

      • [CITY] [STATE] [POSTAL_CODE]

    5. Deselect the Enable address analysis option.

  17. Return to the ODBC Import tab and click Import again.

    Import should complete with no errors this time.

  18. Click OK .

7.5 Configure Oracle Forms Recognition Runtime Service

Once you have completed customization on the payables project, update the following Runtime Service properties to ensure that the Payables Imaging flow works properly. You will create two Runtime Service Instances. One will be configured for Optical Character Recognition (OCR), Classification and Extraction. The other instance will be configured for Import and Export. If you need to scale up the capacity of your Oracle Forms Recognition installation, you can create additional Runtime Service instances to perform OCR, Classification and Extraction. You can create these by copying settings from the existing instance. You should only have one Runtime Service instance per server performing Import and Export. In this default configuration, you need to run both Runtime Service instances.

  1. Run Oracle Forms Recognition Runtime Service.

  2. In Console Root\Runtime Server, under Runtime Server Administration, perform the following.

    1. Right-click on Runtime Server Administration and choose New RTS Group. Name the new instance FusionAP.

    2. Right-click on FusionAP and choose New Machine

    3. In the Available Oracle Forms Recognition field on the Group Management dialog box, enter localhost.

    4. Keeping the cursor in the Available Oracle Forms Recognition field, press the Enter key. The dialog box will close and the computer will now appear as a node under FusionAP.

  3. Right-click the computer node that you just created and from the context menu, select New - RTS instance.

  4. In the name field, enter AP and click OK.

  5. Right-click AP and select Properties.

  6. On the General tab, do the following.

    Note

    All file paths in the Runtime Service must be specified as UNC paths. You cannot specify a path using a mapped drive letter because Windows services are not allowed access to mapped drives. This is a limitation of Windows services in general. The UNC path will appear as \\<server_name>\<share_name>.

    1. Ensure that the Use project file option is checked and the file specified is <UNC path>\OFR_Projects\AP\Global\AP Packaged Project_1004a.sdp.

    2. Ensure that the Batch Root and Image Root fields are specified as <UNC path>:\OFR_Projects\AP\Global\AP\Batches.

    3. Ensure that the Export path is set to the UNC for the Imaging and Process Management input directory.

    4. Set the Batch Scanning Delay and Mode to Wait to 5 seconds.

  7. On the Workflow tab, click the Import button.

  8. On the Import tab, do the following:

    1. Set the Import Directory to: <UNC path>\OFR_Projects\AP\Global\AP\Import.

      This is the directory where you will set up Oracle Document Capture to commit the image batches.

    2. Check the 1 batch per subdirectory, 1 folder per batch option in the Document Grouping section.

    3. Select Always Import Documents Import Condition.

      Note

      This is for initial testing only. You may wish to adjust this setting in production.

    4. Deselect the Automatic option and specify type as tif in the Document Type section.

  9. Select the OCR+Export+Clean Up tab

    Uncheck the Generate protocol file for each exported batch option.

  10. Click OK.

  11. Right-click on the AP Runtime Service and select Export.... Export AP settings to a file under <mapped drive>:\OFR_Projects\AP.

  12. Create a second Runtime Service instance under FusionAP named AP_IMP.

    Do not configure the instance.

  13. Right-click on AP_IMP and select Import....

  14. Import the settings files that you exported from AP.

  15. AP and AP_IMP will now have identical settings.

  16. Right-click on AP and select Properties....

  17. On the Workflow tab, click the Import and Export buttons to disable these features.

  18. Click OK.

    The AP Runtime Service instance is now configured for OCR, Classification, and Extraction.

  19. Right-click on the AP Runtime Service instance and select Export.... Replace the previously exported settings file <mapped drive>:\OFR_Projects\AP. You can configure additional OCR, Classification and Extraction Runtime Service instances by importing these settings into additional Runtime Service instances.

  20. Right-click on AP and select Properties....

  21. On the Workflow tab, click the OCR, Classification, and Extraction buttons to disable these features.

  22. Click OK.

    The AP_IMP Runtime Service instance is now configured for Import and Export only.

7.6 Configure Shared Drive Access for Oracle Forms Recognition Runtime Service Manager

The Oracle Forms Recognition runtime service manager processes invoice images and exports them to a shared network drive. By default, services cannot access shared drives. The resolution to this issue is to grant the service rights to the user who is granted access to the shared network drive. You must know the password for this user.

  1. Select Start - Control Panel - Administrative Tools.

  2. Select Services.

  3. Right-click Oracle Forms Recognition Runtime Service Manager and select Properties.

  4. Select the Log On tab.

  5. Select the This account radio button, and enter the user name and password of the user granted shared network drive access.

  6. Click Apply and then click OK .

7.7 Configure Oracle Forms Recognition Verifier

Complete this step if you have licensed the "Fusion Automated Invoice Processing option.

  1. Launch the Oracle Forms Recognition Verifier.

  2. Click Options - Settings. The Oracle Forms Recognition Verifier Properties dialog box appears.

  3. In the Use Project File field, enter <mapped drive>:\OFR_Projects\AP\Global\AP Packaged Project_1004a.sdp.

  4. In the Batch Root field, enter <mapped drive>:\OFR_Projects\AP\Batches . Image Root automatically synchronizes with Batch Root.

  5. Click OK. The dialog box closes.

  6. Click File - Save and close the Verifier.

Setting Up Financial Transactions

Configuring Corporate Card Transactions Processing: Explained

Financial transactions between an enterprise and its corporate card issuer need to be carried out in a highly secured environment. To process such transactions, you must establish a secured connectivity between the two. The following sections cover two important security related aspects pertaining to such transactions.

Configuring a Secured Directory

If you are implementing the corporate card feature in Oracle Fusion Expenses, you must set up a secured directory to receive the transaction files sent by the corporate card issuer through a secured connection. Ensure that the Oracle Fusion Enterprise Scheduler Server and the Upload Corporate Card Transactions process must have read/write access to the secured directory to read the transaction file and upload the transactions into the Oracle Fusion Expenses application. For more information on corporate card transaction files and how they are processed, see the Oracle Fusion Applications Financials Implementation Guide.

Verifying Certificate Store for Automatic File Download from American Express

You need this setup if you are implementing the corporate cards feature in Oracle Fusion Expenses, and automatically downloading the corporate card transaction files from the American Express server using Upload Corporate Card Transactions process.

Oracle Fusion Applications use the certificate store located at APPTOP/fusionapps/wlserver_10.3/server/lib/fusion_trust.jks to store all trusted root certificates. Since you connect to an external server, you must verify if all trusted root certificates that are required to connect to the external servers using HTTPS are present in this certificate store. To verify the entries in the certificate store, use the following command:

keytool -list -keystore fusion_trust.jks -storepass password

 

where the password is the administrator password provided at the time of provisioning Oracle Fusion applications.

For more information on downloading corporate card transaction files from American Express, see Oracle Fusion Applications Financials Implementation Guide.

Oracle Fusion Advanced Collections Dunning: Highlights

Oracle Fusion Advanced Collections Dunning feature utilizes Oracle Business Intelligence Publisher to distribute dunning letters to customers via e-mail, fax or print. To use this feature, you must configure Oracle Business Intelligence Publisher to connect to the deploying company's internal e-mail, or the print or fax servers.

Configuring Oracle Business Intelligence Publisher

Enabling Encryption of Sensitive Payment Information: Explained

Financial transactions contain sensitive information and must be carried out in a secure and encrypted mode. In Oracle Fusion Financials, you have the facility to enable encryption process for various payment information. To use that functionality, you must perform the following configuration after installing Oracle Fusion Applications.

Configuration

Perform the following steps to enable encryption of payment information.

  1. Create and empty Oracle Wallet ewallet.p12 using the Oracle Wallet Manager utility.

  2. Do one of the following to create the wallet:

  3. Ensure that the Encryption feature is turned on. You can check it on the setup user interface of the Manage System Security Options task.

  4. After the wallet is created, ensure that you securely delete the file containing the key bits, using a utility that supports secure delete.

For more information, refer to the chapter Define Funds Capture and Payments Security in the Oracle Fusion Applications Financials Implementation Guide.

Configuring Communication Channel to a Payment System: Explained

To transmit or receive payment information from a payment system through a firewall, you will need to configure the communication channel used to communicate with the payment system. You need to do the following:

  1. Configuring and Deploying a Tunnel

  2. Setting up SSL Security for Communicating with Payment System Servlet

1. Configuring and Deploying a Tunnel

To communicate with a payment system through a firewall, you may need to use the tunneling feature of Oracle Payments. Tunneling feature in Oracle Payments is used to deliver data, such as a payment file or settlement batch, using two protocols, one of which encapsulates the other. Tunneling is also referred to as delegated transmission, since the initial transmission from Oracle Payments is a request to an external module (the Transmission Servlet) to deliver data using an independent transmission protocol. The name of the transmission protocol, its parameters, and the actual data to be delivered are encapsulated within the body of the tunneling transmission protocol.

The purpose of tunneling is to allow connectivity between Oracle Payments and external payment systems without compromising network security. Processor payment systems, for example, often require protocols, such as FTP or IP socket connectivity to receive payment instruction files. Instead of creating breaches in their firewall to accommodate these connectivity requirements, users can instead deploy the Payments Transmission servlet on a host outside their firewall and then tunnel or delegate requests to it from the Oracle Payments engine. The Oracle Payments Transmission Servlet does not use the applications database, and can be completely isolated from the intranet of the deployment environment.

Tunneling Protocol

Oracle Payments uses a customized tunneling protocol called the Oracle Fusion Payments Tunneling Protocol. This protocol uses HTTP POST as its underlying transmission mechanism (HTTPS is also supported). When it sends a request, it places an XML message header within the body of the request meant to identify the tunneled or encapsulated protocol, as well as the parameters to use when invoking it, such as host name, user name, and password for FTP. The data to be delivered is sent after the XML message header is sent.

Important

Oracle Payments application, by itself, does not support the tunneling or encapsulation of a tunneling protocol.

As a Payments-supported transmission protocol, the Oracle Payments Tunneling Protocol implements the oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.util.TunnelingFunction interface. The following table presents the parameters and descriptions of the Oracle Payments Tunneling Protocol.


Parameter

Description

WEB_URL

The HTTP/HTTPS URL of the Transmission Servlet executing the protocol

USERNAME/PASSWORD

The username and password used to access the servlet if its URL is secured by HTTP authentication

Transmission Servlet

The Oracle Payments Transmission Servlet is the module which executes tunneled or delegated transmission requests sent from the Oracle Payments engine. The servlet receives the Payments HTTP XML Delivery Envelope requests and parses them into XML message header and transmission data components. The format of the XML message header is defined by an XML DTD file named DeliveryEnvelope.dtd. The message header specifies the transmission protocol as well as the parameters to pass to the tunneled/encapsulated transmission protocol, using its Java class name and entry function name. The Transmission Servlet then dynamically loads the Java class implementing the tunneled protocol, and initiates it by passing to it the transmission parameters parsed from the XML message header and the transmission data.

This behavior is identical to that of the Oracle Payments engine. Any protocol can be tunneled, as long as it implements the oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.util.TransmitFunction interface. Therefore, any custom-defined protocol can be tunneled or encapsulated to the servlet, provided the Java class which implements it is in the CLASSPATH of the servlet's application container. To deploy the servlet to a different host, such as the one in a DMZ network zone, you must copy FinPmtTransmitServlet.war to the Transmission Servlet's new servlet container. If you want the servlet to support any new transmission protocol that you develop, their Java code must be deployed to the TransmitServlet's web application domain.

Configuring Tunneling

Tunneling is configured through the Oracle Payments transmission configuration user interface. A tunneling transmission configuration is specified as any other transmission configuration, but the protocol is always Payments HTTP XML Delivery Envelope protocol. Once the tunneling protocol is configured, it can use or encapsulate any regular, non-tunneling transmission configuration, by specifying a value for the tunneling configuration field in the transmission configuration user interface. Once that is done, ensure that you set up your payment system to support the tunneling protocol, and that your corresponding funds capture process profiles and payment process profiles specify the tunneling configuration.

2. Setting up SSL Security for Communicating with Payment System Servlet

When Oracle Payments communicates with the payment system servlets, the information exchanged may be sensitive information such as credit card numbers. If the communication is not secure, it poses a security risk.

The security risk is higher under the following circumstances.

To set up a payment system servlet with secured sockets layer, enable HTTPS on the middle-tier server where the servlet resides. If funds capture profiles are not defined for the payment system, change the BASE URL parameter of the payment system to use the https: protocol. Otherwise, change the URLs on any transmission configurations set up to be used with that payment system to contain HTTPS.

Configuring Oracle B2B Inbound Flow to Receive Supplier Invoices in XML: Procedures

Oracle B2B Server is an Oracle SOA Suite component that manages interactions between deploying companies and trading partners such as suppliers. Oracle Fusion Payables supports an inbound Oracle B2B flow using Oracle B2B Server for receiving invoices from suppliers in XML format. Trading partners can use this B2B feature to communicate electronically by sending documents in XML format. The B2B XML invoices use the same XML standard 171_Process_Invoice_002 (version 7.2.1) developed by the Open Applications Group (OAG). For more information on B2B XML Invoices, see the Oracle Fusion Applications Procurement, Payables, Payments, and Cash Guide. Customers or deploying companies who want to receive and process invoices in XML format (complying to OAG standards) that are provided by the suppliers, need to perform the following post-installation configurations.

  1. Host Company Configuration

  2. Supplier Configuration

Note

These configurations are required only if customers or deploying companies want to use the B2B XML invoice feature.

1. Host Company Configuration

Perform the following steps to complete Host Company configuration.

  1. Set up the Oracle B2B Server.

  2. Set up Oracle Supplier Network for the Host Company

    Note

    This step is required only if customers use Oracle Supplier Network as the communication channel.

  3. Set up B2B Site Code

  1. To set up the Oracle B2B Server, do the following:

    1. Create a supplier trading partner.

      Note

      The Oracle B2B Server is preloaded with the supported OAG document schemas and sample trading partners such as MyCompany which is the host company trading partner, and ApSampleTradingPartner which is the supplier trading partner. However, you can create your own supplier trading partners as instructed here.

      1. Sign in to the Oracle B2B Server.

      2. On the left, click Add on the Partner toolbar. The Partner Name dialog box appears.

      3. Enter the name of the trading partner and click OK. A confirmation message appears. The new supplier trading partner is listed in the Partner region.

      4. On the Documents tab, click Add to add a document definition for the supplier trading partner. The Select Document Definition dialog box appears.

      5. Select OAG - 7.2.1 - PROCESS_INVOICE_002 - OAG_DEF and click Add. The document definition is added to the supplier and is displayed under Documents.

      6. For the document definition, clear the check box under Receiver.

      7. In the Partner region, select the new supplier trading partner, and on the Agreement toolbar, click Add to add a new agreement between the host company and the new supplier trading partner.

      8. Enter the name of the agreement.

      9. On the process train, click the Select Document Definition train stop. The Select Document Definition dialog box appears.

      10. Select the PROCESS_INVOICE_002 document definition mapped to the supplier trading partner and click OK.

      11. Under Agreement Parameters, ensure that the Functional Ack check box is clear, and click Save.

      12. To validate the agreement, click Validate.

      13. Click Deploy. An information message appears, indicating successful deployment of the agreement.

    2. Set up a listening channel.

      Note

      Oracle B2B Server supports multiple protocols for sending/receiving messages between trading partners. You can choose a protocol that is best suited for your company. Refer to the Oracle B2B Server documentation or online help to learn about each protocol and which parameters need to be set up. Listening channel can be set up at the global level (applicable to all trading partners) or at the trading partner level.

      Do one of the following:

      • To set up a global listening channel, click Administration and click the Listening Channel tab.

      • To set up a trading partner listening channel, click Partners and click the Channels tab.

      • No need to set up a listening channel if Oracle Supplier Network is used by the suppliers to send the B2B invoice payload.

        Note

        When Oracle Supplier Network is used, the only required setup to communicate with the supplier trading partner is to add a Generic Identifier on the B2B Server, using the IP address of the Oracle Supplier Network server as the value of the identifier. The Generic Identifier entry is added to the Identifiers table on the Profile tab of the trading partner page. If you do not know the IP address of the Oracle Supplier Network server, consult your system administrator.

      Save the changes to complete the set up.

  2. Set up Oracle Supplier Network for the Host Company if the supplier uses Oracle Supplier Network to send the B2B invoice payload. To complete the setup, perform the following:

    1. Sign into the Oracle Supplier Network using the registered account.

    2. Access Messaging - Communication Parameters and select HTTPS URL Connection as the Delivery Method.

    3. Click Modify to update the delivery method parameter values.

    4. Enter the URL of the B2B HTTP receiver. Consult your system administrator if you do not know the value.

    5. Enter the User ID and password for Oracle Supplier Network.

      Note

      You can specify different values for the Test and Production environments.

    6. Access Messaging - Transaction Management.

    7. Add the OAG PROCESS_INVOICE_002 document from the list of available documents if it is not already added.

    8. From the Action drop down list, select Receive.

    9. From each Delivery Method drop down list (OSN Test Delivery Method and OSN Production Delivery Method), select HTTPS URL Connection and click Submit.

    10. On the Trading Partners tab, in the Add Trading Partners region, click Add to add supplier trading partners. You can add all the supplier trading partners who send invoice payloads to the host company.

  3. Set up the B2B Site Code.

    For each supplier site that is enabled for B2B communication, the host company assigns a B2B Site Code to the site and communicates it to the supplier. Supplier has to provide this B2B Site Code in the invoice payload in the <PARTNER><PARTNRIDX> element, with <PARTNER><PARTNRTYPE> = Supplier within the <INVHEADER> element. To assign a B2B Site Code to a supplier site, navigate to the Manage Suppliers UI in the Fusion application. Search for the supplier and then open the supplier site. Enter a value into the B2B Supplier Site Code. Click Save. This code needs to be communicated to the suppliers manually so that they can include it in their invoice payloads.

    To assign a B2B Site Code to a supplier site, do the following:

    1. In Oracle Fusion Applications, access Suppliers - Manage Suppliers.

    2. Search for the specific supplier and open the relevant supplier site.

    3. On the Edit Site tab, in the B2B Trading Partner Information region, enter the site code (the site code set by the host company in Oracle B2B Server) in the B2B Supplier Site Code field.

    4. Click Save.

    Communicate the same site code to the suppliers.

2. Supplier Configuration

The following configuration steps must be performed by suppliers if they are using Oracle Supplier Network to send the invoice payload.

  1. Sign in to the Oracle Supplier Network using the registered account.

  2. Access Messaging - Communication Parameters and select HTTPS URL Connection as the Delivery Method.

  3. Click Modify to update the delivery method parameter values.

  4. Enter the URL of the B2B HTTP receiver.

  5. Enter the User ID and password for Oracle Supplier Network.

    Note

    You can specify different values for the Test and Production environments.

  6. Access Messaging - Transaction Management.

  7. Add the OAG PROCESS_INVOICE_002 document from the list of available documents if it is not already added.

  8. From the Action drop down list, select Send.

  9. From each Delivery Method drop down list (OSN Test Delivery Method and OSN Production Delivery Method), select HTTPS URL Connection and click Submit.

  10. On the Trading Partners tab, in the Add Trading Partners region, click Add to add host company trading partner.