Administration Guide for Oracle Self-Service E-Billing > Running the ETL Jobs Using Oracle Workflow Manager > Process of Setting Up New Database Partitions >

Associating Data with a Group

You must associate company (Business Edition) or account (Consumer Edition) data with a particular group so that the ETL load can assign the data to the defined group and the ETL load validation can work properly. For details about setting the parameter in the EBILL_DATALOAD job that validates the group associations, see Running the EBILL_DATALOAD Job.

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 Self-Service E-Billing maintains the data-group associations you create in the partition mapping table.

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

To associate a company with a partition group (Business Edition)

• Using a SQL tool such as Toad, Oracle SQL developer, or SQL*Plus, run the MapCompanytoPartition.sql script, located EDX_HOME/applications/db/oracle/olap/etl/owb directory (the EDX_HOME\applications\db\oracle\olap\etl\owb directory on Windows). 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.

To associate an account with a partition group (Company Edition)

• Using a SQL tool such as Toad, Oracle SQL developer, or SQL*Plus, run the MapAccounttoPartition.sql script, located EDX_HOME/applications/db/oracle/olap/etl/owb directory (the EDX_HOME\applications\db\oracle\olap\etl\owb directory on Windows). 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.