This articles contains answers to frequently asked questions related to CardConnect's Oracle Enterprise Payments solution.
Questions are organized in the following categories:
Is the CardConnect solution Oracle validated?
What reports are available for credit card transactions?
There are several out of box reports available from Oracle that we recommend using. These reports include:
- Automatic Receipt and Remittance Execution Report
- Automatic Receipt Batch Management Report
- Remittance Batch Management Report
- Automatic Receipt Awaiting Confirmation Report
- Transaction Awaiting Consolidation Report
- Unapplied and Unresolved Receipt Register
- Receipts Awaiting Remittance Report
- Transaction Summary Report
In addition, as part of the Oracle R12 CardConnect Solution, you will receive a report to view the data points from Order Management, Accounts Receivables, and CardConnect specific details.
What is a token?
A token is the replacement of the sensitive data with a non-sensitive representation of that data point.
Is the token always the same value for each payment card?
At CardConnect, we offer customers the option to have persistent tokens which means that the token assigned to the card will be the same token assigned if it's used again in the future.
For our SAP customers, we offer one-time use tokens. This means that a new token can be generated every time the same payment card is used.
What does P2PE stand for and why is it important to me?
P2PE stands for point-to-point encryption and it's important to consider as an additional method to secure your companies architecture by providing PCI validated products to secure your data.
For more information, click here.
I'm not taking credit cards in Oracle today. What new programs will I have to execute to process a credit card payment?
The steps required to process the Capture for a transaction are:
- Automatic Receipt Master Program
- Automatic Remittance Master Program
- Funds Capture Process (included in the Remittance Master Program for 11i).
This is standard functionality and more details on the flow are available at Oracle's Document Library. We suggest reviewing the following Oracle documents:
Does the CardConnect solution provide a way to restrict credit cards from being entered into the Oracle credit card fields?
Yes, CardConnect's solution includes a feature that you can implement in your Oracle R12 system to restrict credit card numbers from being entered into the credit card number field, and to only allow tokens to be entered into that field.
What type of call is occurring from the web tokenizer to retrieve the token value?
The Web Tokenizer can be accessed via a merchant’s web browser by entering a card number into the web application screen and invoking an HTTPS call to the CardSecure server to tokenize the card number and utilizing java code the token value is posted back into the Oracle system.
Is the CardConnect Solution implementing custom code in Oracle to accept tokens and utilize the CardConnect gateway?
No, CardConnect’s Validated Solution utilizes the standard credit card column in Oracle and replaces it with a token, and then this value passes over the standard Oracle Gateway Technology.
When does an order Authorize?
When an order begins in Order Management, it authorizes in real-time using Oracle Payments once the order is booked. When an order originates in Receivables, it uses Oracle Payments to capture the required payment details to obtain an authorization. For more details, please refer to Oracle's Payments User Guide.
Does an authorization reserve the funds?
An authorization will validate that the funds are available to be used and hold the funds for five days. If the funds are not captured in five days the processor will release them. These are standard credit card processing guidelines.
How long is an authorization valid for once received?
The standard duration an authorization is valid is roughly 10 days, but it can be less. Also based on configurations in Oracle by card type will determine how long the system will recognize the authorizations as valid. If an authorization is expired but the system sees it has valid, errors will occur and result.
Can we void authorizations?
Oracle Payments no longer supports void transactions, so in order to void authorization requests the system will submit a modified authorization request to change the authorization amount to zero dollars to release the funds. This feature is available for customers who run Oracle 12.2 as the feature is not available for Oracle 11i or 12.1.3. Oracle customers on 11i or 12.1.3 these customers can utilize the CardConnect UI to void the authorization or the can utilize the Oracle functionality to cancel the line, which will ensure that the transaction is not captured but it will leave the authorization open until it expires. It's important to note void transactions can take a few days to complete the void on the card holder cards depending on the processor.
What General Ledger-specific details will the transaction hit?
As part of the Oracle configuration, the customer creates a new receipt method in Accounts Receivable. This receipt method defines the general ledger accounts that each transaction in the credit card process should use.
CardConnect typically sees the following General Ledger’s used:
- Pending Accounts Receivable (AR)
- Cash In Transit
- Cash on Hand
What Accounts Receivable steps must be completed to submit a credit card for capture?
The following Accounts Receivable steps must be completed to submit a credit card for capture:
- Automatic Receipt Master Program
- Automatic Remittance Master Program
- Submit Offline Transactions
- Submit Offline Transactions is only required for Oracle R12 Customers. Oracle 11i includes this step as part of the Automatic Remittance Master Program.
How do I pay multiple invoices simultaneously?
Oracle allows you to create a credit memo and apply the necessary invoice(s) to this credit memo. Once the credit memo is created, it will run through the remaining out of the box programs to complete capture steps for receipt, remittance, funds, and capture.
How do I pay a past due invoice that was originally to be paid via check/cash and the customer wants to pay via credit card?
Oracle allows the receipt method to be updated and the credit card payment instrument and details to be applied, once this occurs and the invoice is eligible for capture the receipt will be created and submitted through the remaining steps to capture. Eligible invoices mean that their due date less than or equal to today’s date.
Can we add Freight after the original Authorization is created?
Yes, Oracle will manage this incremental change via a new receipt for that amount. To capture the additional funds, the invoice will only be for the full amount.
How do I only use one card supplied by the customer to pay multiple invoices?
Oracle allows the customer to create a credit memo and apply the necessary invoice(s) to this credit memo. Once the credit memo is created, it will run through the remaining out of the box programs to complete capture steps for receipt, remittance, funds, and capture.
Today we run Automatic Receipt Clearing Process, should we continue this process with the CardConnect Solution?
Yes, CardConnect offers its customers who are *eligible the CardDeposit feature which will assist with automatic reconciliation processes to eliminate you time spent each day reconciliation the cash in transit to the cash on hand.
Contact your Sales Representative or click here for more details.
What does it mean when a receipt is in the "Confirmed" status?
It means that the receipt has not yet been sent for Capture. The following scenarios may apply to the transaction:
The Automatic Remittance Master Program has not yet processed the receipt.
The receipt is in error and is waiting for a team member to review. These errors can be managed from the Menu function "Correct Funds Transfer Errors" (Oracle R12) or "Correct Credit Card Errors" (Oracle 11i).
It's a best practice to review errors on a daily basis to align with the concurrent programs running to create new receipt.