How are the SF_PAYMENT and SF_PAYMENT_LOG Tables Populated When Processing a Credit Card Payment in the Cashiers Office? (Doc ID 2903022.1)

Last updated on JANUARY 26, 2024

Applies to:

Goal

When implementing functionality involving hosted payments, it is helpful to fully understanding the process flow with how the SF_PAYMENT and SF_PAYMENT_LOG Tables are populated when processing a credit card payment in the Cashiers Office.

An example of the wider context for this question, in one reported case, was as follows:

• The institution is looking leverage the TouchnetCC Payment merchant to complete hosted payments. The related set up is on Set Up SACR - Common Definitions - Electronic Payments - Payment Merchant.
• In testing under Student Financials - Cashiering - Post Corporate Payments, a payment attempt is made, and the target, term, tender, and amounts are entered as expected.
• Upon clicking the "Tender Details" link, the 91 transaction is completed successfully and logged in IB synchronous service.
• The user then is directed to Touchnet where the payment information is entered, then retuned to the CS system.
• Back in CS, the user is presented the option to "Authorize and Print". All functionality is working as expected to this point. Upon clicking the "Authorize and Print" button, it is expected for CS to authorize the transaction via transaction 92. This does not occur - instead, no transaction is sent, an authorization code is not presented, and the page is only saved with no visual change (receipt is opened in a new window).
• In checking the user account,  the payment did post within PeopleSoft, but is not logged within the SF_PAYMENT table.
• In previous testing in an older environment with updated PeopleTools, when a similar issue was seen,  un-checking the Realtime transaction override checkbox - under Set Up SACR > Product Related > Student Financials > Cashiering > Cashiering Offices > Transaction Setup - allowed the transaction to successfully complete. However, re-testing in a new environment, with this same step and all of the other same configurations as before, is not producing the same results.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.