Bookshelf Home | Contents | Index | PDF     

Administration Guide for Oracle Self-Service E-Billing > Administering the Database >

Purging Payment Account and Transactional Data

The payment purge function lets you remove the following payment account and transactional information from the Oracle Self-Service E-Billing database:

  • Pending payments
  • Payment accounts
  • Payment history
  • Recurring payments
  • Payment invoices
  • Payment notifications
  • Payment audits

Purging Pending Payments

You can purge pending payment accounts for:

  • All pending payments
  • Pending payments for a specific company ID
  • Pending payments for a specific user ID
  • Pending payments for a specific period (with pay_date between specific to and from dates)
  • Pending payments for all Consumer Edition (B2C) users

Purge pending payments removes payments scheduled in advance from the following OLTP tables:

  • EDX_PMT_CHK_ACCT_ONETIME
  • CHECK_PAYMENTS
  • CREDITCARD_PAYMENTS

Complete the following task to purge pending payments.

To purge pending payments

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where:

    • OLTP schema username is the name of the OLTP schema user.
    • OLTP schema password is the password of the OLTP schema user.
    • OLTP TNS name is the TNS name for the OLTP instance.
    • Input is one of the following:
      • All pending payments: -payment pending -company -all
      • Pending payments for a specific company ID: -payment pending -company "Company ID"
      • Pending payments for a specific user ID: -payment pending -user User ID
      • Pending payments for a specific period: -payment pending -date MM-DD-YYYY MM-DD-YYYY
      • Pending payments for all B2C users: -payment pending -b2c

Purging Payment Accounts

Purging payment accounts removes the payment accounts where the delete_date column is not null and also not referenced by any payment transaction. The delete_date_column is not null when a user has deleted the account using the interface.

You can purge payment accounts for:

  • All payment accounts
  • A specific company ID
  • A specific user ID
  • A specific time period
  • All Consumer Edition (B2C) users

Purging payment accounts removes data from the PAYMENT_ACCOUNTS OLTP table.

Complete the following task to purge payment accounts.

To purge payment accounts

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where Input is one of the following:

    • All payment accounts: -payment account -company -all
    • Accounts for a specific company ID: -payment account -company "Company ID"
    • Accounts for a specific user ID: -payment account -user User ID
    • Accounts for a specific period: -payment account -date MM-DD-YYYY MM-DD-YYYY
    • Accounts for all B2C users: -payment account -b2c

Purging Payment History

You can purge payment history for:

  • All payment history
  • A specific company ID
  • A specific company ID and period
  • A specific user ID
  • A specific user ID and period
  • A specific period
  • All Consumer Edition (B2C) users
  • All Consumer Edition (B2C) users for a specific period

Purging payment history removes transactional history data from the following OLTP tables:

  • EDX_PMT_CHK_ACCT_ONETIME
  • CHECK_PAYMENTS
  • CREDITCARD_PAYMENTS

Check payment history and credit card payment history purge by pay date. The Recurring payment history table purges by the timestamp.

Complete the following task to purge payment history.

This task is a step in Process of Purging Sample Data.

To purge payment history

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where Input is one of the following:

    • All payment history: -payment history -company -all
    • Payment history for a specific company ID: -payment history -company "Company ID"
    • Payment history for a specific company ID and period: -payment history -company "Company ID" -date MM-DD-YYYY MM-DD-YYYY
    • Payment history for a specific user ID: -payment history -user User ID
    • Payment history for a specific user ID and period: -payment history -user User ID -date MM-DD-YYYY MM-DD-YYYY
    • Payment history for a specific period: -payment history -date MM-DD-YYYY MM-DD-YYYY
    • Payment history for all B2C users: -payment history -b2c
    • Payment history for all B2C users for a specific period: -payment history -b2c -date MM-DD-YYYY MM-DD-YYYY

Purging Recurring Payments

You can purge recurring payments for:

  • All recurring payments
  • A specific company ID
  • A specific user ID
  • All Consumer Edition (B2C) users

Purging recurring payments removes data from the following OLTP tables:

  • PAYMENT_BILL_SUMMARIES
  • RECURRING_PAYMENTS

Complete the following task to purge recurring payments.

To purge recurring payments

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where Input is one of the following:

    • All recurring payments: -payment recurring -company -all
    • Recurring payments by specific company ID: -payment recurring -company "Company ID"
    • Recurring payments by specific user ID: -payment recurring -user User ID
    • Recurring payments for all B2C users: -payment recurring -b2c

Purging Payment Invoices

You can purge payment invoices for:

  • All payment invoices
  • A specific company ID
  • A specific user ID
  • A specific period
  • All Consumer Edition (B2C) users

Purging payment invoices removes data from the PAYMENT_INVOICES table.

Complete the following task to purge payment invoices

To purge payment invoices

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where Input is one of the following:

    • All payment invoices: -payment invoice -company -all
    • Payment invoices for a specific company ID: -payment invoice -company "Company ID"
    • Payment invoices for a specific user ID: -payment invoice -user User ID
    • Payment invoices for a specific period: -payment invoice -date MM-DD-YYYY MM-DD-YYYY
    • Payment invoices for all B2C users: -payment invoice -b2c

Purging Payment Notifications

You can purge payment notifications for:

  • All payment notifications
  • A specific company ID
  • A specific user ID
  • A specific period
  • All Consumer Edition (B2C) users

Purging payment notifications removes data from the PAYMENT_DUE_NOTIFICATION_ACCTS table.

Purging payment notifications for a specific time period purges the PAYMENT_DUE_NOTIFICATION_ACCTS table by last_processed.

To purge payment notifications

  • 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 Input

    Windows:

    purge_data.bat -connstr OLTP schema username/OLTP schema password@OLTP TNS name Input

    where Input is one of the following:

    • All payment notifications: -payment notification -company -all
    • Payment notifications for a specific company ID: -payment notification -company "Company ID"
    • Payment notifications for a specific user ID: -payment notification -user "User ID"
    • Payment notifications for a specific period: -payment notification -date MM-DD-YYYY MM-DD-YYYY
    • Payment notifications for all B2C users: -payment notification -b2c
    
Administration Guide for Oracle Self-Service E-Billing Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.