Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

September 18, 2014

Upgrading to Oracle Hyperion for a Very Large EPM Landscape

Upgrading from a stable Oracle Hyperion EPM solution to a newer version is always a critical challenge for any client, as it can have a direct impact on an organization's ability to report externally in a timely manner. Some of the key influencing factors for a Hyperion Upgrade are

        Need for Continued support and additional features like better and intuitive user interface

        Existing Paint Points or Performance Issues

        Leveraging available landscape in a better

        Discontinued product impact of older version and going along future direction from Oracle

        Possible avenues to accelerate close cycle and improve the budgeting and planning process


Continue reading " Upgrading to Oracle Hyperion for a Very Large EPM Landscape " »

September 15, 2014

How Analytics Enables Strategic HR

HR analytics has become a core function of HR departments. HR leaders and managers have become increasingly interested in using data to diagnose organizational problems, understand key drivers of performance, and track the progress and return of HR initiatives. The availability of data and technology has made it possible for HR to develop a deeper understanding of workforce and to lead organizations in adopting the discipline of linking talent with business strategy and execution. In this session, Oracle customers describe how they use Oracle Human Resources Analytics to spot human capital trends and issues and to drive better insights into the HR function, employee retention, and leadership development.

Continue reading " How Analytics Enables Strategic HR " »

Reports - Consolidate, Innovate, Validate

Customer Experience tools including CRM are being touted as next gen ERP and not without a reason. Managers are now able to get in-depth and actionable analysis of customers and their preferences, and analytics have been a big enabler. The amount of information that any application can store today is virtually limitless. To make sense of this information and get actionable insights is what makes an Analytical tool so important. And when you get world class analytics along with CRM with industry best practices built in, it's a game changer.

Continue reading " Reports - Consolidate, Innovate, Validate " »

September 12, 2014

Infosys invites you to Oracle Open World 2014

On behalf of Infosys, I am pleased to invite you to join us at Oracle OpenWorld 2014, which will be held from September 28 to October 2 in San Francisco.
As one of the first two Oracle Diamond-level partners, Infosys has always been a leading participant in this esteemed industry event. This year, we bring you a keynote address by our CEO Dr. Vishal Sikka, and over 20 sessions across trending topics. Watch this video where I give you some highlights of our participation.

I invite you to connect with our experts and learn how you can maximize value from Oracle technologies.

"Internet of Things": Within and beyond the "In-Shop" boundary

Posted by Ashish Verma, Senior Consultant, RCLORC-SBL


In my previous blog on "Internet of Things (IoT)", I talked about how wonderful can be the application of "IoT" for in "In-Shop" experience and how "IoT" will enable retailers to provide a unique shopping experience to customers (read the previous blog: Click Here). My next thought was: "IoT" is such a wonderful concept, if "IoT" can provide such a great experience in "In-Shop", what could be its possible applications beyond the "Shop"? Is such experience limited to within the boundary of a retail store?

Answer is a big "NO", definitely not; "IoT" will continue to serve even after you have moved out of the retail store provided the purchased product is "IoT" enabled. Some common applications are: You don't need to keep track of yearly maintenance schedule of your machines like AC, washing machine or Car etc. Yes, it is true as your appliances and machines will talk to you....thinking how? Through your smart phone...say thanks to "IoT". You will not be needed to worry about "When", "Where" and "What" of after sales services of your internet of things enabled appliances. As "IoT" will provide enhanced after sales services rather value added services such as yearly maintenance reminders, auto refill reminders for your washing machine, remote controlling of electronic appliances etc.  We will keep hearing more about buzz words like Connected Vehicle, Connected Care, Connected Home and Connected Appliances etc. in coming days.

It will be an amazing experience to see how pre-orders for grocery items can be placed to retailers with the help of shelves of a connected home or from a connected refrigerator. A customer can go and collect the items from store without being worried about picking and choosing the items hence saving his/her time. Or a retailer will be able to fulfill such orders with the help of a delivery vehicle or may be robots (Drones are one such step in this direction) and customer will be able to track who is delivering and when.

