Tuesday, January 26, 2016

Keep Current! - WebCenter Patches as of 2016/01/26

Hey all, 

In an effort to help everyone stay current, we're going to post some preferred patches on a regular schedule. This way, you'll have a single place to find all of the updated cumulative patches (MLRs, ARUs, Bundle Patches, etc) for the month.

Please be sure to let me know if there's any other patches that should be included on this list. The current format has the support recommended installs in bold & underlined, but there are some other nice-to-know patches included as well. These nice-to-know patches may not be necessary for your particular installation.

The formatting may change over time, but hopefully this is helpful!

** As always, please be sure to do your own due diligence before applying any patch. This list is for reference only.

(Now managing this list in an excel file. Much easier to manage than that terrible table!)

Link to Keep Current spreadsheet

Friday, December 4, 2015

WebCenter Forms Recognition 11.1.1.9 has been Released!

WebCenter Forms Recognition 11.1.1.9 has recently been released:





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.


Wednesday, October 21, 2015

Keep Current! - WebCenter Patches as of 2015/10/21

Hey all, 

In an effort to help everyone stay current, we're going to post some preferred patches on a regular schedule. This way, you'll have a single place to find all of the updated cumulative patches (MLRs, ARUs, Bundle Patches, etc) for the month.

Please be sure to let me know if there's any other patches that should be included on this list. The current format has the support recommended installs in bold & underlined, but there are some other nice-to-know patches included as well. These nice-to-know patches may not be necessary for your particular installation.

The formatting may change over time, but hopefully this is helpful!

** As always, please be sure to do your own due diligence before applying any patch. This list is for reference only.

(Now managing this list in an excel file. Much easier to manage than that terrible table!)

Link to Keep Current spreadsheet

Tuesday, April 21, 2015

Keep Current! - WebCenter Patches as of 2015/04/21

Hey all, 

In an effort to help everyone stay current, we're going to post some preferred patches on a regular schedule. This way, you'll have a single place to find all of the updated cumulative patches (MLRs, ARUs, Bundle Patches, etc) for the month.

Please be sure to let me know if there's any other patches that should be included on this list. The current format has the support recommended installs in bold & underlined, but there are some other nice-to-know patches included as well. These nice-to-know patches may not be necessary for your particular installation.

The formatting may change over time, but hopefully this is helpful!

** As always, please be sure to do your own due diligence before applying any patch. This list is for reference only.

(Now managing this list in an excel file. Much easier to manage than that terrible table!)

Link to Keep Current spreadsheet

Monday, April 13, 2015

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

Wednesday, February 25, 2015

WebCenter Content - Component Development Tips and Tricks

Hey all,

