Administration Guide for Oracle Self-Service E-Billing > Running the ETL Jobs Using Oracle Workflow Manager >
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 Self-Service E-Billing reverses all the data that was modified or inserted during the move. Table 76 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.
|