Administration Guide for Oracle Billing Insight > Recurring Payments >

Database Tables Affected by Recurring Payments

The recurring_payments table only contains the setup information for the recurring payment, which is the data entered from Web interface by end users. It is not used to save bill summary or actual payment information. The amount field in the recurring_payments table records the amount as a result of one of the following actions:

• The recurring payment is configured to pay a fixed amount
• The recurring payment is configured to pay if less than this amount
• The recurring payment is configured to pay up to this amount

Bill summary information is retrieved from the Oracle Billing Insight tables and saved into the payment_bill_summaries table. After the pmtRecurringPayment job runs, the payment_bill_summaries table is populated, and the bill ID of the recurring_payments table is also populated. Payment information is scheduled into the check_payments or creditcard_payments tables.