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.