Implementation Guide for Oracle Billing Insight > Payment Processing > About Recurring Payment Processing >

Tables Updated by Recurring Payments

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 up to this amount

The recurring_payments table does not save bill summary or payment information.

Oracle Billing Insight pulls bill summary information from the EDX_ACCOUNT_LATEST_STATEMENT table 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 EDX_PMT_TRANSACTION table for check, credit card, or debit cards.. The recurring_payments table is updated with the payment_id.