Bookshelf Home | Contents | Index | PDF |
Administration Guide for Oracle Self-Service E-Billing > Command Center Jobs and Configuration Parameters > Payment Jobs > pmtCreditCardSubmit JobThe pmtCreditCardSubmit job selects credit card payments that are scheduled to be paid within a configurable number of days before today, and opens a connection to a credit card payment gateway to authorize and settle those transactions. Both authorization and payment are done at the same time. The pmtCreditCardSubmit job submits credit cards to a credit card gateway to be processed. It searches the creditcard_payments table to find all scheduled credit card payments whose status field is Scheduled, or 6, and whose pay_date field has a date the same as or prior to one day after the day the job is running, by default, and sends them the credit card gateway for processing. Credit card account information is saved by the Payment module as part of the payment when the payment is scheduled. Whether this copy of the account information is used for submission depends on the contents of the PID field:
If pmtCreditCardSubmit is successful submitting the credit card payment, then the payment is approved, money is guaranteed to be transferred, and the status of the payment is set to Settled, or 8. If there is a problem submitting the payment, then its status is set to Failed-authorize, or -4. The Payment module supports the PayPal Payflow Pro and uses HTTP to communicate with it. If there is a network problem, then the status of the payment stays Scheduled, but the payment txn_err_msg field gets the error message, ensuring that the payment will be picked up by the next run of the pmtCreditCardSubmit job. If the payment is successful, then the Payment module stores the confirmation number from PayPal Payflow Pro in the txn_number field of the creditcard_payments table. Table 43 describes the columns in the CHECK_PAYMENTS table updated after a credit card is submitted.
Parameters for Configuring the CreditCardSubmitTaskTable 44 describes the configuration parameters for the CreditCardSubmitTask.
Using PayPal Payflow Pro ThreadsTo speed up credit card processing, you can use simultaneous connections, or threads, with PayPal Payflow Pro. By default, the Number of Threads field in the Payment Settings is 1, but you can enter a larger number to speed processing. However, there is a bug with the PayPal Payflow Pro SDK, which causes a connection failure when the number of threads is too high. Connection failures can be significantly reduced by using multiple copies of the PayPal Payflow Pro certificates. By default, there is only one certificate. Connection failures caused by the PayPal Payflow Pro bug are not fatal. The Payment module recognizes the failure and keeps the payment's status as Scheduled so that the failed payments process the next time the pmtCreditCardSubmit job runs. If you increase the number of threads and find there are failures, then schedule your job run twice, back to back. |
Administration Guide for Oracle Self-Service E-Billing | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |