Legacy Adapter 11g Does Not Return Complete Data When Used With SOA Composite or OSB
(Doc ID 1666919.1)
Last updated on OCTOBER 01, 2021
Applies to:OracleAS Adapters - Version 10.1.3.4 and later
Oracle SOA Suite - Version 220.127.116.11.0 and later
Oracle Service Bus - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Using the 22.214.171.124.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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document