Administration Guide for Oracle Billing Insight > Command Center Jobs and Configuration Parameters > Payment Jobs >

pmtPaymentReminder Job


The pmtPaymentReminder job populates the email notifications that will be sent to customers. This job sends payment reminder email notifications to the following types of customers:

  • Who have configured payment reminders.
  • When the status of a check changes to Processed, Failed, Canceled, or Returned.
  • When the status of a credit card changes to Paid, Failed, Canceled, or Returned.

The operations that you can perform for the pmtPaymentReminder Job are as follows:

  • Payment Reminders. Email notifications are sent out for customers who have set up payment reminders. pmtPaymentReminder sends out reminder email for reminders in the payment_reminders table whose next_reminder_date is today or later, and whose Reminded field is N. After sending the email, the Reminded field is updated to Y, and the next_reminder_date field is updated as specified by the reminder_interval field.
  • Check Payment Notification. pmtPaymentReminder sends out email for checks as configured in the job. Email notifications can be sent for rows in the check_payments table where the status field value is Returned, Failed, or Processed. The Processed status indicates a payment was sent for processing. After sending the email, the Reminded field is updated to Y.

    The check status values are shown in Table 33.

    Table 33. Check Status Values
    Check Status
    Value

    Returned

    -4

    Failed

    -1

    Scheduled

    6

    Processed

    7

    Paid

    8

    Canceled

    9

  • Credit Card Payments. pmtPaymentReminder sends email for the scheduled credit cards in the creditcard_payments table whose status field is Settled or Failed to Authorize, and whose reminded field is N. After sending email, pmtPaymentReminder sets the reminded field to Y. pmtCreditCardSubmit sets the reminded field back to N when it makes a payment for that scheduled credit card.
  • Email Templates. The email address is retrieved from the payer_email_addr field in the payment_reminders table. Email content is created using the email template file configured for this job. The default template file is paymentReminder.txt, which is in the EDX_HOME/payment/lib/payment_resources/ directory.

    The template used for the email sent with a configured payment reminder is payment_reminder_fixed.xml.vm.

    The template used for the email sent when a check's status changes to Processed, Failed, Canceled, or Returned is payment_reminder_predue.xml.vm.

    The pmtPaymentReminder job also uses the notifyEnroll.txt and payment_account_status.xml.vm templates.

NOTE:  The Notifier job is responsible for sending the email notification to the customer from the MESSENGER_GROUP Table.

The pmtPaymentReminder job consists of the PaymentReminderTask.

Parameters for Configuring the PaymentReminderTask

Table 34 describes the parameters you configure for the PaymentReminder task.

Table 34. Parameters for Configuring the PaymentReminder Task
Parameter
Description

Implementation of Interface IPaymentReminderPlugIn

Optional class that modifies the IPaymentReminderPlugIn plug-in. You can modify whether a payment reminder is sent and other actions dependent on the type of reminder.

For information about implementing this class, contact your Oracle sales representative to request assistance from Oracle's Professional Services. The default is com.edocs.common.payment.tasks.reminder.PaymentReminderPlugIn.

Notify if a check is sent for processing?

Indicates whether notification is to be sent for checks that were sent for processing.

Notify if a check is cleared?

Indicates whether notification is to be sent for checks that have been paid, or cleared.

Notify if an ACH transaction fails, is returned or is canceled?

Indicates whether notification is to be sent for checks that were returned by the payment gateway as canceled, returned or failed settlement.

Notify if a credit card is settled

Indicates whether email must be sent for credit card payments that are settled successfully.

Notify if a credit card transaction is not authorized or is canceled

Indicates whether email must be sent for credit card payments that failed to authorize or were canceled by the Payment module.

Administration Guide for Oracle Billing Insight Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.