Null Pointer Exception When Running AsFile As An Illustration

(Doc ID 2329745.1)

Last updated on NOVEMBER 17, 2017

Applies to:

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

Symptoms

On : 11.0.1.0 version, Web services

Problem Description
--------------------------
When running an AsFile as an Illustration, in IllustrationRequestBll on line 317 in 11.0.1.0 and line 315 in 11.0.2.0,
the system tries to get the planDcl from the policies planGuid, only the sql being run uses PlanSliceGuid in the WHERE clause which makes the planDcl null on the next line of code.
Attempted to set the planGuid on policy to the PlanSliceGuid but that did not work.

Curent OIPA version: 11.0.2.0 , Running on Websphere 8.5.5.10 with Java 8

Error
------
[7/28/17 15:02:13:825 UTC] 00000122 SystemOut O [EL Fine]: sql: 2017-07-28 15:02:13.825--ServerSession(-2019466607)--Connection(621147493)--SELECT PLANSLICEGUID, ACTIVEGMT, BUSINESSSTATUSCODE, COMPANYGUID, DEFAULTCURRENCYCODE, EFFECTIVEFROM, EFFECTIVETO, MARKETMAKERGUID, MIXEDVALUATION, PLANALLOCATIONMETHODCODE, PLANGUID, PLANNAME, POINTINTIMEVALUATION, PRODUCTGUID, RECORDSTATUSCODE, SYSTEMCODE, UPDATEDBY, UPDATEDGMT FROM AsPlan WHERE (PLANSLICEGUID = ?)
bind => [E74B5066-9575-4266-9B80-CE8B0ED293E1]
7/28/17 15:02:13:885 UTC] 000000d9 FileReceivedE E Exception thrown in FileReceivedExecutor.processFile
7/28/17 15:02:13:910 UTC] 000000d9 AxisEngine E org.apache.axis2.engine.AxisEngine receive null org.apache.axis2.AxisFault

Caused by: java.lang.NullPointerException
7/28/17 15:02:13:881 UTC] 000000d9 SystemErr R at com.adminserver.pas.webservice.bll.filereceived.IllustrationRequestBll.createActivity(IllustrationRequestBll.java:315)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at com.adminserver.pas.webservice.bll.filereceived.IllustrationRequestBll.processImportedObject(IllustrationRequestBll.java:78)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at com.adminserver.webservice.bll.AbstractRequestBll.processRequest_aroundBody2(AbstractRequestBll.java:92)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at com.adminserver.webservice.bll.AbstractRequestBll$AjcClosure3.run(AbstractRequestBll.java:1)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at com.adminserver.extensibility.helper.aspects.ExtensibilityAspectExecutionHelper.executeReturningExtension(ExtensibilityAspectExecutionHelper.java:62)
7/28/17 15:02:13:882 UTC] 000000d9 SystemErr R at com.adminserver.webservice.aspects.BaseFileReceivedWebserviceExtensibilityAspect.executeExtension(BaseFileReceivedWebserviceExtensibilityAspect.java:68)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue,development timelines are impacted.

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