Administration Guide for Oracle Billing Insight > Database Partitioning > Process of Setting Up New Group Database Partitions >

Associating Data with a Partition Group

You must associate a company (Business Edition) or an account (Consumer Edition) data with a particular partition group so that the billing data load process can assign the data to the defined group and the data load validation can work properly. For details about setting the parameter that validates the group associations, see Process of Loading Billing Data.

A company or account can be associated with a single group key only. A group key can be associated with multiple companies or accounts, however. Do not combine business (company) and consumer (account) data in the same group.

Whenever you have new companies or accounts, you must add associations for that data before loading the data file.

Oracle Billing Insight maintains the data-group associations you create in the partition mapping table.

This task is a step in Process of Setting Up New Group Database Partitions.

Associating a Company with a Partition Group in the Business Edition

In the Business Edition of Oracle Billing Insight you can associate a company with a partition group.

To associate a company with a partition group in the Business Edition

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, run the MapCompanytoPartition.sql script, located in the following directory:
  • UNIX. EDX_HOME/applications/db/oracle/olap/etl/owb
  • Windows. EDX_HOME\applications\db\oracle\olap\etl\owb

    Specify the following input parameters with the function:

  • COMPANY ID. The company_cd value in the EDX_RPT_COMPANY_DIM table.
  • GROUP KEY. The group_key value in the EDX_RPT_PARTN_MGMT table.

    This script inserts the associations to the EDX_RPT_PARTN_COMP_MAP table. Any errors display on-screen using the Oracle dbms_output.put_line function.

Associating an Account with a Partition Group in the Consumer Edition

In the Consumer Edition of Oracle Billing Insight you can associate an account with a partition group.

To associate an account with a partition group in the Consumer Edition

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, run the MapAccounttoPartition.sql script, located in the following directory:
  • UNIX. EDX_HOME/applications/db/oracle/olap/etl/owb
  • Windows.EDX_HOME\applications\db\oracle\olap\etl\owb
• Specify the following input parameters with the function:
  • BILLER ID. The biller_id value in the EDX_RPT_ACCOUNT_DIM table.
  • ACCT NUM. The account_num value in the EDX_RPT__ACCOUNT_DIM table.
  • GROUP KEY. The group_key value in the EDX_RPT_PARTN_MGMT table.

    inserts the associations to the EDX_RPT_PARTN_ACCT_MAP table. Any errors display on-screen using the Oracle dbms_output.put_line function.