Administration Guide for Oracle Billing Insight > Administering the Database >

Purging Hierarchies and Hierarchy Assignments

This topic describes how to purge the following hierarchy data from the OLAP and OLTP databases:

• Billing hierarchies
• Business hierarchies
• B2B user hierarchy assignments
• Billing accounts and services, from the OLTP database only

NOTE:  Removing information from the OLTP hierarchy table displays a message on a screen. Information removed from the OLAP hierarchy tables does not display a message because dbms_output does not work for the database link. Check the EDX_PURGE_LOG table for OLAP information.

Purging Billing Hierarchies

You can purge billing hierarchy information for a specific company ID only.

Purging billing hierarchies removes data from the following tables:

• OLTP:
  • EDX_HIER_NODE_USER
  • EDX_HIER_NODE_PERIOD
  • EDX_HIER_NODE_ATTRIBUTE
  • EDX_HIER_HNODE
  • EDX_HIER_HIERARCHY
• OLAP:
  • EDX_RPT_CC_CHARGE_WSPACE
  • EDX_RPT_ACCOUNT_WSPACE
  • EDX_RPT_HIERARCHY_NODE_PERIOD
  • EDX_RPT_HIERARCHY_XREF_DIM
  • EDX_RPT_HIERARCHY_TREE_DIM

To purge the billing hierarchy for specific company ID

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy billing -company "Company ID"
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy billing -company "Company ID"

Purging Business Hierarchies

You can purge the business hierarchy for a specific company ID only.

Purging business hierarchies purges data from the following tables:

• OLTP
  • EDX_HIER_NODE_USER
  • EDX_HIER_NODE_PERIOD
  • EDX_HIER_NODE_ATTRIBUTE
  • EDX_HIER_HNODE
  • EDX_HIER_HIERARCHY
• OLAP
  • EDX_RPT_CC_CHARGE_WSPACE
  • EDX_RPT_ACCOUNT_WSPACE
  • EDX_RPT_HIERARCHY_NODE_PERIOD
  • EDX_RPT_HIERARCHY_XREF_DIM
  • EDX_RPT_HIERARCHY_TREE_DIM

Follow these instructions to purge the business hierarchy for a particular company.

To purge the business hierarchy for specific company ID

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy business -company "Company ID"
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy business -company "Company ID"

Purge B2B User Hierarchy Assignments

You can purge B2B user hierarchy assignment information for a specific user ID only.

Purging B2B user hierarchy assignments removes data from the EDX_HIER_NODE_USER OLTP table.

To purge the B2B user hierarchy assignment for specific user ID

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy assign -user User ID
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy assign -user User ID

Purging Billing Accounts and Services

You can purge billing accounts and services data for a specific company ID only.

Purging billing accounts and services removes data from the following OLTP tables:

• EDX_OMF_SERVICECHARGE
• EDX_OMF_SRVICE_PLAN
• USER_SERVICE_AGREEMENT
• EDX_OMF_SERVICEAGREEMENT
• EDX_BSL_ACCT_ATTRIBS
• EDX_OMF_BACCOUNT

To purge billing accounts and service data for a specific company ID

1. Go to the following directory:
   • UNIX. EDX_HOME/bin
   • Windows. EDX_HOME\bin
2. Run the following command:
   • UNIX. ./purge_data.sh -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy service -company "Company ID"
   • Windows. purge_data.bat -connstr OLTP schema user_name/OLTP schema password@EBILL TNS name -hierarchy service -company "Company ID"