How You Import Credit Card Transactions with Tokens

Use AutoInvoice to import credit card transactions with tokens. The credit card tokenization process makes use of a third-party service provider to store the credit card information belonging to a transaction and replace it with a token.

You enable credit card tokenization in Oracle Payments. Credit card tokenization provides the essential information to process a credit card transaction and can optionally contain authorization of the transaction. If the token doesn't include authorization, then the authorization takes place in Payments after you generate the automatic receipts and create the remittance.

Tokenization Columns in the AutoInvoice Import Template

The AutoInvoice Import template contains columns, hidden by default, for credit card tokenization.

The following table provides the name and description of each of these columns:

Column Name

Description

Credit Card Token Number

The token number issued by the tokenization service provider that corresponds to the credit card number on the transaction. This is a required field for tokenization import.

Credit Card Expiration Date

The credit card expiration date.

First Name of the Credit Card Holder

The first name of the card holder.

Last Name of the Credit Card Holder

The last name of the card holder.

Credit Card Issuer Code

The code that identifies the credit card issuer, as defined by the IBY_CARD_TYPES lookup.

Masked Credit Card Number

The masked format of the credit card number, used where the number is displayed.

Credit Card Authorization Request Identifier

If available, the authorization request identifier received from the tokenization service provider to authorize the credit card number.

Credit Card Voice Authorization Code

If available, the voice authorization code received from the tokenization service provider to authorize the credit card number.

Note: The authorization code columns are used to import credit card authorization information other than the Credit Card Token Number. Use either the Credit Card Authorization Request Identifier or the Credit Card Voice Authorization Code column. If you provide values in both columns, the Credit Card Authorization Request Identifier takes precedence.

Import Credit Card Transactions with Tokens

To import credit card transactions with tokens:

  1. Expose and complete the applicable columns in the AutoInvoice Import template.

  2. Run the Load Interface File for Import process for the AutoInvoice Import template to load the transaction data into the AutoInvoice interface tables.

  3. Run the Import AutoInvoice process to load the data into Receivables and create the transactions.

  4. Use the Review Transaction page to review the details of each transaction.