With so much innovation happening in the digital world, retailers of today, who are leaders and want to be leaders in this industry going forward will have to realize "now" that today's customers are connected in smart ways and the number of such customers is increasing at a faster rate. Such customers will look for smart experience while deciding on their purchasing decisions. A fair conclusion can be drawn from the Gartner research, which suggests that by 2020, the "IoT" will have a far better reach and about 26 billion units (read devices) will be "IoT" enabled by that time.

We can imagine the terabyte of data that will be generated from various connected devices (enabled with IoT) and will be available at the disposal of the retailers. If mined wisely, it will help retailers to understand customer behavior in and out of the retail stores. This will further give them opportunity to optimize/automate the business processes in a big way. Who knows when you enter a retail store enabled with "IoT", you will find it completely unmanned as store will be smart enough to assist you with your shopping needs with the help of "IoT".......isn't it this is similar to "Ramrajaya"......where we will not have any guard but still there will be no robbery or theft as store is smart to detect such frauds. Let me add here, already many banks (like Barclay, Standard Charter etc.) have come up with unmanned smart branches equipped with self-service technologies providing whole gamut of banking facilities. Can we not think of such service model in retail industry as well? Why not? We have "IoT" to help.

The use of sensing devices and technology like RFID, telematics and BIG data are making it possible to do things beyond standard. I happened to came across one such company 'AdhereTech' which provides IoT enabled health care solutions such as a connected pill bottle that ensures patients take their medications as per the prescription and his/her doctor will be able to track it. So guys, things are already happening around "IoT" beyond the 'shop' boundary and we will see more in coming days with the convergence of sensing devices and telematics technologies, as the cost of sensing devices becomes more affordable for the masses.

Infosys too has started investing in this area from last couple of years and developed many off the shelf solutions. We have showcased these solutions in various forums like Oracle Open world and Smart IoE Consortium etc. with a great interest and positive responses from the participating enterprises. Our one such solution on the "Connected Vehicle" was highly appreciated by our customers in Oracle Open world where prognostic messages regarding the health of a vehicle were sent to the vehicle dashboard with the help of the content delivery platform using telematics embedded software. Such solutions convinced me that the "IoT" has potential to empower enterprises with a tool to drive a new source of revenue growth and customer delight. So who can dare to say "No" to it?

I sense that in-shop retailers, with the help of "IoT", can add greater value to the customers not only within their stores but also beyond that. The retailers will definitely have an upper edge with such technology and customers will have a better shopping and product experience. We, in Infosys have to think about ways to make such technology affordable for the retailers so that investment in "IoT" can result into a better "RoI" for them.

September 4, 2014

"Internet of Things": A way towards wonderful "In-Shop" experience

Posted by Ashish Verma, Senior Consultant, RCLORC-SBL


The word "Things" rang a bell when I heard this term for the first time. I researched and found that "Things" can be any tangible object that can be represented by an IP address and has capability to communicate with world of internet. This excited me a lot as it looked to be an upcoming revolution. The "Internet of things (IoT)" is at its early stages of development and will keep on evolving with the convergence of technological advances in sensing devices/microelectronics, telematics and analytics. This whole thing of "Things" looks amazing and paves way for immense possibilities of data sources and its flow. 

Recently I started working for a retail client and this gave me an opportunity to ask myself how this new concept will change the purchasing behavior or rather purchasing experience of customer (read "connected customer")? How retailers are going to react to the "IoT"? Will they adopt it or not? Will it have an impact on their processes? Will it help them regain what they have conveniently lost to online retailers? Let's explore in the below few lines.

Going by the definition of "IoT", it is evident that it has capability to allow products and shelves to communicate with inventory management system, order management system, billing system or with any other IT system. This brings a lot of interest and if we further ponder upon its applications in "in-shop" retail house, it opens a gate for the whole new shopping experience. Customer will no longer be needed to stand in a queue for billing at a retail store....looks like I am kidding? But next few lines will let you know how it is possible. Customer will take a product from the shelf and put it in a "Smart Cart". The smart cart will have the scanning capability attached to it. This smart cart will update the billing system and the smart shelf will keep updating the replenishment system as well. The same smart cart will keep updating you about your billing amount to allow you to make further purchase decision. Auto checkout counter will generate bill to your credit/debit card for the items in your shopping cart. Fabulous! Customer's waiting time at billing counter has almost been reduced to naught.....bang on........customer is happy. 

Another interesting application of "IoT" is in retail apparel house. We all have seen that almost every apparel house has fitting rooms located at the corner of their store........what if we have connected fitting rooms enabled with "IoT". It will be really interesting to see how connected fitting rooms will help customer choose the right cloth in case he has picked up a wrong size or colour. A connected fitting room will know which items you have picked up, what you are trying on and will let you request different sizes and colours from the room itself.  But let me add a word of caution here, though this idea looks very promising and interesting but the cost of such fitting room is a factor that needs to be evaluated vis-a - vis the RoI that it will generate. Real challenge will be to see if supporting staff is able to provide needed support for the customer sitting in a connected fitting room when store is crowded and other customers need equal attention on the floor as well. 

After learning about "IoT", one thing is very clear to me that upcoming digital technologies have open many floodgates for innovation in retail industry. There pros and cons can be evaluated by retailers before going for "IoT" enabled store but it is sure that this new way of shopping experience will be a key competitive differentiator for the retailers and a way to increase foot fall in their stores. At least at the outset, this looks an attractive proposition both for the customer and the retailer. Isn't it?

Guys, this topic has opened a new gate of thoughts for me something like Pandora's Box and I am going to explore more on this in coming days. So, do look out for my next blog on "IoT" wherein we will check out how it is changing not only the "things" within the shop but beyond as well.

July 23, 2014

Critical Role of Training In ERP Adoption

Guest post by
Samik Das, Project Manager, Infosys Limited

"Practice Makes A Man Perfect" is a well known phrase and now let me rephrase the proverb from an ERP implementation perspective as "Users' Practice makes an ERP adoption perfect". Here the million dollar question remains, "How to make the end users practice, practice and practice?" We keep pushing them to achieve this while ignoring the main aspect that they do not have the required comfort to practice. The answer should be - Training.

Training gives Comfort; Comfort makes people Practice, Practice results in Extensive Testing which in turn brings out a good ERP adoption process. Training should be one of the key items of the whole implementation process. In a broader way, two important aspects are to be considered while designing the training. 'Stages' - when the trainings are to be conducted and the 'Content' - which carries the value.

Continue reading " Critical Role of Training In ERP Adoption " »

July 20, 2014

Mighty Oracle Fusion Transportation Intelligence

Retaining customer loyalty, meeting SLA's, managing increasing expectation of stakeholders within existing financial restraints are few of the challenges business face. Logistics hence, plays important role meeting such needs and provides competitive advantage. Transactional logistics data nowadays is not merely part of repository; it has grown as integral part of business strategy in today's world. If harnessed it can provide the competitive edge businesses around the world eye upon. With ever growing data storage capacity per unit cost, Businesses around the world have huge amount of such data. This data if utilized in strategic manner, can provide Intelligence support to day to day business decision or objective support to future strategies.

Oracle Fusion Transportation Intelligence is one such innovative product which meets such business needs. It's a web based solution which integrates Oracle Products such as Oracle Database , Oracle Data Integrator, Oracle Business Intelligence Enterprise Edition & Oracle Transportation Management (OTM).Transactional data residing in OLTP systems (OTM) is fetched into FTI historical repository.The FTI's historical repository act as a datawarehouse & provides information which can be utilized to support various level of decision makings. Organizations need to define and monitor various Key Performance Indicator (KPI's) or Metrics , keeping in mind the strategy , to analyze their business health.


Fusion Trasnportation Intelligence Features :-

·         Industry Specific Dashboards

·         Over 60 Prebuilt KPI's post OTM 6.0

·         Increased Adhoc Querying Capability

·         Interactive Alerts

·         User Defined Customizable Dashboard

·         KPI Targets

·         Performance Indicators

·         Customized Dashboards based on user role

·         Historical Analysis available for Decision Points

·         Process Management- ETL Jobs from OTM UI

·         Data Management- Data Load Status in FTI in Dashboard

·         Analysis At Week Level - Lower Level Of Granularity

·         Refnums Modeling in FTI

·         Ranking of Refnums - 3 Refnums per Object flow into FTI 

User Friendliness :     

  • Put reports in placeholders and if needed share it with other users by granting access
  • Create on the fly reports by simple drag & drop required columns
  • Ad Hoc Querying - Create business reports on ad-hoc requirements

Business Benefits:

·         Operations Benchmarking & Tracking

·         Defining Business Metrics

·         Business analysis spread across various periods

·         Various report available on-demand , to assist in decision making

·         Revise & keep track of business goals.

·         Get alerts based on business events.

·         Target Setting for future

·         Tune business processes


Fusion Transportation Intelligence Architecture Details :

FTI works with Historic Data and fetches data from Oracle OLTP servers. In practice , keeping in view the performance the data source is generally kept as ROD ( Replication of Operational Database) or DR (Disaster Recovery). Oracle Data Integrator fetches up the data from these repository servers. Diagram below depicts Oracle Data Integrator architecture :



In practice , we trigger ETL process ( Extract , Trasform & Load ) from OTM UI. Once triggered , ODI fetches the data from source repository , transforms the data in to denormalized form ( extended star schema ) and finally , pushes data into Historical Database or commonly known as FTI DB. OBIEE ( Oracle Business Intelligence Enterprise Edition ) uses Historical Database for reporting purpose.Finally , OBIEE is linked with OTM/GTM products to access FTI from single UI window.


 Diagram below summarizes the process flow





Infosys Advantage :

Infosys brings it's vast experience in Consulting & System Integration. Apart from mentioned production features and it's implementation , Infosys brings tailored customizations which best suits business needs. Certain features that our expertise brings which doesn't come out of box :

ü  What-If Scenarios

ü  Developing Forecasting Capabilities

ü  Predictive Transportation Analytics & Simulations based on historical data

ü  Data Modelling & Wrangling

ü  Vouchers & Accrual Process Analytics



Fusion Transportation Intelligence brings best of the Oracle Products and it's integrated architecture provides flexibility which can be mould to suit existing business best practices.It's highly recommended for the business who looks forward to make best out of existing logistics data.

June 26, 2014

A Vendors Guide for Understanding BI Deployments - Business v/s IT

Coming back from a recent onsite assignment, I realized how difficult it was being a BI implementation vendor. More so in a world where the Business and IT teams of the same organization view and evaluate the same BI application/platform using different yardsticks.

So what is it that makes these two different views so important to understand in order to develop a solid, easy to use and balanced BI platform which enables an organization to move forward intelligently and without hiccups?

Continue reading " A Vendors Guide for Understanding BI Deployments - Business v/s IT " »

June 19, 2014

More on Oracle Project Manufacturing - A complete solution for Project Manufacturing based industries (Project Procurement)

Guest Post by 
Srushti Gogate, Senior Associate Consultant, Infosys Limited

In the earlier blog we have got ourselves acquainted with the project based procurement for Inventory items using PJM. In this one, we shall throw some light on the below:

1. Inter and Intra project transfers.

2. Track customer orders for specific projects in combination with Oracle Order Management

Continue reading " More on Oracle Project Manufacturing - A complete solution for Project Manufacturing based industries (Project Procurement) " »

Infosys at Oracle OpenWorld 2014. Stay updated.
Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter