Implementation Guide for Oracle Self-Service E-Billing > Payment Processing > About Recurring Payment Processing >

Tables Updated by Recurring Payments

The recurring_payments table only contains the setup information for the recurring payment, which a user enters using a Web interface. This table does not save bill summary or payment information. The amount field in the recurring_payments table records the amount when you do one of the following:

• Specify the recurring payment to pay fixed amount
• Pay if less than this amount
• Pay up to this amount

Oracle Self-Service E-Billing pulls bill summary information from the Command Center tables and saves it into the payment_bill_summaries table. The pmtRecurringPayment job populates the payment_bill_summaries and bill_id of the recurring_payments tables.

Payment information is scheduled into the check_payments (for check) or creditcard_payments (for credit card) tables. The recurring_payments table is updated with the payment_id.