Do you have issues while approving promotions by using Oracle Retail Price Management module, or with conflict checking, deals, invoice matching, deals to name just a few of processes?

Have you ever heard for Location Move, Future Cost Engine Batch or New Item Location batch?

If the answer is yes, then you are in our area of expertise.

What are the most common issues with Oracle Retail Suite?

There are two main areas of issues with Oracle Retail system: batch programs from one side, and modules (like Price Management) that are doing heavily data processing while executing complex business calculations on the other side.

As Oracle Retail have to process large quantities of data, such processing is executed by using many batch programs, written in Pro*C and Java mainly.

Basically, Oracle Retail has two systems in one suite. First one is classical OLTP system, while the other one is batch system, which is similar to ETL process that imports fresh data into the Data Warehouse.

To handle such type of processing, Oracle Retail is using many temporary, nested and object tables.

Main issues with such SW architecture and design comes from the fact that each customer has significantly different volume and type of the data (like number of stores, items…).

As Oracle database has some hard coded rules how to calculate temporary/nested/object tables, what is working fine for one customer, for the other one works too slowly.

In addition, even a tiny change in execution plan is sufficient to delay finishing of some business process, when the data volume is large.

Oracle Support notes are far from sufficient to help customers to stabilize the Oracle Retail system, with limited influence on performance improvement.

How can we help?

By optimising SW architecture, Database Design, the code itself, and all components of the infrastructure stack (from the storage, OS, Database, WebLogic, OSB, BI Publisher etc.), customers can expect many times faster system (up to 1000x)

That not only result in huge licenses cost savings, but also speed up all critical business processes.

For large customer, we usually did many optimizations, resulting from 10x up to 1.000 times faster system.

In a short period of Discovery engagement, we can record all issues found on the target Oracle Retail System, and suggest how to resolve it.

Armed with a knowledge of 25+ years of work with Oracle products, 20+ years specialization in Oracle performance tuning and many thousand problems solved on the largest projects, customers can be confident to get the best consultancy support to resolve their issues.


There are no comments yet. Why not start the discussion?

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.