Legacy Adapter 11g Does Not Return Complete Data When Used With SOA Composite or OSB
Last updated on NOVEMBER 03, 2016
Applies to:OracleAS Adapters - Version 10.1.3.4 and later
Oracle SOA Suite - Version 184.108.40.206.0 and later
Oracle Service Bus - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Using the 18.104.22.168.0 Oracle Legacy Adapters to retrieve data via SOA composite or OSB does not return all of the expected data to the SOA or OSB application. This is seen even though it can be verified that the legacy device, e.g. a mainframe, is returning all of the data correctly.
This has problem been seen in two different scenarios:
First from <bug 13414727> - using BPEL and Legacy Adapter:
Created interaction in Legacy Adapter, tested with Oracle Studio correctly. Generated JCA and added to BPEL project. Query works correctly for single row result, however if more than one row returns, the invoke seems to only return every other row in BPEL.
For example, the query returned data correctly when there was only one row to return. When adding a second row, both returned correctly in Oracle Studio, however only one returned from BPEL's Invoke activity. When adding a third row, both the first and third rows returned, however the second was still missing. When adding a fourth row only the first and third rows were returned to BPEL.
Second from <bug 18602030> - using OSB and Legacy Adapter:
Created interaction in Legacy Adapter, tested with Oracle Studio correctly. This is a CICS adapter interaction. When testing from OSB /sbconsole -> Project Explorer -> Launch Test Console the data shown in the Response document will be missing data. For example the following is sent in the Request document from OSB to the mainframe:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms