Oracle® Fusion Middleware

Oracle Technology Adapters Release Notes

12c (12.2.1.3.0)

E83812-02

December 2017

Oracle Fusion Middleware Oracle Technology Adapters Release Notes, 12c (12.2.1.3.0)

E83812-02

Copyright © 2010, 2017, Oracle and/or its affiliates. All rights reserved.

Primary Author: Ramakanth Kotha

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

List of Figures

Preface

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

1 What’s New in this Release

- 1.1 New Features

2 Known Issues and Workarounds

- 2.1 Inbound Services are not Working in Oracle ERP Cloud Adapter

- 2.2 Incorrect Property Values Generated for the PL/SQL API WF_EVENT.RAISE() Using Oracle E-Business Suite Adapter

- 2.3 Importing an Eloqua Adapter Service/Composite Created in 12.1.3 Fails During Runtime

- 2.4 Flexfield Support for Open Interface Table Is Not Fully Functional in Oracle E-Business Suite Adapter

- 2.5 Two XSDs Created for Database Adapter Stored Procedure Migrated from 11g to 12c in Oracle E-Business Suite Adapter If Wizard Rerun

- 2.6 Performance Slow While Importing a Flexfield Mapping for a PL/SQL API in Oracle E-Business Suite Adapter

- 2.7 Flexfield Support for Open Interface Table Is Not Fully Functional in Oracle E-Business Suite Adapter

- 2.8 Email Subject and Body Garbled in UMS-Outbound when it is Non_UTF-8 Server Encoding

- 2.9 XA class support is deprecated for Oracle JCA Adapter for MQ Series

- 2.10 XSLT Transform Mapper Activity in Oracle BPEL Process Manager

List of Figures

Preface

This document describes the issues and workarounds related to Oracle Integration Adapters.

Audience

This document is intended for users of Oracle Integration Adapters who should be aware of any related issues.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following Oracle resources:

- System Requirements and Specifications

- Planning an Installation of Oracle Fusion Middleware

- Developing Resource Adapters for Oracle WebLogic Server

- High Availability Guide

- Developing SOA Applications with Oracle SOA Suite.

- Administering Oracle Fusion Middleware.

- Administering Oracle SOA Suite and Oracle Business Process Management Suite.

- Oracle E-Business Suite Adapter User's Guide

- Administering Oracle Service Bus

- Securing Web Services and Managing Policies with Oracle Web Services Manager

- Oracle® Application Server Installation Guide for Legacy Adapters

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 What’s New in this Release

This section introduces the new and changed features of Oracle Integration Adapters, and provides pointers to additional information.

There are no new features added in this release. The guide for the release contains major bug fixes.

Screens shown in this guide may differ from your implementation, depending on the skin used. Any differences are cosmetic.

1.1 New Features

There are no new features added in this release. The guide for the release contains major bug fixes.

Screens shown in this guide might differ from your implementation, depending on the skin used. Any differences are cosmetic.

2 Known Issues and Workarounds

This section discusses the known issues and workarounds for the issues in Oracle Technology Adapters.

2.1 Inbound Services are not Working in Oracle ERP Cloud Adapter

Issue

Bug Number: 27212271

Impacted Releases: 12.2.1.2.0 and 12.2.1.3.0

Impacted Platforms: All

Inbound Services are not working in Oracle ERP Cloud Adapter 12.2.1.2.0 and 12.2.1.3.0.

Workaround

Use Oracle Integration Cloud Service for inbound services. The resolution for Oracle ERP Cloud Adapter will be delivered in the next available patch.

2.2 Incorrect Property Values Generated for the PL/SQL API WF_EVENT.RAISE() Using Oracle E-Business Suite Adapter

Issue

Bug Number: 23005384

Impacted Releases: 12.2.1.3

Impacted Platforms: All

Creation of a partner link for the PL/SQL API WF.EVENT.RAISE() using Oracle E-Business Suite Adapter is successful at the design time; however, the PackageName and ProcedureName properties have incorrect values in the xx_apps.jca file which gets generated in the project. Invocation of the composite fails during runtime for this partner link.

Workaround

Update the xx_apps.jca file with the following values:

- <property name="PackageName" value="WF_EVENT"/>

- <property name="ProcedureName" value="RAISE"/>

2.3 Importing an Eloqua Adapter Service/Composite Created in 12.1.3 Fails During Runtime

Issue

Bug Number: 22985030

Impacted Releases: 12.2.1, 12.2.1.1.0 and later releases

Impacted Platforms: All

After you import a configuration jar created in 12.1.3, the service fails during runtime with the following exception:

The invocation resulted in an error:
Invoke JCA outbound service failed with application error, exception:
com.bea.wli.sb.transports.jca.JCATransportException:
oracle.tip.adapter.sa.api.JCABindingException:
oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFExcep
...

