WebCenter Forms Recognition 11.1.1.9 has been Released!

WebCenter Forms Recognition 11.1.1.9 has recently been released:

http://www.oracle.com/technetwork/middleware/webcenter/content/downloads/wcc-11g-downloads-2734036.html

This release includes an updated AP project (1007G). This project includes a number of enhancements:

Language Support

This release of the AP Packaged Project supports processing invoices in Simplified Chinese, Japanese and Korean languages.

A new subclass of the Invoices class, called Invoice_CN, has been introduced for processing Chinese-language invoices. The new subclass also has a further subclass called Invoice_CN2. These new subclasses also have pre-trained learnsets associated with them.

Note that these new subclasses will not be migrated to an earlier version of the project if the Project Migration tool is used to upgrade it. It is strongly recommended that where multi-byte language documents are being processed, a separate project be used for each language. In this case, a new instance of version 1007G of the AP Packaged Project should be implemented, which will already include the subclasses mentioned above.

General Extraction

Enhanced recognition of negative amounts & quantities at line item and invoice header level.

Additional Fields

A new extraction field, called HST, has been added to capture harmonized sales tax for Canadian invoices.

A corresponding new parameter has been added to the project configuration (.ini) file to activate this field. See Section 4.5: TAX Section for further information.

User Interface

The Vendor Search results dialog in Verifier now includes a horizontal scroll bar.

Material Line Pairing

Material line pairing has been enhanced so the system will attach a higher level of confidence to instances where, post line pairing, only one unpaired invoice line and only one unused purchase order line item remains.

User Exits

The following user exits have been added. Refer to the comments within the individual script events in the Designer application for details about when each user exit is called:

• UserExitAppendWorkdoc
• UserExitBatchClose
• UserExitBatchOpen
• UserExitCheckBankAccount
• UserExitCompanyCodeValidate
• UserExitFocusChanged
• UserExitMoveDocument
• UserExitPostImport
• UserExitPostImportBatch
• UserExitPreClassify
• UserExitPreClassifyAnalysis
• UserExitProcessBatch
• UserExitScriptModuleInitialize
• UserExitUpdateSystemSecurity

Reporting

The OCR page count recorded in the AP Project Reporting tables now accounts for multiple reads of the same document.

Oracle AP Features

The OracleAP script class, that was present in version 1007CA, has been removed, and the script has been moved to the GlobalVariables script class. All features included in the previous version of the project continue to be available in this release. The following new features have also been added:

• Separator Page Detection for Supporting Documents
• Export Custom Unit of Measure Value to XML
• Force Validation of Documents Using Custom Invalid Reasons
• Format Line Items in XML for the E-Business Suite Open Interface

Refer to Section 3.2: Solution Features of the Oracle WebCenter Forms Recognition AP Project Guide for full details of these new features.

Configuration

The Verifier output format for dates can now be configured to use the YYYY-MM-DD format. This is configured in the DAT section of the project configuration (.ini) file.


There have also been a number of defect fixes and ini configuration file updates.

How to encrypt the SQL connection string passwords in WebCenter Forms Recognition

This walkthrough will show an example of using WFR's INI File Encryption features as described in section 5.14 of the 11.1.1.8 installation guide.

The Install guide has a good walkthrough of the steps, but it's not 100% specific to the AP Solution. It does require a few decisions not included in the document.

1. You should have your own XML-formate RSA key pair. Brainware states to receive this keypair directly from Brainware support, but Oracle's doc does not include that statement. I've found that the easiest way to generate the key is to use a simple java app to format it as needed. I'll attach a link to the java app at the bottom. Note that this is using java.security, but BouncyCastle should be usable as well, if desired. You can also use the sample keypair provided in the doc, but this should not be used for production as it it not secure (the private key is published in the doc!)

2. Take your ini file and remove the password from the SQL_VL_##_ConnectionString   . The way the encryption works is to decrypt the password, then it will append it back to the ConnectionString before the script actually attempts to create a db connection with it

3. Create a matching SQL_VL_##_ConnectionPassword=<my encrypted password> entry in the ini file. we'll cover how to create the encrypted password a few steps down

4. Open your sdp in Designer. Show Scripts. Go to Sheet #2.

5. Enable the CdrCrypt Reference (figure 5-3 in the install doc)

6. Take the supplied sample script and update to your Private key (be sure to remove any line feeds!), or use the supplied if POC/DEV

7. Paste the script into the fnSetDBConnection (or create your own function and call the function from this location); place it as follows:

On Error GoTo lbl_error

<ADD SCRIPT HERE>

fnSetDBConnection =1
blFoundEmptyConnection = False

8. In a command prompt, cd to <wfr_home>/bin/bin

9. Run the following command to get the encrypted string used in step #3:

DstCrypt.exe /text "MyClearTextPassword" /key "<myPUBLICkey>" >> my_enc_password.txt

10. find your encrypted string at the end of the output:

Text <cleartextpassword> encoded to XBj9I3tuiu+f/XZBH1qIENWGFdoNkmFdtvc3L8LMdBH[...]

11. Paste your enc password into the ini file as stated in #3

12. Save and verify your sdp changes

13. Test!

Troubleshooting tips:
** You can use the script to place file outputs to verify each step of the way.
** If you notice nothing is happening, comment out the "On Error GoTo lbl_error" line; this will allow the errors to output to the RTS console
** If you're getting object errors on the .decrypt function call; make sure you have patched your WFR 11g instance with the two Web Verifier patches; the name of the patch states "Web Verifier", but Patch #2 contains patches for the core products. Also, be sure to deploy both patches since they are not cumulative. Even if you're not using Web Verifier, go ahead and apply these patches.


Oracle may be providing a script sample for this in the future. I'll be sure to update to reflect the supported method. But, as of 2015/04/12, nothing has been published.


Hope that helps!
-ryan

Oracle WebCenter Forms Recognition (WFR) 11.1.1.8.0 now available!

Hey all,

Oracle released WebCenter Forms Recognition 11.1.1.8!

You can get your copy on edelivery. It is under the Oracle Fusion Middleware Product Pack and Windows x86 or x64 platform.

Note that it's not under the typical Fusion Middleware Media Pack, but instead OFR has its own Media Pack. You'll find the product download there.

I don't see the documentation in the 11.1.1.8 document library, but the .zip download does include the updated docs.

You'll also find the updated AP project within the .zip. "AP Packaged Project_1007CA" can be found under the Projects\AP\Global directory.

Stay tuned for more information!

-ryan