Bookshelf Home | Contents | Index | PDF |
Administration Guide for Oracle Self-Service E-Billing > Recurring Payments > Database Tables Affected by Recurring PaymentsThe 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:
Bill summary information is retrieved from the Oracle Self-Service E-Billing 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. |
Administration Guide for Oracle Self-Service E-Billing | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |