My Oracle Support Banner

Legacy Adapter 11g Does Not Return Complete Data When Used With SOA Composite or OSB (Doc ID 1666919.1)

Last updated on MAY 16, 2023

Applies to:

OracleAS Adapters - Version and later
Oracle SOA Suite - Version and later
Oracle Service Bus - Version and later
Information in this document applies to any platform.


Using the 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.

Note: Testing this in Oracle Studio may return the correct results, but using SOA or OSB with the Legacy Adapter there is data missing in the response.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.