My Oracle Support Banner

RequirementField Query Does Not Include BigTextValue Column Causing Stack Trace (Doc ID 2698174.1)

Last updated on AUGUST 07, 2020

Applies to:

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

Symptoms

On : 11.2.0.20 version, General

RequirementField query does not include BigTextValue column causing stack trace. When using Datatype Text Area (05) for Requirement fields there is a scenario when the system loads the requirement records and corresponding fields, however the query used doesn't include the BigTextValue column. When the system tries to load the field data the BigTextValue field data is not there causing an error. Our workaround is to change datatype to Text for the affected fields.

ERROR
-----------------------
Error:
com.adminserver.sre.dal.PASDal.findRequirementsByRequirementGuidList(PASDal.java:2959)
com.equisoft.ape.CreateRequirementResult.loadRequirementStatus(CreateRequirementResult.java:242)
com.equisoft.ape.CreateRequirementResult.createRequirementResult(CreateRequirementResult.java:201)
com.equisoft.ape.CreateRequirementResult.process(CreateRequirementResult.java:110)
com.adminserver.ape.ExternalProcessApe.processRule(ExternalProcessApe.java:65)
com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll.processRule_aroundBody4(TransactionBusinessRulePacketRuleBll.java:133)
com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll$AjcClosure5.run(TransactionBusinessRulePacketRuleBll.java:1)
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Create Requirement Results failed with exception Field Name BigTextValue does not have a value.
at com.equisoft.ape.CreateRequirementResult.process(CreateRequirementResult.java:118)
at com.adminserver.ape.ExternalProcessApe.processRule(ExternalProcessApe.java:65)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add TextArea field to a Requirement. Process an activity that updates the requirementfields.

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.