TRANSFORM ACTIVITY DOES NOT PASS XSI:NIL VALUES TO TARGET XML- CRITICAL 9710 (Doc ID 403586.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.2.0.2
Information in this document applies to any platform.

Symptoms

On 10.1.2.0.2 in Production:
When attempting to using minOccurs and nillable properties of XML schema to distinguish
between missing value and NULL value respectively, the following error occurs.

ERROR
<invalidVariables>
<part name="code" >
<code>9710</code>
</part>
<part name="summary" >
<summary>Invalid xml document. According to the xml schemas, the xml document
is invalid. The reason is: Invalid xml document. According to the xml schemas,
the xml document is invalid. The reason is: Error::cvc-datatype-valid.1.2.1: ''
is not a valid value for 'decimal'. Error::cvc-type.3.1.3: The value '' of
element 'a' is not valid. Error::cvc-datatype-valid.1.2.1: '' is not a valid
value for 'dateTime'. Error::cvc-type.3.1.3: The value '' of element 'b' is not
valid. Error::cvc-datatype-valid.1.2.1: '' is not a valid value for 'decimal'.
Error::cvc-type.3.1.3: The value '' of element 'id' is not valid. Please make
sure that the xml document is valid against your schemas. Please make sure that
the xml document is valid against your schemas. </summary>
</part>
</invalidVariables>

STEPS
The issue can be reproduced at will with the following steps:
1. BPEL Console -> Manage BPEL Domain -> Configuration. Set validateXML property to 'true'.
2. Create a source schema with at least 3 elements one each for string, integer, date type. Add
nillable clause for all.
3. Create a simple BPEL process to receive an xml message that complies with the source schema.
4. Using the Database Adapter, create partner link/invoke activity to insert rows into test table.
5. Using the transform activity, map source schema elements with test table schema elements.
6. Deploy the process and invoke with sample xml message.

Cause

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