FindBillDetail

This Activity Function retrieves an array of AsBillDetail records. It may be configured to execute multiple times within an Activity.

The array of AsBillDetail records can be passed to the CreateBill (APE) for the resulting AsBill record. The function accepts threshold and date parameters to limit the number of BillDetail records returned. Only Pending detail records that fall within the parameter values are included in the array. All parameter values are inclusive meaning BillDetail dates will be greater than or equal to the StartDate parameters and bill amounts must be greater than or equal to the BillMinimumAmountThreshold value.

FindBillDetail Elements/Attributes

TYPE=FindBillDetail
Element Attribute Value Element Value Definition
<MathStatement> Opening element for math variable    
  TYPE

Required attribute:

"ACTIVITYFUNCTION"

Defines the math statement type
 

FUNCTIONNAME

Required attribute:

"FINDBILLDETAIL"

Defines the function to run value

<Parameters>

Opening element of the parameters    

<Parameter>

 

Required attribute:

A field or math variable containing a date

 

Defines the parameter of the function

NAME

Required attribute:

A field or math variable containing a date

Value from "StartDate"

Defined input name.

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT"

Function parameter type: Input/Output

<Parameter>

 

Predefined MathVariable Name

NAME

Required attribute:

A field or math variable containing a Name

Value from "EndDate

Defines the parameter to assign the value

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT

Predefined MathVariable Type

<Parameter>

 

Predefined parameters for the function to assign the value

NAME

Required attribute:

A field or math variable containing a "BillGroupGUID"

Value from "BillGroupGUID"

 

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined parameters for the function

NAME

Required attribute:

A field or math variable containing a "BillMinimumAmountThreshold"

Value from "BillMinimumAmountThreshold"

 

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined parameters to assign the value . Value is the field or math variable containing a currency amount

NAME

Required attribute:

A field or math variable containing a "BillMaximumAmountThreshold"

Value from "BillMaximumAmountThreshold"

 

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined parameters for the function

NAME

Required attribute:

A field or math variable containing a "BillGroupGUID"

Value from "BillGroupGUID"

 

TYPE

Required attribute:

A field or math variable containing a type

Value from "INPUT

Function parameter type: Input/Output

<Parameter>

 

Predefined parameters to assign the value . Value is the field or math variable containing a string array

NAME

Required attribute:

A field or math variable containing a "BillDetailArray"

Value from "BillDetailArray"

 

TYPE

Required attribute:

A field or math variable containing a type

Value from "OUTPUT"

Function parameter type: Input/Output

 

XML Example

<Transaction>
<EffectiveDate STATUS= "Enabled" TYPE= "SYSTEM"></EffectiveDate>
<Fields>
<Field>
<Name>StartDate</Name>
<Display>Billing Detail Start Date</Display>
<DataType>Date</DataType>
</Field>
<Field>
<Name>EndDate</Name>
<Display>Billing Detail End Date</Display>
<DataType>Date</DataType> </Field>
<Field>
<Name>ThreshholdMinimumAmount</Name>
<Display>Bill Detail Minimum Threshhold Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>ThreshholdMaximumAmount</Name>
<Display>Bill Detail Maximum Threshhold Amount</Display>
<DataType>Money</DataType>
</Field>
<Field>
<Name>BillGroupGUID</Name>
<Display>Bill Entity Guid</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>BillOwnerGUID</Name>
<Display>Bill Owner Guid</Display>
<DataType>Text</DataType>
</Field>
<Field>
<Name>ReferenceID</Name>
<Display>Reference ID</Display>
<DataType>Text</DataType>
</Field>
</Fields>
<Math>
<MathVariables>
<MathVariable VARIABLENAME="BillDetailArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"/> </MathVariable> <MathVariable VARIABLENAME="ReferenceIDMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:ReferenceID</MathVariable>
<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">BillingStartDate</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">BillingEndDate</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">BillGroupGUID</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMinimumAmount</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMaximumAmount</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">BillDetailArrayMV</Parameter>
</Parameters>
</MathStatement>
</MathVariables>
</Math>
</Transaction>

XML Schema

<GenerateBillDetail>
<BillDetail RECEIVABLEDUETYPE=”[AsCodeValue]” BILLGROUPGUID=”[MathVariable GUID]” BILLGROUPTYPE=”[AsCodeValue]”>
<Tests>
<Test>[test expression]</Test>
</Tests>
<BillAmount BILLENTITYGUID=”[MathVariable GUID]” BILLENTITYTYPE=”[AsCodeValue]” DUEDATE=”[MathVariable Date]”>[MathVariable Currency Amount]</BillAmount>
<Fields>
<Field>
<From>[MathVariable or Field]</From>
</Field>
</Fields>
</BillDetail>
</GenerateBillDetail>

 

 

 

 

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