Implementation Guide for Oracle Self-Service E-Billing > Customizing Billing Statements >

About Split Billing Rules Management APIs

The split-billing rules management feature enables providers to categorize business and personal mobile phone usage and expenses included on the same statement. Service providers define the split billing rules, and during the data load, Oracle Self-Service E-Billing uses these rules to categorize the expenses.

There are two ways to categorize mobile phone usage:

• All call records are automatically categorized at ETL time, based on the predefined rules. The rule ID is recorded in the EDX_RPT_SERVICE_DETAIL_FACT table for each service detail entry, so Oracle Self-Service E-Billing can track which split billing rule was applied when categorizing the service details.
• Users can manually change the categorization when viewing their statements online if any of the automatic categorization is not appropriate.

About the OLAP.EDX_RPT_ETL_PLUG_RULE Table

This table is where all the categorization rules used for split billing were specified. Upon ETL processing, the rule execution loops through all the records in this table, following the path pointing to an individual rule specified in the RULE_STORED_PROC column, to find the corresponding stored procedure and execute it.

Rules are executed in the order specified in the RULE_EXEC_ORDER column.

If you have additional rules to execute, then you can develop a customized store procedure. Insert a new rule entry in the table, and the Oracle Self-Service E-Billing ETL process will apply the rule automatically.

A special entry (with RULE_TYPE='MAN') in this table represents a manual categorization activity.

When a user recategorizes certain service detail records in the application, the rule ID of the special entry will be recorded in EDX_RPT_SERVICE_DETAIL_FACT table, indicating that the user has manually categorized the service detail and the manual rule ID overwrites the previous split billing rule ID.

About the OLAP.EDX_RPT_SPLIT_CATEGORY_TYPE Table

This table records the category type used in split billing. Currently the category is either business or personal, (CORPORATE CALLS/PERSONAL CALLS). Choose one to be the default category using the CATEGORY_DEFAULT_CODE column, which represents a Boolean flag, indicating the default category type to be used when ambiguity occurs during the categorization process.

The last split billing rule (stored procedure) defined in EDX_RPT_ETL_PLUG_RULE categorizes all of the remaining uncategorized service detail records using the default category specified in this table.

If you have more categories to be used in the split-billing feature, then you can add a new entry to the table.

Oracle Self-Service E-Billing provides the following Split Billing Rules Management APIs:

• ISplitBillingService. The service API for split billing feature, used to retrieve a particular service detail fact record, and change the category on a particular transaction detail. It can also be used to retrieve the list of valid categories defined for categorizing transaction detail records. (API is in package com.edocs.common.api.statement.splitbilling.ISplitBillingService)
• IServiceTransactionDetail. Represents a single one single service detail fact record in EDX_RPT_SERVICE_DETAIL_FACT table. (API is in package com.edocs.common.api.statement.IServiceTransactionDetail)