FindBillDetail Activity Function Return Policy Count

The FindBillDetail activity function has been expanded to return counts of the items in the bill detail array. The GenerateBill transaction on the Customer Plan within the Prototype company has been updated to return these new, additional values. New math arrays are defined for the Policy, Client and Segment BillDetail records returned from the function in addition to the existing aggregated array of all Bill Detail records. The new feature allows the users to verify expected bill detail counts vs actual records found.

Prerequisites

In order for the activity function to return any values, there must be records on AsBillDetail in a pending status that match the input criteria (Date range and BillGroupGUID)

New Items

Transaction - GenerateBill (Customer Plan, Prototype company)

<MathVariables>
<MathVariable VARIABLENAME="BillDetailArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailPolicyGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailClientGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailSegmentGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillOwnerTypeMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:BillGroupType</MathVariable>
<MathIF IF="BillOwnerTypeMV = 'CLASS'">
<MathVariable VARIABLENAME="BillOwnerGUIDMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:Class</MathVariable>
</MathIF>
<MathIF IF="BillOwnerTypeMV = 'GROUPCUST'">
<MathVariable VARIABLENAME="BillOwnerGUIDMV" TYPE="SQL" DATATYPE="TEXT">SELECT ClientGUID FROM AsGroupCustomer WHERE GroupCustomerGUID='[Activity:GroupCustomer]'</MathVariable>
</MathIF>
<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">Activity:BillingStartDate</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">Activity:BillingEndDate</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">BillOwnerGUIDMV</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMinimumAmount</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMaximumAmount</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">BillDetailArrayMV</Parameter>
<Parameter NAME="BillDetailPolicyGUIDArray" TYPE="OUTPUT">BillDetailPolicyGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailClientGUIDArray" TYPE="OUTPUT">BillDetailClientGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailSegmentGUIDArray" TYPE="OUTPUT">BillDetailSegmentGUIDArrayMV</Parameter>
</Parameters>
</MathStatement>
<MathVariable VARIABLENAME="BillDetailCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailPolicyCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailPolicyGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailClientCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailClientGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailSegmentCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailSegmentGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="ReferenceIDMV" TYPE="IDENTIFIER" DATATYPE="TEXT">
<Parts>
<Part TYPE="SEQUENCE" FORMAT="0000000000">ReferenceIDMV</Part>
</Parts>
</MathVariable>
</MathVariables>

Changes to Existing Items

The Math section is appended to the existing GenerateBill transaction.

Configuration Details

GenerateBill transaction

New Math elements- New MathVariables

New Function Parameters

     
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us