Implementation Guide for Oracle Self-Service E-Billing > Customizing Billing Statements > About Split Billing Rules Management APIs >

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 a customer has more categories to be used in the split-billing feature, a new entry can be added into the table.

Oracle Self-Service E-Billling 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)