Oracle® Insurance Rules Palette
Scheduled computation is used to calculate values on policies that do not have a variable component. The ScheduledValuation business rule was enhanced to include a <Computation> element that when present toggles the rule's action from valuation to computation.
A SQL query within the business rule identifies the policies or segments selected for the various computation calculations such as cash value, surrender charge, and anything else required using standard math syntax. The output values that are calculated are stored in the database in order to be accessed for reporting or picked up by downstream systems.
Use a plan level transaction to perform scheduled computation on all policies within the SQL query.
Cycle is involved in scheduled computation. A cycle agent has to be deployed; either in a web container like Weblogic or Websphere, or as a standalone application, and must be running in order for scheduled computation to work correctly. Refer to the Cycle document in the Documentation Library on OTN for additional information on cycle.
The following components must be configured in order to perform scheduled computation:
a plan-financial transaction with the <Asynchronous> element must be configured.
the ScheduledValuation business rule with the <Computation> element must be configured. This should be attached to the transaction.
a Cycle agent must be deployed and running.
There are several business rules used to demonstrate this configuration:
ScheduledValuation business rule demonstrating policy computation: this rule must be overridden at the plan level. The <Query> element contains the SQL statement that identifies the policies involved in the calculation. The <Computation> element identifies that the computation is for policy. Navigate in the Global Explorer to Business Rules | Attached | Scheduled Valuation| Transaction Overrides | ScheduledValuation (ScheduledComputationPolicy-Functional Prototype Plan .
ScheduledValuation business rule demonstrating segment computation: this rule must be overridden at the plan level. The <Query> element contains the SQL statement that identifies the segments involved in the calculation. The <Computation> element identifies that the computation is for segment. Navigate in the Global Explorer to Business Rules | Attached | Scheduled Valuation| Transaction Overrides | ScheduledValuation (ScheduledComputationSegment-Functional Prototype Plan .
There are two plan level transactions configured to demonstrate scheduled valuation:
ScheduledComputationPolicy: this transaction must include the <AsynchronousActivity> element. Navigate in the Global Explorer to Transactions | ScheduledComputationPolicy (Functional Prototype Plan) to view the configuration.
ScheduledComputationSegment: this transaction must include the <AsynchronousActivity> element. Navigate in the Global Explorer to Transactions | ScheduledComputationSegment (Functional Prototype Plan) to view the configuration.
Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices