Group Billing_Reconciliation

The Billing Reconciliation functionality adds new screens, business rules and transactions to process the reconciliation and generate the required policy or client level activities to ensure the monies are applied to the bill detail records.

The Billing Reconciliation is accomplished through two screens; Group/List Bill Search Screen and Group/List Bill Reconciliation Screen. From the Bill Reconciliation Screen, based on the reconciliation action is the ability to trigger specific actions into the Policy/ /Client/ from which the bill detail originates. The same reconciliation could be processed using data intake to process the reconciliation activities.the following.

Business Rules support the Reconciliation process:

 Group/List Bill Search (screen)

 Group/List Bill Reconciliation (screen)

 Bill Detail Search (screen)

 Bill Detail Reconciliation Search (screen)

 MaintainBillDetailReconciliation ( Business Rule)

Prototype Configuration Detail Overview

With this feature user has the ability to reconcile the bill such that the monies are adjusted against the bill detail.

PrerequisitesFollowing Business Rules should be configured:

BillSearchScreen

BillDetailReconciliationSearchScreen

BillDetailSearchScreen

BillReconciliationScreen

User should have access to the following transactions:

Reconciliation

ReconciliationReversal

New Items

'BillSearchScreen' Business Rule:

Business Rule is configured to showcase the 'Group/List Bill' search feature.

'Bill Search' screen can be accessed through a new main menu item called 'Group/List Bill'.

<Group> values like 'Bill','BillDetail','BillDetailField' & 'GroupCustomer' are supported for search criteria fields.

Following are the search criteria's configured for prototype scenario:

BillDetailReferenceID

CustomerNumber

For Bill records with BillOwnerTypeCode as Group Customer, the Group Customer needs to be linked through the BillOwnerGUID as the ClientGUID of the Group Customer.

For Bill records with BillOwnerTypeCode as Class, the Group Customer needs to be linked through the BillOwnerGUID as the ClassGUID.

Search results are displayed as per the configuration and also default sorted by BillReferenceID.

Following are the fields configured as part of results section:

BillReferenceID

CustomerNumber

BillGeneratedDate

Upon selection of any one of the search result then user is navigated to the 'Group/List Bill Reconciliation' Screen.

'BillDetailReconciliationSearchScreen' Business Rule:

Business Rule is configured to showcase the BillDetailReconcilationSearch feature which supports editing of the reconciled bill detail records.

Following are the search criteria's configured for prototype scenario:

Amount

SuspenseNumber

StatusCode

<Group> values like 'BillDetailReconciliation','BillDetail','BillDetailField' & 'GroupCustomer','Client','ClientField','Policy','PolicyField','Segment' & 'SegmentField are supported for search criteria fields.

Following are the fields configured as part of results section:

BillDetailReferenceID

PolicyNumber

SuspenseNumber

Results are filtered based on the criteria entered by the user and upon selection of any one of the search result then user is navigated to the 'Group/List Bill Reconciliation' Screen.

Bill Detail Reconciliation search screen allows user to edit the bill amounts for multiple times before clicking of 'Save' / 'Cancel' button on the Group/List Bill

Reconciliation Screen

When user selects 'Cancel' button then the Adjust context is not considered and also user is returned back to initial load of 'Group/List Bill Reconciliation' Screen.

When user selects 'Save' then a confirmation window is appeared and upon confirming the reconciliation entries is saved and associated policy/client/group customer activity is triggered.

'BillDetailSearchScreen' Business Rule

Business Rule is used for the LinkSuspense purpose and the 'BillDetailSearchScreen' is appeared as one of the part of 'Bill Detail Search' section.

Following are the search criteria's configured for prototype scenario:

Amount

BillGroupType

PolicyNumber

<Group> values like 'BillDetail','BillDetailField' & 'GroupCustomer','Client','ClientField','Policy','PolicyField','Segment' & 'SegmentField are supported for search criteria fields.

Following are the fields configured as part of results section:

Amount

PolicyNumber

Results are filtered based on the criteria entered by the user.

'BillReconciliationScreen' Business Rule

This screen allows the user to reconcile the Group/List Bill that is selected.

Header section of 'Bill Reconciliation' screen is displayed with the below information:

Bill Reference ID

Group Customer Number

Class Name

Group Bill Date

The next section is 'Bill Reconciliation' section which allows a user to perform reconciliation and below are the data displayed as part of this section:

Total Amount Due

Current Reconciled Amount

By using either 'Link Suspense' or 'Adjust' buttons user can reconcile the bill details.

When user selects 'Cancel' button then the Adjust/Link Suspense context is not considered and also user is returned back to initial load of 'Group/List Bill

Reconciliation' Screen

When user selects 'Save' then a confirmation window is appeared and upon confirming the reconciliation entries is saved and associated policy/client/group customer activity is triggered.

'Reconciliation' Transaction

Transaction Type - Policy Financial

Processing Order - 1500

This transaction is called under the <ReconciliationTransactionOnEntity> element of 'BillReconciliationScreen' BR.

Following are the set of fields configured for this transaction where the data is populated from 'BillReconciliationScreen'.

BilLDetailReferenceGUID

AmounttoReconcile

'MaintainBillDetailReconciliation' Business Rule is attached to this transaction in order to allow reconciliation to be processed. After processing the transaction the bill detail record status is changed to Reconciled if the entire amount of the bill detail is reconciled.

Note: The SuspenseNumber and SuspenseType elements are deprecated from the MaintainBillDetailReconciliation rule and now the linking is performed through AsActivitySuspense to AsBillDetailReconciliation.

New Items

None

Changes to Existing Items

MaintainBillDetailReconciliation - The 4 instances (overides) of this rule are updated to remove the unused syntax.

BillDetailReconciliationSearch - References to the SuspenseNumber that is used to specify the search criteria and column result is removed.

Configuration Details

<MaintainBillDetailReconciliation>
<BillDetailReconciliation>
<ReferenceGUID>BillDetailReferenceGUIDMV</ReferenceGUID>
<AmountField>AmountToReconcileCMV</AmountField>
<EffectiveDate>ReconciliationEffectiveDateMV</EffectiveDate>
<Tests>
<Test>1=1</Test>
</Tests>
</BillDetailReconciliation>
</MaintainBillDetailReconciliation>
'ReconciliationReversal' Transaction

Transaction Type - Policy Financial

Processing Order - 1000

This transaction is called under the <ReconciliationReversalTransactionOnEntity> element of 'BillReconciliationScreen' Business Rule.

Following are the set of fields configured for this transaction where the data is populated from 'BillReconciliationScreen'.

OriginatingActivityGUID

'ShadowPendingActivities' Business Rule is attached to this transaction in order to shadow the reversed reconciliation record associated to the OriginatingActivityGUID.

After processing the transaction user should be able to see that Reconciliation done has been reversed and the status of the bill detail record is changed to Under reconciliation.

Note: Both the 'Reconciliation' & 'ReconciliationReversal' transactions are available under the below levels of Prototype company:

Client Plan

Customer Plan

Group Prototype Product

Existing Items

None

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