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.
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.
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
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
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
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
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.
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
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 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.
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.
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
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.
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
Oracle forms does not offer a whole lot of flexibility, nor is it efficient to query or update a range of Service Requests using Oracle Service. There was this requirement from one of our client to come up with a user friendly and presentable UI, where they can enter the parameters they would like to …read more
© Copyright 2001 - iBiz Software Inc
