Administration Guide for Oracle Billing Insight > Administering the Database >
Purging Payment Account and Related Data
The payment purge function lets you remove the following payment account and transactional information from the Oracle Billing Insight 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 users
Purge pending payments removes payments scheduled in advance from the following OLTP tables:
- EDX_PMT_CHK_ACCT_ONETIME
- EDX_PMT_TRANSACTION
Complete the following task to purge any pending payment transactions and refunds for specific criteria. To purge pending payments
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
- UNIX. ./purge_data.sh -connstr
OLTP schema user_name/OLTP schema password@EBILL TNS name Input
- Windows. purge_data.bat -connstr
OLTP schema user_name/OLTP schema password@EBILL TNS name Input
where:
- OLTP schema user_name is the name of the OLTP schema user.
- OLTP schema password is the password of the OLTP schema user.
- EBILL TNS name is the TNS name for the Oracle Billing Insight 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 users
Purging payment accounts removes data from the PAYMENT_ACCOUNTS OLTP table. Complete the following task to purge payment accounts for specific criteria. To purge payment accounts
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
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
- EDX_PMT_TRANSACTION
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 transactions and refunds for the specific criteria. To purge payment history
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
Purging Recurring Payments
You can purge recurring payments for:
- All recurring payments
- A specific company ID
- A specific user ID
- All Consumer Edition 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
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
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 users
Purging payment invoices removes data from the PAYMENT_INVOICES table. Complete the following task to purge payment invoices To purge payment invoices
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
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 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
- Go to the following directory:
- UNIX.
EDX_HOME /bin
- Windows.
EDX_HOME \bin
- Run the following command:
|