Credit Card Processing Analytics

Credit Card Processing Analytics Overview

This topic group provides details of the pages provided for viewing the key performance metrics such as transaction summaries, payee summaries, and other critical performance indicators.

All business intelligence information is summarized and displayed through the Oracle Payment credit card processing analytics user interface. Oracle Payments rolls up the key critical performance indicators across all systems, types of cards, and transaction types. Credit card processing analytics provides a tabular and graphical view of the various business credit card processing analytics trends and how they are changing. The credit card processing analytics user interface is browser-based and implemented using Java and Java Server Pages (JSP).

Oracle Payments Credit Card Processing Analytics User Interface

This table lists the tab names and the functionality available from the Oracle Payments credit card processing analytics user interface.

Note: To create a user with the Credit Card Processing Analytics (Daily Business Close) role, see Step 1. Creating Oracle Payments Users, Oracle Payments Implementation Guide.

Tab Name Functionality
Transaction Summary Transactions are summarized on a daily, monthly, and weekly basis.
Payee Summary Transactions are summarized on a daily, monthly, and weekly basis for a selected payee.

Navigating the Oracle Payments Credit Card Processing Analytics User Interface

The Oracle Payments credit card processing analytics user interface includes the Transaction Summary tab, the Payee Summary tab, and the Reports region space. The Transaction Summary and the Payee Summary tabs on the top of the page remain visible as you navigate through Oracle Payments. The side navigation bars list the information that you can view. When you click on a navigation bar, summarized information for the selected bar appears in the report display space in the lower portion of the page.

Transaction Summary - Daily

The credit card processing Transaction Summary tab opens the Credit Card Daily Business Close page.

The table below describes the graphs and reports displayed in the Credit Card Daily Business Close page.

Report Name Description
Daily Summary Calculates and displays the number and dollar value of transactions on the current date. This is further broken down as:
  • All transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total transactions

  • Total Purchase Card transactions

Hourly Transaction Volume Displays a bar graph depicting the volume of transactions for each hour on the current day.
Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests on the current date for the following transaction types:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests on the current date. For each cause of failure, it displays the number of failures and the dollar value of the transactions.
Card Type Summary Summarizes the transactions by card type for the current date. The summary displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes transactions by system for the current date.
Transaction Risk Summary Summarizes transactions screened for risk for the current date. Provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percentage of transactions identified as risky

Transaction Summary - Weekly

The Weekly navigation link on the Side Panel Menu opens the Credit Card Daily Business Close - Weekly Summary page.

The table below describes the reports displayed in the Credit Card Daily Business Close - Weekly Summary page.

Report Name Description
Weekly Summary Calculates and displays the number and dollar value of transactions during the last seven days including the current date. This is further broken down as:
  • All transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total Transactions

  • Total Purchase Card Transactions

Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests for the last seven days including the current date for the following transaction types:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests for the last seven days including the current date. For each cause of failure, it displays the number of failures and the dollar value of the transactions.
Card Type Summary Summarizes transactions by card type for the last seven days including the current date. Displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes transactions by m for the last seven days including the current date.
Transaction Risk Summary Transactions screened for risk for the last seven days including the current date. Provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percent of transactions identified as risky

Transaction Summary - Monthly

The Monthly link on the Side Panel Menu opens the Credit Card Daily Business Close - Monthly Summary page.

The table below describes the reports displayed in the Credit Card Daily Business Close - Monthly Summary page.

Report Name Description
Monthly Summary Calculates and displays the number and dollar value for transactions during the current month. This is further broken down as:
  • All transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total Credit Card Transactions

  • Total Purchase Card Transactions

Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests for the following transaction types for the current month:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests for the current month. For each cause of failure, it displays the number of failures and the dollar value of the transactions.
Card Type Summary Summarizes transactions by card type for the current month. The summary displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes transactions by m for the current month.
Transaction Risk Summary Summarizes transactions screened for risk for the current month. Provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percentage of transactions identified as risky

Transaction Summary - Transaction Trends

The Trends link on the Side Panel Menu opens the Credit Card Trends - Transaction Trends page.

The table below describes the graphs displayed in the Credit Card Trends - Transaction Trends page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts for the last 12 months, not including the current month.

Transaction Summary - System Trends

The system link on the Side Panel Menu opens the Credit Card Trends - System Trends page.

The table below describes the graphs displayed in the Credit Card Trends - System Trends page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions by m for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts by m for the last 12 months, not including the current month.

Transaction Summary - Card Type Trends

The Card Type link on the Side Panel Menu opens the Credit Card Trends - Card Type Trends page.

The table below describes the graphs displayed in the Credit Card Trends - Card Type Trends page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions by card type for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts by card type for the last 12 months, not including the current month.

Transaction Summary - Failure Trends

The Card Type link on the Side Panel Menu opens the Credit Card Trends - Failure Trends page.

The table below describes the graphs displayed in the Credit Card Trends - Failure Trends page.

Graph Name Description
Total Transactions Plots the trend of the number of failed transactions for each failure type for the last three years, not including the current year.
Total Amount Plots the trend of transaction amounts for each failure type for the past three years not including the current year.

Payee Summary

The Payee Summary tab opens the Select a Payee page. The Select a Payee page lists the available active payees. The user has to select a payee from this page before proceeding to view the different reports available through this tab. The selected payee becomes the default payee for the reports displayed in this tab. To change a payee, select another payee from the Select a Payee link.

