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

« June 2014 | Main | September 2014 »

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.

Stages of Training
  • Training infused at a proper stage always delivers the desired result. Although not the only ones, the below are the vital stages:
  • Exposure to ERPAt the onset of the implementation process, the users should be exposed to the ERP screens, processes etc. This gives the required inputs and sets expectations about the future system.
  • Data Extraction & MigrationData Migration is the soul of an ERP implementation which many a times goes ignored in the initial days of implementation. Exhaustive training enables them to have a proper legacy data extraction to meet the data migration requirements.
  • Navigations: Before the testing starts, navigation training will help core users to achieve the desired comfort level. The testing periods can be utilized into more testing than guiding them with navigations.
  • Milestone Based Training: This is the most common format of training. This helps to refresh the users' memories before they enter the testing phases of the project.

Training Contents: The content of the training plays a vital role to keep users glued to the session. The expectation is set properly and this way, reciprocation between the trainer and trainee becomes more effective. The aspects which we should ideally consider are:
  • Scope: The scope as well as the content should be clearly conveyed to the attendees. This way they can connect in a better way - even get to do the necessary preparations.
  • Pace: The users will be seeing it for the first time and hence the trainer has to go with a comfortable pace. This will make sure that the attendees are able to accept whatever has been conveyed. This is not just listening; they need to reproduce this during the testing sessions.
  • Trainer: A specifically designated or an external trainer provides a great value addition to the training. 
  • Avoid Information Overload: The sessions should be crisp and limited to an optimal duration. This will make sure that attendees are not overloaded with too much information.
  • Train the trainer: Majority of our implementations have training models as 'Train the trainer'. Lack of involvement in the end user training can invite devastation. The implementation team has to make sure that end users receive the adequate information what was conveyed to their Trainers.
  • Follow Up: This can be in several modes, but the most methodical will be to provide exercises, having a short test or /and a special Q&A session.
  • Benefits to Reap: The change is a stressful period for end users to transition from legacy comfort to adopting a new ERP. By explaining the add-on benefits to be derived from the ERP, the interest can be revived to adopt it - at every stage of the testing.

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.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter