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

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, you can develop a customized store procedure. Insert a new rule entry in the table, and the Oracle Self-Service E-Billling 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.