There was recently a good discussion on the Oracle Forums about building components (https://community.oracle.com/message/12917711). There was some discussion about different methods people use, but there was an idea to get together to build something useful for the community. I wanted to provide my method and utility.

I have an ant build script that serves two general purposes: create new components and build existing components. Let's first go over the parts and dependencies of the utility.

There are a few pieces expected by the utility:


  • build.xml
  • a "Template Component"
  • fart.exe
Yes, fart.exe.

Let's go ahead and get that one out of the way :)

FART stands for "Find And Replace Text command line utility". The ant script uses this to rename the files and directories inside the template component to whatever actual component name you're cloning.

You need to install that utility (http://sourceforge.net/projects/fart-it/) and update the build.xml to the correct path.

Next is the "Template Component". In order to create components for you to work with, there needs to be a template. this is the core structure of a component with the (more or less) universal defaults in place. This will be your starting point when you're creating a new component. pretty nice to be able to not have to remember the structure, bits, pieces, etc each time you create a new component, in my opinion.

Notice that the Template Component is under a directory called "Components", this will be the parent component for all of your Components for the project. you can separate comnponents into different directories per client or project or whatever, but you'll need to duplicate the build.xml as well. the build.xml and Components directory must be at the same level. Peak at the properties structure in the build.xml for more info.

Finally, the build.xml.

The build.xml has two targets: 'createnew' and 'all'. 

createnew will generate a new component structure for the component name provided. It looks like this when using eclipse to execute:



NewComponent is the name of your new component to be created. 


The default target is 'all', so in can be implied. that will look like this, if your component is named "SenaSampleManageMetadata"



The 'all' target does a few things:

Note that the build number is managed by this file: ${componentName}.build.properties. The build automatically increments the build number by one each time the build is executed. the date is also automatically updated.

The target also cleans the build directory, recreates it, the zips up the component (excluding svn assets).


NOTE: the compilation of the class files is not done by the script since this was originally used with eclipse. I used eclipse's auto-build to make sure the class files were always there when needed. This required modifying the build directory as follows:



Note that the expected structure is as follows:

java source:

Components/<Component Name>/component/<Component Name>/src

java classes:

Components/<Component Name>/component/<Component Name>/classes


The build.xml could easily be modified to include a subtask containing a java compilation job, if needed.

I have not used this with jdeveloper, but I expect it could be adapted to jdeveloper as well. I personally still use eclipse for building components, so I have not taken the time to attempt to adapt to jdev.

here is a link to the public repo housing this code:

https://bitbucket.org/Rsulliv1/webcenter-utilities

Let me know what everyone thinks!

-ryan

Thursday, December 18, 2014

Keep Current! - WebCenter Patches as of 2014/12/18

Hey all, 

In an effort to help everyone stay current, we're going to post some preferred patches on a regular schedule. This way, you'll have a single place to find all of the updated cumulative patches (MLRs, ARUs, Bundle Patches, etc) for the month.

Please be sure to let me know if there's any other patches that should be included on this list. The current format has the support recommended installs in bold & underlined, but there are some other nice-to-know patches included as well. These nice-to-know patches may not be necessary for your particular installation.

The formatting may change over time, but hopefully this is helpful!

** As always, please be sure to do your own due diligence before applying any patch. This list is for reference only.




Oracle Patches[1]

ODC
·       14538406 – 2012/09/17 – ODC Patch 4 for 10.1.3.5.1 (cumulative)
·       16312671 - 2013/02/15 – CPUAPR2013 Oracle Document Capture 10.1.3.5 (ActiveX IE killbit to prevent certain ActiveX controls; verify before installing!)
WEC (Capture 11g)
·       19856709 – 2014/12/08 – Cumulative Capture Patch 11.1.1.8 NUMBER 7
OFR
·       13882540 – 2012/04 – Critical Patch Update
·       13548500 – 2011/12/30 – Registry fix for searching for vendors with identical addresses
·       11813845 – 2011/02 - OFR Patch 1 (not cumulative)
·       12692984 – 2011/06 – OFR Patch 2 (not cumulative)
·       12372094 – 2011/04/27 – (updated ODC macros)
WFR (11g)
  • 20134250 - Web Verifier Patch 11.1.1.8.0 Number 2
  • 18679078 - AP Project Reporting Patch 11.1.1.8.0 Number 1
  • 18713484 = Web Verifier Patch 11.1.1.8.0 Number 1


WebCenter Content Patches

·        11.1.1.8 (ADF UI)
o    19905553 –  2014/11 – WCCADFUI cumulative patch NUMBER 7
o    18503310–  2014/04 –Fix the ADF UI Issues on WCC
o    20204977 2014/12 – OIT cumulative patch
·       11.1.1.8
o    19608435 – 2014/11 11.1.1.8.8
o    20204977 2014/12 – OIT cumulative patch
·       11.1.1.7
o    19060553– 2014/08 - MLR06
o    20204977 2014/12 – OIT cumulative patch
 o 20075252 - merge request
·       11.1.1.6
o    18661652 – 2014/05 – MLR19
o    19144576 – 2014/07 – OIT cumulative patch
o   17649006 – Error on processing scheduled event: NOTIFICATIONOFEXPIRATION

WebCenter Content Imaging Patches
·       11.1.1.8
o    20160201 – 2014/12 - CUMULATIVE IPM/AXF PATCH 11.1.1.8.0 NUMBER9
o    19001500 – 2014/06/17 - CUMULATIVE IPMREPOSITORY PATCH 11.1.1.8.0 NUMBER 3
·       11.1.1.7
o    19846141 – 2014/11 - CUMULATIVE IPM/AXF PATCH 11.1.1.7.0 NUMBER 15
o    17056936 – 2013/07/21 - CUMULATIVE EBS PATCH 11.1.1.7.0 NUMBER 1
o    16403418 – 2013/03/12 - CUMULATIVE FUSION APPS PATCH 11.1.1.7.0 NUMBER 1
o    18629185 – 2014/04/21 - CUMULATIVE IPMREPOSITORY PATCH 11.1.1.7.0 NUMBER 3
·       11.1.1.6
o    19000478 – 2014/06/17 - CUMULATIVE IPM/AXF PATCH 11.1.1.6.0 NUMBER 29
o    17057174 – 2013/07/05 - CUMULATIVE EBS PATCH 11.1.1.6.0 NUMBER 5
o    16547732 – 2013/03/29 - CUMULATIVE FUSION APPS PATCH 11.1.1.6.0 NUMBER 4
o    18336884 – 2014/03/03 - CUMULATIVE IPMREPOSITORY PATCH 11.1.1.6.0 #4
BAM Patches
·       (No cumulative patch threads could be found, but many one-off patches exist)


·       14696899
o    Bug #14696899
o    EXTERNAL DATA OBJECTS HAVE A NEGATIVE SCALE FOR A DECIMAL TYPE COLUMN
·       14491485
o    Bug #14491485
o    CANNOT LOGIN TO BAM ON RESTARTING BAM SERVER WHILE SOA & WLS ARE RUNNING


SOA Patches
·       (Note that there are many one-off patches available)

·       11.1.1.7


o    19190139 - 2014/10 - 11.1.1.7.5 Bundle Patch

o    18609527 – 2014/07/15 – 11.1.1.7.4 Bundle Patch
o    18106242 – HOTFIX for BUG: Custom view works but fails on edit after fix for bug 18025182
o    17584181 – 2013/10/31 – 11.1.1.7.2 Bundle Patch (Use this if using the Imaging Solution)

·       11.1.1.6
o    16702086 – 2013/11/05 – 11.1.1.6.7 Bundle Patch

** Note that there are multiple “merge request” patches per SOA release; they do not appear to be cumulative; please research and download as applicable for your version
WLS Patches
·       10.3.6
o    18040640– TSF1 - 2014/04/15 – WLS Patch Set Update 10.3.6.0.8
* Note that WLS has many one-off patches and “merge request” patches; please research and download as applicable for your version
WebCenter Portal

·       11.1.1.8
o    19194669 – 2014/10/15 – WebCenter Portal Bundle Patch 11.1.1.8.5
o    18085041 – 2014/04/15 – WebCenter Portal Bundle Patch 11.1.1.8.3

·       11.1.1.7
o    16761779 – 2013/07/23 – WebCenter Portal Bundle Patch 11.1.1.7.1
·       11.1.1.6
o    16269470 – 2013/07/23 – WebCenter Portal Bundle Patch 11.1.1.6.6
o    14823234 – 2013/07/23 – WebCenter Portal Bundle Patch 11.1.1.6.5

o    17328920 – 2013/09/25 – Content Presenter throws stuck thread and OOM when UCM returns many profiles

** Note that there are many one-off and “merge request” patches per Portal release; they do not appear to be cumulative; please research and download as applicable for your version



[1] http://support.oracle.com *requires a valid support agreement to download patches