Support OnChange/OnLoad for Fixed Fields on Requirements

Fixed fields of a Requirement needs to support OnLoad or OnChange of that field value to affect other fields for screen validation purposes. This feature adds the ability of some Requirement fixed fields to be exposed to Actions and Events to effect a change in the fixed field or an action when the fixed field changes. The following Requirement fixed fields are supported:

Prerequisites

NA

New Items

Requirement Node under Palette Administration

A requirement called "Functional Actions and Events" is added to the Prototype Child Company which will be available to be added in Functional Prototype Plan.

This is a policy-client requirement

Changes to the Existing Items

NA

Configuration Details

Functional Actions and Events

New set of dynamic fields were added as well as action events configuration

<RequirementDefinition>
<Fields>
<Field>
<Name>Line</Name>
<Display></Display>
<DataType>Line</DataType>
</Field>
<Field>
<Name>OrderField</Name>
<Display>Order Fields</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>ResultType</Name>
<Display>Result Type</Display>
<DataType>Combo</DataType>
</Field>
</Fields>
<Events>
<Event TYPE="ONCHANGE" FIELD="StatusCode">
<ActionSet ID="OnChangeStatusCode"></ActionSet>
</Event>
<Event TYPE="ONSUBMIT">
<ActionSet ID="FinalValidation"></ActionSet>
</Event>
<Event TYPE="ONLOAD">
<QuerySet ID="OnLoadData" FIELD="ResultType"></QuerySet>
</Event>
</Events>
<ScreenMath>
<Math ID="GlobalScreenMath" GLOBAL="Yes">
<MathVariables>
<MathVariable VARIABLENAME="StatusCodeMV" TYPE="VALUE" DATATYPE="TEXT">05</MathVariable>
<MathVariable VARIABLENAME="StatusCodeMV1" TYPE="VALUE" DATATYPE="TEXT">00</MathVariable>
</MathVariables>
</Math>
</ScreenMath>
<Actions>
<QuerySet ID="OnLoadData">
<Condition IF="StatusCode=GlobalScreenMath:StatusCodeMV1">
<Action ACTIONTYPE="SQLQUERY">SELECT AsCode.CodeValue, AsCode.ShortDescription FROM AsCode WHERE AsCode.CodeName = 'AsCodeUploadType' AND AsCode.CodeValue IN ('04','02') ORDER BY AsCode.CodeValue</Action>
<Else>
<Action ACTIONTYPE="SQLQUERY">SELECT AsCode.CodeValue, AsCode.ShortDescription FROM AsCode WHERE AsCode.CodeName = 'AsCodeUploadType' AND AsCode.CodeValue IN ('03','01') ORDER BY AsCode.CodeValue</Action>
</Else>
</Condition>
</QuerySet>
<ActionSet ID="FinalValidation">
<Condition IF="IsEmpty(Comments)">
<Action ACTIONTYPE="ERROR">Enter Comments</Action>
</Condition>
</ActionSet>
<ActionSet ID="OnChangeStatusCode">
<Condition IF="StatusCode=GlobalScreenMath:StatusCodeMV">
<Action ACTIONTYPE="DISABLE" FIELD="OrderField"></Action>
</Condition>
</ActionSet>
</Actions>
</RequirementDefinition>
     
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us