All posts by iBizSoft

Custom Payment Processing Solution

Posted by iBizSoft in Uncategorized

we find there is a great demand for Custom Payment Processing solutions that integrates with Oracle Payments (or iPayment as it used to be called when it was part of the earlier releases).

Cancelling an Order from with in iStore

Posted by iBizSoft in Uncategorized

One of our customer was not convinced with the idea of Oracle’s out-of-the-box functionality that High Risk credit card orders or Authorizatoin Failed Ordres are put on Hold by Order Management. And this is done by the Credit Card Authorization API (technically iby_payment_adapter_pub a public API) which is called from with OE_ORDER_PUB API.

Associated an iStore User to an existing Account Number

Posted by iBizSoft in Uncategorized

If you are looking to link an iStore user to an existing Account number, you may wonder what is the big deal about it – entering the Party Id (which is equivalent to customer_id in the fnd_user table) in the Security –> Users form should suffice. If only that was the case.

How to apply Agreements in iStore

Posted by iBizSoft in Uncategorized

Agreements can be applied at the line level only after the item is added to the Cart, that’s the standard functionality in iStore. Additionally the end user will need to the Agreement code, just as they need to know the Promotion Code to apply it on the Order. This is one of the drawback one …read more

R12 – Oracle Suppliers

Posted by iBizSoft in Uncategorized

In R12 Accounts Payables, you will notice this change right away, that there is no more supplier form. The Suppliers have gone to self-service now. This is not the only change in the supplier. The suppliers objects have moved from AP product to TCA (Trading Community Architecture) DataModel. Due to this, even the underlying tables …read more

Setting up Loopback Servlet in iPayment

Posted by iBizSoft in Uncategorized

Loopback servlet is an out of the box servlet that Oracle provides to do some preliminary tests. Setting up the servlet is a pretty easy task. One of the tasks that implementors forget is to add the following line of code to the zone.properties file. Additionally, set up a Sample Payment System and make sure …read more

Integrating Moneris API with Oracle iPayment

Posted by iBizSoft in Uncategorized

Moneris APIs for Ecommerce transactions are very easy to use and the support provided by them has been excellent. However, when it comes to integrating these APIs for Authorization or Capture with Oracle iPayment its an ordeal in its own way. Its not Moneris API that poses a challenge its the poor documentation on the …read more

Mapping the iStore JSP files to the Templates

Posted by iBizSoft in Uncategorized

Oracle iStore Administrator can find out the name of the JSP file that is mapped to a template. I have always wondered when Oracle iStore was being developed why they never thought of a UI wherein we can give the JSP file name and it shows up the template name.

Ease of using NetBeans

Posted by iBizSoft in Uncategorized

NetBeans is a great Open Source utility and a one-stop-shop for all your Java, JSP, Servlet development and testing needs. Its certainly reduces a lot of the development time and its a very easy tool to test any kind of web based application. Here are some basic steps to create a project file and deploy …read more

API to Attach documents to a Service Request

Posted by iBizSoft in Uncategorized

Came to know from Oracle Support that there is no public API that would take care of this requirment (refer to the Note : 394811.1 on http://metalink.oracle.com) that corroborates the fact.

OS Commerce integrated with Ebusiness Suite

Posted by iBizSoft in Uncategorized

OS Commerce is one of the many Open Source Ecommerce UI that’s available in the market. There are plenty of Open Source ERPs available as well. However, integrating an Open Source UI with Oracle Ebusiness Suite does have its own challenges and its a very exciting project that we have undertaken.

API to put Orders on Hold

Posted by iBizSoft in Uncategorized

One can write a generic API to put an Order on Hold. Oracle has provided a public API to achieve this task. This API can be called from any application by passing some important parameters such as the Order Header Id and the User Id.

Custom JSP integrated with Ebusiness Suite

Posted by iBizSoft in Uncategorized

We have been, very successfully, deploying custom JSPs that has the same functionality as Oracle iStore and have been able to integrate every functionality, offered by Oracle iStore, with Oracle Ebusiness Suite. We created an merchant UI which integrates 3 modules using a single sign in feature. Even today, Oracle iStore, Oracle iSupport and Oracle …read more

Forgotten Password

Posted by iBizSoft in Uncategorized

If you trying to understand how ‘Forgotten Password’ functionality works, then this article would be greatly beneficial to you. Specially, if your customer has asked you to send out two emails to two separate email addresses. This feature is not supported by any of the Oracle Self-service products, such as iStore, iSupport etc.

Using TCA APIs to Create Customer Information

Posted by iBizSoft in Uncategorized

Oracle has provided TCA APIs, written in PL/SQL Procedures/Packages, that can be put to very good use for any Application that interfaces with Oracle Ebusiness Suite. We just need to be careful in the order in which these APIs need to be called, and the parameters that need to be passed for successful creation of …read more