Suppressing Extraction for Zero or Negligible Amount Bills
Oracle Revenue Management and Billing enables you to suppress the extraction process for bills when the bill amount is zero or within the tolerance limit. This feature helps to reduce the cost spent on sending zero or negligible amount bills to customers. To enable this feature for an account, you need to create an algorithm using the C1-SUPPBILLS algorithm type and attach it to the Post-Bill Completion system event of the respective customer class. This algorithm contains the following parameters:
-
Consider Threshold Limit – Used to indicate whether you want to suppress the extraction of bills when the bill amount is within the threshold limit. The valid values are:
-
Y – Used to indicate that you want to suppress the extraction of bills when the bill amount is within the threshold limit.
-
N – Used to indicate that you want to suppress the extraction of only those bills where the bill amount is zero.
This parameter is mandatory.
-
-
Routing Threshold Debit Amount – Used to specify the debit threshold amount. The value can be zero or a positive integer. This parameter is required when the Consider Threshold Limit parameter is set to Y.
-
Routing Threshold Credit Amount – Used to specify the credit threshold amount. The value can be a negative integer. This parameter is required when the Consider Threshold Limit parameter is set to Y.
-
Consider Ledger Impact – Used to indicate whether you want to suppress the extraction of bills when the GL entry does not exist for the bill. The valid values are:
-
Y – Used to indicate that you do not want to suppress the extraction of bills when the GL entry exists for the bill.
-
N – Used to indicate that you want to suppress the extraction of bills irrespective whether the GL entry exists or not for the bill.
This parameter is mandatory.
-
-
Routing Type To Be Suppressed – Used to indicate the bill route type for which you want to suppress the extraction of bills. You can specify multiple bill route types separated by a comma. If you do not specify the value for this parameter, the system will suppress the extraction of bills for all bill route types when this algorithm is attached on the customer class.
Based on the above parameters defined in the algorithm, the system decides whether the bill must be suppressed for the bill routing. If a bill must be suppressed for the extraction process, the algorithm will select the Do Not Extract option for the required bill route type on the bill completion. Let us understand this with the help of the following examples:
In addition, the system will set the following columns corresponding to the bill routing information of the bill in the CI_BILL_ROUTING table:
Column | Column Value |
---|---|
BATCH_CD | ' ' |
BATCH_NBR | 0 |
NO_BATCH_PRT_SW | 'Y' |
BILL_RTE_TYPE_CD | Here, the column value is set to the bill route types (separated
by comma) for which the extraction of bills is suppressed. Note: If
the extraction of bills is suppressed for all bill route types, the
column value would be NULL.
|
If required, you can deselect the Do No Extract option for a bill route type whenever required for a bill from the Bill screen.
Example 1
If you set the following values in the C1-SUPPBILLS algorithm:
-
Consider Threshold Limit – Y
-
Routing Threshold Debit Amount – 5
-
Routing Threshold Credit Amount – –5
-
Consider Ledger Impact – Y
-
Routing Type To Be Suppressed – Postal
Then, the system will behave in the following manner:
Bill | Bill Amount | GL Exists | Select the Do No Extract Option |
---|---|---|---|
BILL 1 | 0 | No | Yes |
BILL 2 | 0 | Yes | No |
BILL 3 | 3 | No | Yes |
BILL 4 | 3 | Yes | No |
BILL 5 | -4 | No | Yes |
BILL 6 | -4 | Yes | No |
BILL 7 | 10 | No | No |
BILL 8 | 10 | Yes | No |
BILL 9 | -16 | No | No |
BILL 10 | -16 | Yes | No |
As mentioned in the above table, the system will accordingly select the Do No Extract option for the Postal bill route type.
Example 2
If you set the following values in the C1-SUPPBILLS algorithm:
-
Consider Threshold Limit – Y
-
Routing Threshold Debit Amount – 5
-
Routing Threshold Credit Amount – –5
-
Consider Ledger Impact – N
-
Routing Type To Be Suppressed – Postal, Email
Then, the system will behave in the following manner:
Bill | Bill Amount | GL Exists | Select the Do No Extract Option |
---|---|---|---|
BILL 1 | 0 | No | Yes |
BILL 2 | 0 | Yes | Yes |
BILL 3 | 3 | No | Yes |
BILL 4 | 3 | Yes | Yes |
BILL 5 | -4 | No | Yes |
BILL 6 | -4 | Yes | Yes |
BILL 7 | 10 | No | No |
BILL 8 | 10 | Yes | No |
BILL 9 | -16 | No | No |
BILL 10 | -16 | Yes | No |
As mentioned in the above table, the system will accordingly select the Do No Extract option for the Postal and Email bill route types.
Example 3
If you set the following values in the C1-SUPPBILLS algorithm:
-
Consider Threshold Limit – N
-
Consider Ledger Impact – Y
Then, the system will behave in the following manner:
Bill | Bill Amount | GL Exists | Select the Do No Extract Option |
---|---|---|---|
BILL 1 | 0 | No | Yes |
BILL 2 | 0 | Yes | No |
BILL 3 | 3 | No | No |
BILL 4 | 3 | Yes | No |
BILL 5 | -4 | No | No |
BILL 6 | -4 | Yes | No |
As mentioned in the above table, the system will accordingly select the Do No Extract option for all bill route types.