Administration Guide for Oracle Self-Service E-Billing > 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 screen. Information removed from OLAP hierarchy tables does not display a message because dbms_output does not work across 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

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name -hierarchy billing -company "Company ID"

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP 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

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name -hierarchy business -company "Company ID"

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP 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

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name -hierarchy assign -user User ID

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP 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_BSL_AMF_BACCOUNT

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

• Run the following command from the EDX_HOME/bin directory (the EDX_HOME\bin directory on Windows):

  UNIX:

  ./purge_data.sh -connstr OLTP schema username/OLTP schema password@OLTP TNS name -hierarchy service -company "Company ID"

  Windows:

  purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name -hierarchy service -company "Company ID"