My Oracle Support Banner

MultiField's Are Not Properly Inserted When Using AsFile (Doc ID 2422968.1)

Last updated on JULY 13, 2018

Applies to:

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

Symptoms

On : 11.1.0.6 version, General

ACTUAL BEHAVIOR
---------------
MultiField's are not properly saved when using AsFile. When inserting an Activity using AsFile that has mutlifields they are not properly created in the database if you try to insert more than 1. The issue happens when you try and save more than 1 MultiField via AsFIle, it will only insert the MultiField with the highest index. If we only save one multifield, the AsFile will correctly create the records. If you look at the AsXml that is returned the multifields are correctly created but they do not persist to the database.

This is an issue with Policy MultiFields as well.

EXPECTED BEHAVIOR
-----------------------
All multifields are correctly inserted to the DB

STEPS
-----------------------
Using the attached DB and Payload send in the request as is. Once you have the response from OIPA look at the AsXml and notice that the Multifields were built correctly, 3 sets of 3. After this query the AsActivityMultiValueField with the ActivityGUID that is returned and notice only index #2 has been inserted into the DB.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, systems calling into OIPA cannot correctly create the required activities for processing

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!


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