My Oracle Support Banner

Math Collections With Mix Data Type Gives An Error Upon Value Retrieval (Doc ID 2549951.1)

Last updated on JANUARY 23, 2020

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.0.10 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.10 version, General

ACTUAL BEHAVIOR
---------------
Normally, a collection will accept a mix of Datatypes (Integers, Decimals, Dates, Text, arrays, collections) and retrieving the info is straightforward. In the current code, the attempt to extract the information stored in the collection, once back at the transaction level, resulted in error.

Tried different methods without success but when had only one variable, then suddenly the info would be available. Added more variables of the same type and that worked too. Tried sorting the info by datatype, meaning putting all arrays in one array collection, all integers in an integer collection, and so on, and then all these collections in the final collection. Doing this, was able to retrieve the information at the transaction level.


EXPECTED BEHAVIOR
-----------------------
Should be able to retrieve values from collections regardless of whether it contains mixed data types.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Follow the sample configuration:
And create a transaction with a Math Variable Type=Collection, and have it contained mixed data types, and try to retrieve them.

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
Cause
Solution
References


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