The following is a known issue associated with this release of the connector:
Bug 13497967
When more than one open batched reconciliation operation is created (that is, when multi-threaded batched reconciliation is invoked) for a particular job and resource object, the following error is encountered:
Internal Exception: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
As a workaround, open the reconciliation profile of the resource object and set the value of the batchSize attribute to 0. By default, the attribute has a value of either -1 or higher. This approach would result in single event processing. If the error is already encountered, open the RECON_BATCHES table for the particular job and resource object. Of all the multiple reconciliation batches in the Initiated status, manually update all the batches except one to Completed status. Then, open the reconciliation profile of the resource object and set the value of the batchSize attribute to 0.
Note that the batchSize attribute to be updated is the reconciliation profile attribute and not a scheduled job parameter.