My Oracle Support Banner

SOA 12c - Insert Operation in DB Adapter Returns Only Non-Null Columns (Doc ID 2871330.1)

Last updated on MAY 23, 2022

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The customer is using a composite which was migrated from 11g to 12c. Since the composite is making use of the insert operation with the help of the DB adapter, in the 11g environment, when they provide the input payload with values for only some of the columns, they see both null columns and non-null columns displayed as output. However, the same behavior is not replicated in the 12c environment, where they can only see the columns for which a value was given and they are not getting the null columns in output. As a consequence, they are also getting the error below:



Changes

No changes. The only significant change was the composite being migrated from an 11g to a 12c environment.

 

Cause

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
Symptoms
Changes
Cause
Solution


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