PayPal Implementation for Oracle iStore

Oracle iStore is integrated to Order Management and which in turn has APIs that call Oracle Payments in R12 (or Oracle iPayment in 11i). Oracle Payments or iPayment has out-of-the-box servlets or APIs for backend payment systems such as PaymentTech, Verisign , Citibank etc. However, if a user would like to use PayPal as the Payment Method, Oracle iStore does not provide that integration.

Please note that PayPal, an eBay company, bought Verisign and hence in this discussion, I am not referring to the integration to the backend payment system of Verisign. I am referring to adding a radio button called ‘PayPal’ on the iStore Billing page, which you normally see on many ecommerce sites these days.

One of my clients have asked us to have a PayPal integration for Oracle iStore. Initially we thought this was going to be piece of cake, however we did not realize the maze of code that we had go through to implement this already existing functionality with PayPal. The reason why it take typically 2-3 weeks is due to the fact that iStore JSP pages are very tightly tied together.

So we customized the following iStore pages

ibeCCkdBHdrBillPay.jsp (for a B2B user)

ibeCCkdCHdrBillPay.jsp (for a B2C user)

ibeCCkdHdrDisplay.jsp

And additionally, we had to direct the Order Confirmation page to a new page, since the out-of-the-box Oracle iStore JSP (ibeCCkdOrdSummary.jsp) expects a lot of parameters from the previous pages (ibeCCkdOrdReview.jsp and ibeCCkpOrdReview.jsp), and this was causing an issue. Reason being PayPal, after Payment confirmation, is not able to hold those values to return back to the iStore JSPs.

We have a complete solution for PayPal integration with Oracle iStore. Contact us at support@ibizsoftinc.com for more details.