Oracle Receivables and iPayment Flow

In this article we are discussing the setups done in Oracle Receivables to process credit card transactions with Oracle iPayment. The setup is done on Oracle Applications version 11.5.10.2, Financials Family Pack G and Credit Card Encryption Patch 4607647.

Moneris is used as the backend payment system.

The following steps are required for the test cases and debug information obtained.

 Moneris is obtained and setup

The Moneris servlet can be obtained from the Moneris website. Install Moneris with Oracle Applications as a Back End Payment System and setup Oracle iPayment in the Oracle iPayment Administrator User Interface.

Oracle iPayment profiles are setup

See "Chapter K Profile Options" in the Oracle iPayment Implementation Guide for iPayment profiles to setup
The ‘ICX: Oracle Payment Server URL’ profile also needs to be setup.

Set profile to the same value as the iPayment ‘IBY: ECAPP URL’ profile.

Oracle Receivables Receipt Class

Navigation: Receivables Manager > Setup > Receipts > Receipt Classes

- Query the ‘Credit Card’ Receipt Class
– For the ‘Merchant Ref’ field, enter the Payee Identifier of the iPayment Payee defined for the Moneris Back End Payment System.

The Payee Identifier can be obtained in the Oracle iPayment Administrator User Interface.

Navigation: iPayment Payment Administrator Responsibility > iPayment Payment Administrator
> Setup Tab > Payee Sub tab

Click on ‘Update Payee’ icon for Moneris Payee

Creating Receipt Manually

This flow is creating a receipt manually (>Receipts>Receipts) which will cause the authorization and capture at the same time.

Create Manual Invoice

Navigation: Receivables Manager Responsibility > Transactions > Transactions

– Source: Manual
– Class: Invoice
– Type: Invoice
– Choose Bill To customer
– Payment Term: Immediate
– Payment Method: Credit Card
– Enter Account Number (4111111111111111 and a future date for expiration date)
– Click on Line Items and enter a line information
– Save
– Press Complete

==>> Make note of Invoice Number

Click on Complete on the Transactions form for the following

On the Receipts form, enter the above Invoice # in the ‘Trans Number’ field, as shown below

Create Receipt

Navigation: > Receipts > Receipts
– Payment Method: Credit Card
– Enter Receipt Number and Amount
– Trans Number: Enter invoice number from previous step
– Enter Customer Bank
– Apply
– Save

==>> Make note of receipt

Click on ‘Apply’ to get the Line details

Click on the ‘Save’ icon on the top of the Navigation and ensure the ‘Saved’ column is checked,
as shown below

Performance Remittance to complete the Authorization and Settlement of funds on this Credit Card type receipt

Remit Receipt

Navigation: > Receipts > Remittances

– Receipt Class: Credit Card
– Payment Method: Credit Card
– Enter Bank information
– Manual Create button
– Receipt Numbers: Enter receipt number from previous step
– Actions: Approve 

Click on the ‘Manual Create’ button and query for the Receipt number generated above, as shown below

Click on the ‘Select’ checkbox and ‘Approve’ this transaction

Click on ‘Yes’ to submit the batch for ‘Approval’.

View the status of the Remittance process

Once ‘Completed’, click on ‘View Output’ and make sure the Transaction does not show any errors

Verify on the Backend Processor user interface (or terminal) for the Authorization and Settlement (Capture) details

Verify the same transactions show up on the iPayment Administrator UI