Fields Are Created As FieldTypeCode='00' in Various Scenarios
Last updated on JANUARY 05, 2017
Applies to:Oracle Insurance Policy Administration J2EE - Version 10.1.2.0 and later
Information in this document applies to any platform.
In certain scenarios (Ex. using some attached rules or spawning activities,) fields are being created with NULL values and TypeCode of '00'
When using MaintainRelationships to create a ClientRelationship record and adding a field in the AsClientRelationshipField of datatype TEXT with a NULL value
causes the FieldTypeCode to be set to '00' instead of setting it to '01' as it should.
This causes issues later on when updating that field to have a date inside; it gives an error that it doesn't recognize the field as a date field.
"The data type DATE is not compatible with the data type for fieldName:..."
The issue can be reproduced at will with the following steps:
1. Use MaintainRelationships to create a ClientReleationship.
2. Add a field of type TEXT with a NULL value.
3. Process the activity
4. Verify the FieldTypeCode is incorrectly set to '00'
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