Daily Summary by Payee

The Daily link on the Side Panel Menu opens the Credit Card Daily Business Close - Daily Summary by Payee page.

The table below describes the graphs and reports displayed in the Credit Card Daily Business Close - Daily Summary by Payee page.

Report Name Description
Daily Summary Calculates and displays the number and dollar value for transactions during the current date for the selected merchant. This is further broken down as:
  • All Transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total Credit Card Transactions

  • Total Purchase Card Transactions

Hourly Transaction Volume Displays the volume of transactions for each hour of the current day for the selected merchant in a bar graph.
Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests for the following transaction types for the current date and for the selected merchant:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions by the selected merchant are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests for the current date. For each cause of failure, the number of failures and the dollar value of the transactions is displayed.
Card Type Summary Summarizes transactions by card type and selected merchant for the current date. Displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes the transactions by system and selected merchant for the current date.
Transaction Risk Summary Summarizes transactions screened for risk on the current date for the selected merchant. It provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percentage of transactions identified as risky

Weekly Summary by Payee

The Weekly link on the Side Panel Menu opens the Credit Card Daily Business Close - Weekly Summary by Payee page.

The table below describes the reports displayed in the Credit Card Daily Business Close - Weekly Summary by Payee page.

Report Name Description
Weekly Summary Calculates and displays the number and dollar value for the transactions during the last seven days including the current date for the selected merchant. This is further broken down as:
  • All Transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total Credit Card Transactions

  • Total Purchase Card Transactions

Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests for the following transaction types during the last seven days including the current date for the selected merchant:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions by the selected merchant are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests during the last seven days including the current date. For each cause of failure, it displays the number of failures and the dollar value of the transactions.
Card Type Summary Summarizes transactions by card type and selected merchant for the last seven days including the current date. Displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes transactions by system and selected merchant for the last seven days including the current date.
Transaction Risk Summary Summarizes transactions screened for risk during the last seven days including the current date for the selected merchant. It provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percentage of transactions identified as risky

Monthly Summary by Payee

The Monthly link on the Side Panel Menu opens the Credit Card Daily Business Close - Monthly Summary by Payee page.

The table below describes the reports displayed in the Credit Card Daily Business Close - Monthly Summary by Payee page.

Report Name Description
Monthly Summary Calculates and displays the number and dollar value for the transactions during the current month for the selected merchant. This is further broken down as:
  • All Transactions

  • Total Authorization Requests

  • Total Capture/Settlement Requests

  • Total Refunds/Credits

  • Total Authorizations Settled

  • Total Authorizations Outstanding

  • Total Credit Card Transactions

  • Total Purchase Card Transactions

Transaction Summary Calculates and displays the total number of requests, total succeeded requests, total failed requests, and total pending requests for the following transaction types during the current month for the selected merchant:
  • Authorization Requests

  • Capture/Settlement Requests

  • Refunds/Credit Requests

Transaction Failure Summary Transactions by the selected merchant are sorted based on the number of transactions for each cause of failure. The report displays the top five causes of failure for Authorization and Settlement requests for the current month. For each cause of failure, it displays the number of failures and the dollar value of the transactions.
Card Type Summary Summarizes transactions by the selected merchant and card type for the current month. Displays the average transaction dollar amount for credit cards, each credit card type, and purchase cards.
System Summary Summarizes transactions by system and selected merchant for the current month.
Transaction Risk Summary Summarizes transactions screened for risk during the current month for the selected merchant. Provides information such as:
  • total number of transactions screened for risk

  • percentage of transactions screened for risk

  • number of transactions identified as risky

  • percentage of transactions identified as risky

Transaction Summary - Transaction Trends by Payee

The Trends link on the Side Panel Menu opens the Credit Card Trends - Transaction Trends by Payee page.

The table below describes the graphs displayed in the Credit Card Trends - Transaction Trends by Payee page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions by the selected merchant for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts by the selected merchant for the last 12 months, not including the current month.

Transaction Summary - System Trends by Payee

The system link on the Side Panel Menu opens the Credit Card Trends - System Trends by Payee page.

The table below describes the graphs displayed in the Credit Card Trends - System Trends by Payee page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions by the selected merchant and m for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts by the selected merchant and m for the last 12 months, not including the current month.

Transaction Summary - Card Type Trends by Payee

The Card Type link on the Side Panel Menu opens the Credit Card Trends - Card Type Trends by Payee page.

The table below describes the graphs displayed in the Credit Card Trends - Card Type Trends by Payee page.

Graph Name Description
Total Transactions Plots the trend of the number of transactions by the selected merchant and card type for the last 12 months, not including the current month.
Total Amount Plots the trend of transaction amounts by the selected merchant and card type for the last 12 months, not including the current month.

Transaction Summary - Failure Trends

The Card Type link on the Side Panel Menu opens the Credit Card Trends - Failure Trends page.

The table below describes the graphs displayed in the Credit Card Trends - Failure Trends page.

Graph Name Description
Total Transactions Plots the trend of the number of failed transactions by the selected merchant for each failure type for the last three years, not including the current year.
Total Amount Plots the trend of the total failed transaction amounts by the selected merchant for each failure type for the last three years, not including the current year.