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.

Note: The system assumes that the debit and credit threshold amount are specified in the bill currency.

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.