Workaround

Create the CSF key manually when importing a 12.1.3 OSB configuration or SOA composite. This is because even though 12.2.1.1.0 and 12.2.1.2.0 do not require you to create a CFS key manually for a new service/composite in Enterprise Manager Fusion Middleware Control, 12.1.3 did require you to create the CSF key manually.

2.4 Flexfield Support for Open Interface Table Is Not Fully Functional in Oracle E-Business Suite Adapter

Issue

Bug Number: 21326097

Impacted Releases: 12.2.1, 12.2.1.1.0 and later releases.

Impacted Platforms: All

When creating an Open Interface Table partner link configured with flexfields for Oracle E-Business Suite Adapter, the generated schema files do not include the associated flexfield definition or reference.

This issue is specific to Open Interface Tables. Flexfield support for PLSQL APIs works as expected.

Workaround

None

2.5 Two XSDs Created for Database Adapter Stored Procedure Migrated from 11g to 12c in Oracle E-Business Suite Adapter If Wizard Rerun

Issue

Bug Number: 18555120

Impacted Releases: 12.1.3, 12.2.1, 12.2.1.1 and later releases

Impacted Platforms: All

While creating a new project in Oracle E-Business Suite Adapter, if the underlying Database Adapter project contains a stored procedure and is migrated from 11g to 12c release, when you rerun the stored procedure through the Configuration Wizard, a new xsd under the Schema folder is created for 12c release.

Workaround

Manually delete the old xsd file created earlier before the migration and update the read.wsdl to reference the new xsd in the Schema folder.

Note that if database tables are used, the new schema is correctly written to the old schema location.

2.6 Performance Slow While Importing a Flexfield Mapping for a PL/SQL API in Oracle E-Business Suite Adapter

Issue

Bug Number: 18956027

Impacted Releases: 12.1.3, 12.2.1, 12.2.1.1 and later releases

Impacted Platforms: All

During the partner link creation for a PL/SQL API that has flexfield data configured, if you decide to construct the flexfield mapping by using an existing one through the Import feature, then it may take three to five minutes to get the mapping file (*_mapping.xml) imported to the Oracle E-Business Suite Module Browser.

2.7 Flexfield Support for Open Interface Table Is Not Fully Functional in Oracle E-Business Suite Adapter

Issue

Bug Number: 21326097

Impacted Releases: 12.2.1, 12.2.1.1.0 and later releases.

Impacted Platforms: All

When creating an Open Interface Table partner link configured with flexfields for Oracle E-Business Suite Adapter, the generated schema files do not include the associated flexfield definition or reference.

This issue is specific to Open Interface Tables. Flexfield support for PLSQL APIs works as expected.

Workaround

None

2.8 Email Subject and Body Garbled in UMS-Outbound when it is Non_UTF-8 Server Encoding

Issue

Bug Number: 20673880

Impacted Releases: 12.1.3, 12.2.1, 12.2.1.1.0 and later releases

Impacted Platforms: All

Email subject and body get garbled in UMS-outbound (SendNotification) scenario. This happens when server encoding is Non_UTF-8. The mail corruption happens when message is String Type or Opaque or when it is using XSD.

Workaround

Restart the server, when the server encoding is changed to be UTF-8.

2.9 XA class support is deprecated for Oracle JCA Adapter for MQ Series

Issue

Bug Number: 21049656

Impacted Releases: 12.1.3, 12.2.1, 12.2.1.1, 12.2.1.2

Impacted Platforms: All

XA class support is deprecated for Oracle JCA Adapter for MQ series. Do not use XA with Oracle JCA Adapter for MQ Series or Transport.

Workaround

Use WebSphere MQ JMS API instead in XA transactions. When XA transactions are required, use Oracle JCA Adapter for JMS to interact with IBM MQ instead of Oracle JCA Adapter for MQ Series. If the MQ adapter is used for XA transaction, the adapter might encounter an error when it needs to roll back an XA transaction. The user will then need to manually resolve any in-doubt transactions.

2.10 XSLT Transform Mapper Activity in Oracle BPEL Process Manager

Issue

Bug Number: 19558134

Impacted Releases: 12.1.3, 12.2.1, 12.2.1.1.0 and all alter releases

Impacted Platforms: All

When you attempt to map a node from the source node to the target node in the XSLT Mapper for Oracle RightNow schemas, you receive the following error:

Could not create element value-of
In addition, the mapped element comes out of Target Parent Node.

Workaround

Before performing any mapping, check whether the Parent Node on the Target node is gray in color. Select this parent node on the target (for example, Contact), then right-click and select Create Node in XSLT.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2018, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.