Administration Guide for Oracle Billing Insight > Database Partitioning >

Rejecting a Data Move Between Partition Groups

If you experience an issue while moving data between partition groups, then you can reject the move.

You might need to reject a move if the move failed, was performed incorrectly, or it was done at an inconvenient time.

You can reject a move for either of the following types of data:

• By Company in the Business Edition
• By Account in the Consumer Edition

When you reject a move, Oracle Billing Insight reverses all the data that was modified or inserted during the move. Table 77 shows a list of tables updated when moving data between partitions.

To reject a move of data between partition groups (Business Edition)

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, call the pr_RejectCompMove function, located in the pkg_olap_group_mgmt package. Specify the following input parameters with the function:
  • p_new_group_key. The key of the group you moved the data to.
  • p_old_group_key. The key of the group you moved the data from.
  • p_company_cd. The code of the company whose data you want to move.

    The function generates one output parameter, p_success, indicating whether the process was successful. A value of zero indicates that the process was successful. Any other value is an error. For errors, see the OLAP log table, EDX_RPT_ETL_LOG and the OLTP log table, EDX_OLTP_LOADER_LOG.

To reject a move of data between partition groups (Consumer Edition)

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, call the function pr_RejectAcctMove, located in the pkg_olap_group_mgmt package. Specify the following input parameters with the function:
  • p_filename. The name of the input file containing a list of account numbers used with the move you are rejecting.
  • p_in_location. The directory path where the file is currently located.
  • p_out_location. The directory path where the file will be moved to for processing.
  • p_new_group_key. The key of the group you moved the data to.
  • p_old_group_key. The key of the group you moved the data from.

    The function generates one output parameter, p_success, indicating whether the process was successful. A value of zero indicates that the process was successful. Any other value is an error. For errors, see the OLAP log table, EDX_RPT_ETL_LOG and the OLTP log table, EDX_OLTP_LOADER_LOG.