Advanced Pricing in Oracle Ebusiness Suite has provided the functionality to allow us to set up custom qualifiers based on the attribute values in an active cart. Cart header information resides in aso_quote_headers_all and the line information resides in aso_quote_lines_all table.
You can change the look and feel of the catalog and shopping cart pages by modifying their bin layouts. The seeded pages are divided into bins. Several bins display the content of seeded JSPs. The catalog and shopping cart pages also have bins without seeded source files. You can associate these bins with custom source …read more
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).
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
© Copyright 2001 - iBiz Software Inc
