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

Main

November 9, 2017

Transaction matching of around two million records in under 5 minutes in ARCS

Oracle Account Reconciliation Cloud Service (ARCS) with Transaction Matching is a cloud based reconciliation platform with pre-built configurations and adherence to industry best practices; a recommended solution to cater to your reconciliation and matching needs.

Transaction Matching is a module within ARCS which inherits the features that facilitate preparation and review of reconciliations.

  • Additionally, Transaction matching adds efficient automation of the detailed comparison of transactions in two or more data sources
  • The calculation engine allows for intuitive "netting" of transactions within each data source to provide output which is easy to work with
  •  Flexibility in the setup and timing of the process allows to minimize the effort during "crunch time" and reduce risk

 

Transaction Matching Use Cases

Typical Transaction Matching Use Cases are shown below.

 

Use Cases.jpg

Often clients need to match more than million records between two source systems with complex match set rules. We have seen clients spending hours to try to manually match them in excel or use some solutions like Access database, Oracle tables etc. which can be very time consuming and have data quality issues. We will share our experience and some insights on how we successfully loaded and matched two source files with around 2 million records in less than 5 minutes using Transaction matching feature of ARCS for one of our e-commerce client.

Idea Inception

Client wanted to match up to 2 million records from their point of sale system (POS) and the details obtained from Merchant transaction system. They were using access data base for this activity which was giving them results in hours and they reached out to Infosys with this requirement to help them streamline this time-consuming and frustrating process.

 

Solution and Approach

Source Files.

1. Point of Sale transaction file.

    The POS file had 9 columns and the file provided was in txt format (a pdf report converted into a text file). Below is the snapshot of the same.

POS.jpg

2. Merchant system transaction file

           The Merchant system transaction file had 21 columns and the file was in csv format. Below is the snapshot of the file.

Merchant.jpg

Matching rules

Client wanted the matching rules to be based on the condition that the card number and the amount from POS transaction file matches against the cardholder number and amount from the Merchant transaction file with the stipulation of many to one transaction match where many transactions from Point of Sale system matches with single batch (grouped by amount) transaction from Merchant system file.

 

Initial Challenges

The initial challenges with this requirement are below

1. Size of File.

    The size of the files provided were huge as there were 9 and 21 columns respectively and both the files had around 2 million records resulting in file sizes of > 1 GB per file. This much large a file is difficult to read and edit by any text editor.

2. Formatting

    Another bigger challenge was formatting the given files as per ARCS transaction matching needs. The files provided were in text format and to read and format them given their file size was a tough nut to crack.

 

Infosys Solution

We took this challenge and delivered as promised. The biggest challenge was to import the file containing about 2 million transactions into the ARCS Transaction matching from both the system and match them automatically in quick time. Other tools and custom solutions were taking hours for this process. Importing 2 million records in a csv file is a huge input for any system to ingest. It would typically take anywhere between 15-30 minutes just to import one file into a system. We had another challenge in formatting the files because the file we received was a .pdf file converted into text format and we needed them to be converted into .csv to be accepted by ARCS Transaction Matching. We used Oracle ARCS TM, formatting tools, text editors and Oracle provided EPM Automate utility to format the files, automatically ingest and auto-match the files from two transactional systems.

 

The EPM Automate Utility enables Service Administrators to remotely perform tasks within Oracle Enterprise Performance Management Cloud instances and automate many repeatable tasks like import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings.

 

Tips and Lessons Learnt

With the above requirement's implementation, we have learned a few lessons and below are some tips when implementing similar type of solution.

  • ARCS TM also accepts .zip format input files, hence compress the files into .zip format so that they are smaller in size plus quick and easy to upload on the ARCS cloud.
  • Powerful text editors like Notepad++ or Textpad when formatting the files, could be used.
  • Create custom attributes which can be used in matching rules for faster auto-matching of transactions.
  • If possible, try to get the export from the transactionsystems in .csv format to reduce conversion times.

Performance Metrics

Below are our performance metrics while implementing client's requirement of matching around 2 million records using Oracle ARCS Transaction Matching.

 

Import POS million records - 27 seconds

Import Merchant million records - 61 seconds

Run Auto Match - 53 seconds

 

Complete Process - 2 minutes 21 seconds (Less than half of 5 minutes)

 

Result?

 

Happy client and Happy us.

 

We deliver!!!! - Please visit our company website to know more about our Account Reconciliation and Transaction matching solutions.



September 28, 2017

OBIEE: An effective tool for quality control in Credit Bureau Reporting by Auto-Finance Companies

Auto-finance Organizations in US have to report the credit data of their customers every month to Credit Reporting Agencies (CRAs) i.e. Experian, Equifax, Transunion and Innovis to comply with FCRA (Federal Credit Reporting Act) of US law. For this they have automated software programs in place which extract the account and consumer data from their source systems and transform/ load the data as per defined business logic into data warehousing tables before it is finally sent to CRAs in the format of Metro 2 files. This process is called 'Credit Bureau Reporting'.

Continue reading " OBIEE: An effective tool for quality control in Credit Bureau Reporting by Auto-Finance Companies " »

September 25, 2017

Why Knowledge Management in Enterprise?

KM Solution in Enterprise Eco System is a necessity than just an additional tool. When world is talking about automation, digitization, what and what not; KM Solution has huge contribution in enabling enterprise achieving goals and meeting objectives. This Quadrant explains where KM can really help Enterprise; Knowledge Sharing, Collaboration, Self Service, and Agent Productivity.  

ss-pic1.png
ss-pic2.png

Knowledge Sharing: 

Knowledge Sharing" is a huge problem across industry, team, business unit, you can keep adding area in the list. Small to Large companies spend millions of $$ training their employees every year and it keep increasing by almost 1% every year. Research also says with class room training only 10% skills can be enhanced. So, what about rest of the skill development. Those come from On-The-Job experience. Can we just deploy people on critical assignments post-classroom training? Answer is Yes and No. "Yes", because that's how you make him/her learn on-the-job. "No", because you cannot leave him/her alone and/or expose to customer. You need to mentor, coach, and provide right feedback at right time.  This is the issue in Service Industry, Corporate, Product Companies and any other. So, the question is can KM solve this issue? Probably yes. It gives a platform where people can learn, get help while on-the-job, mentor/coach can spend their some of the time in doing other productive work.

ss-pic2.png

Collaboration: 

The idea of collaboration is not new. We see people talking about it all the time and at all the places. But the question is how does this help, why is it so important and most importantly how KM helps? Too many questions and answer is also not very straight. Collaboration is something which has hidden return. This is probably something which has hidden return. This is not something which can be measured but certainly experienced. When we talk about team; can each one in the team work alone and at the end combining individual's work will complete the assignment? In most of the cases no. So, collaboration is required. When we say team, its collaboration, work together and make sure that team is moving in right direction from day one. Now what is KM? It's knowledge repository, brain dump of each and every one to help the mass. So, shouldn't Knowledge Base be an invaluable asset. Enabling collaboration feature in KM Solution helps contributor collaborate with peers, SMEs and other colleagues get their view point, feedback and input to ensure what is going in repository is thought through not something which is just written by someone for no reason. Collaboration in KM world brings KM maturity.
ss-pic2.png

Self Service: 

Companies spend unaccounted dollars to make sure customer is "Happy". This is not an easy task. There are so many delivery systems have been researched and implemented over the period to make customers happy. KM is one of them. KM has huge role in customer service. Customer can call to helpdesk, you can deploy very intelligent people in handling customer's call. This is all good but wouldn't it be good to avoid getting calls from customers at first place? Yes, it is easy to say but the question is how? Self Service is one of way to overcome from this problem. This is also called as "Case Deflection". Let customer find the right information by delivering information through omni channel. Deflect the problem by exposing the information they need. If you have mature KB repository it's difficult and brings huge value add in customer service.
picss-5.png

Agent Productivity: 

Companies spend unaccounted dollars to make sure customer is "Happy".Other side of Customer Satisfaction is how to increase the Agent's productivity. How to make sure that Agent is spending less time resolving the customer issue and at the same time able to handle more and more calls. One way is to deflect the customer problem by enabling Self Service. But it doesn't work alone. Agent should equally productive. To do so, KM should also be exposed to Agent. Agent actually needs little more than just exposing KM to them. It has to be Contextual. We don't want agent to scan through entire repository to look for the right answer of the problem customer is facing. Rather, system should be intelligent enough understand the context of the problem like who is the customer, area of concern, etc.Agents are the best contributors in maturing KM repository. They have tons of information within by working in diverse situation, so enable KM to agents to increase their productivity, get best ROI, make customers happy and progressing towards matured KM repository. Finally, these are said at many places and many times but still we have Industries and Companies lacking in this area. KM is an integral part of Automation, Digitization, and Customer Experience.


Who Can use It?

"Who needs Knowledge Management and Why?" seems difficult question but answer is simple "Everyone needs it". Every Enterprise needs Knowledge Management irrespective of industry they belong to. Below is why? 
ss-pic6.png

Thank You!

Shubhra Sinha

Shubhra_Sinha@infosys.com

February 28, 2017

B2B CPQ eCommerce Solution for Professional Service Sector

A leading Professional Service provider is evaluating their Business Model to enable eCommerce for business sales. More importantly it is being assessed during transformation phase from On Prim to Cloud. To me, it really looks like a game changer move to evolve eCommerce DNA right at the inception of platform change. It would not really matter if the eCommerce solution is implemented immediately or at a later stage. Point is that Business has cleared its intention and solution should be designed to give configuration and fulfillment experience to End Customer even if it's at a later stage. Oracle CPQ fits perfectly for their quote to order journey with its capability to accurately manage the innumerable factors that come with current B2B dealings. Blog aims to brings forward all the reasons as to how CPQ factor into all this

 

·         Uniformity across platforms eases the usage wherein end customer can start on a mobile device and finish it on a tab or a desktop. CPQ provides consistent user experience and empowers easy usage across channels

·         Attractive pricing is the key for great conversions. End customers can be grouped under various criteria and offers can be given based on preemptive planning on pain areas. Targeting the right customer at right time is the end target. CPQ offers part pricing, attribute and complex formula based pricing. Additionally end customer has the capability to compare prices of products and services selected to make the appropriate decisions.

·         Guided Selling is a strong feature that will navigate end customer through complex product offerings in a simplified way; concurrently pitching for up-sells and cross sells. These are achieved though recommendations, hiding, constraints rules based on organizational requirements and best practices to be followed as learnt from experiences. Intelligent recommendations become crucial to success.

·         Large chunk of transactions are repeat orders where end customers can review their transaction history from transaction page in CPQ.

·         Full featured shopping cart ease the usage with one click checkout and easy modification of quantity of offerings selected

·         CPQ also provides easy access to various finer details essential for a typical eCommerce flow including shipping methods and payment terms

·         Personalized branded proposals can be done as per organizational needs

·         CPQ Cloud supports integration with industry leading provider of electronic signature solutions DocuSign where documents can be electronically managed with real time updates back to CPQ.

·         Payments are also supported where in CPQ eCommerce Transactions Cloud Service can integrate with various payment dispensation players.

 

Culturing Do-It-Yourself ethos leads to higher realized margins where Oracle CPQ is offering easy and high quality buying. To add on top of it, Oracle CPQ provides eCommerce APIs to integrate with Commerce Cloud in case you want to continue with it to avail best benefit of both worlds. In a nutshell, let the Customers buy in a way they prefer - via Sales Agent, self-service or Partners and in a channel they prefer! Rapidly growing Oracle CPQ surely enables an intuitive customer experience in all dimensions!

September 8, 2016

Internet of Things (IoT) in field service management (FSM)

In today's competitive world, real-time data and innovative service methods are vital for field service enterprises to ensure customer delight, increase revenues, and expand profit margins.

The IoT explained

The Internet of Things (IoT) allows machines to communicate with each other (M2M communication). It is built using a combination of networks that comprise of data-gathering sensors, devices, big data, analytics, and cloud computing, which communicate via secured and encrypted channels. Connected devices enable efficient predictive maintenance by constantly providing information on a machine's performance, environmental conditions, and the possibility of failures. IoT can connect machines on the field in order to record incidents in real-time into a semi-intelligent 'Gen-X' FSM system.

Integrating IoT with FSM software applications

Field service organizations always strive to consistently provide the best service experience to their customers, by ensuring immediate repair and maintenance of their equipment and machinery. By collecting data about the machine's health and performance from IoT sensors, organizations can leverage predictive and preventive field service to minimize device downtime.


Three primary traditional FSM challenges

Here are three primary issues that challenge the current reactive scenarios:

    Field technicians execute the job and fix the equipment after the issue is reported. However, the delay can impact business continuity, which in turn affects the operating profit margins


    Adding more field technicians and service trucks to the field comes at a cost and sometimes the increased capacity remains under-used


    Assigning more work to existing field teams can have a negative impact on SLAs and first-time fix rates. Even worse, it can increase the cost of travel and overtime

Essentials of a new-age FSM solution

A field service management system that integrates device sensor data, technicians, customers, and technology is the key to address these issues. It should function in a predictive and preventive mode with the following features:

    The FSM process, which includes issue identification, communication, incident creation, scheduling, and assignment can be automated, thereby ensuring zero disruption in machinery operations and no or negligible downtime. This not only increases productivity, but also expands operating profit margins

 

    Most FSM products can also automate incident creation, scheduling, assignment, and invoicing processes. Using IoT, we can predict upcoming issues based on sensors data analysis and auto-creation of incidents based on preset threshold rules

The workflow of a FSM system with IoT integration

Here is an outline of the flow of incidents in a typical IoT-enabled FSM system:

1.   Data from the equipment's sensors is collected and transmitted, using secured and encrypted channels, to a big data storage


2.   Big data management and analytics is used to parse and analyze for refined sensors data


3.   The IoT command console is configured with predefined threshold rules to identify errors and monitor the device's health and performance


4.   Incidents are auto-created in the FSM system whenever errors are detected


5.   Auto-scheduling, routing, and dispatching of field service technicians against the incidents is done based on customer entitlements, location, product, skills required for the job, technician's availability, parts availability, etc. via the FSM system


6.   A field technician performs the job at the customer's site; records the effort, parts used, travel time, and any expenses incurred; and then bills the customer


Workflow of Field Service Management application using IoT.

Six Solution benefits



Wind turbines: A case in point of how IoT integrates with FS systems

Failures in wind turbines interrupt power generation leading to lower productivity and higher system downtime, which result in varying energy production and higher operating costs. To maintain profit margins, higher efficiency and uptime are required.

Near-real-time analytics provides data so that FS teams can react faster and address the issues before they become mission critical, thus reducing impact and avoiding downtime.

The wind turbine's sensors collect real-time data that is analyzed and through which, auto incidents are created, service scheduled, and an agent assigned to fix the issues. Wind turbine sensors are also used to continuously collect operating temperature, rotor acceleration, wind speed and direction, and blade vibrations - all of which can be used to optimize the turbine's performance, increase its productivity, and execute predictive maintenance to ensure reduced downtime.


*** Authors: Haresh Sreenivasa and R.N.Sarath Babu **


Continue reading " Internet of Things (IoT) in field service management (FSM) " »

September 30, 2015

Enterprise DevOps and Oracle

Various organizations dread the traditional development execution cycles because applications take longer time to deploy, become more turbulent, and continually get worse. IT operations are mired in firefighting mode all the time. DevOps is the perfect blend of the software development and IT operations.

Organizational Stakeholders have different needs on their minds. Management demands faster time to market and quicker turnaround, Operations team ought to have ease of operations and flexible environments, Developers and Testers are constantly striving for efficiency and visibility.

DevOps is the most appropriate answer to satisfy these stakeholders with a Continuous Delivery Approach.

Continue reading " Enterprise DevOps and Oracle " »

April 23, 2015

Accounting and Finance Shared Services- Oracle Fusion Capabilities for Record-to-Report and Analytics

 

Accounting and Finance Shared Services have typically been formed in large multinational organizations with the objectives of cost efficiency, standardization and operational effectiveness towards the customers within the organization. Some of the business processes handled by F&A SS are:

-          Procure to Pay

-          Order to Cash

-          Record to Report

-          Financial Planning, Consolidation, Budgeting and Forecasting

-          Treasury and Cash Management

-          Audit and Control

-          Analytics on the financial data

-          Financial closing and Financial statement preparation

Over the periods; instead of merely being a cost center, shared services are emerging as strategic business partners- offering innovation and value addition to various business functions. The extended objectives of the F&A Shared services include extensive analytics and reporting.

My previous blog had stated the Oracle Fusion capability for Procure-to-Pay cycle. It can be accessed here.

The General Accounting- Record to Report Cycle, Consolidation, Reporting and Analytics- requirements of a Multinational, Multi-GAAP organization; using best-of-breed or legacy applications for sub-ledger transactions; can be catered by Oracle Fusion Accounting Hub (FAH) and Fusion General Ledger from Fusion Financials suite. The Financial Reporting Center of FAH involves embedded multi-dimensional Essbase cubes and offers state-of-the-art reporting and analytics which enables multi-dimensional analysis of various transactional and accounting data.

FAH can integrate and utilize the capabilities of number of reporting tools like Oracle BI Publisher, Oracle Hyperion Financial Reporting Studio, Fusion Edition and Oracle Business Transactional Business Intelligence. Drill down up to journal and transaction level is possible from any of the reports generated out of FAH which enables strong audit trail and control.

To record the transactions from Oracle/Non-Oracle applications and convert it into accounting entries, FAH offers a highly configurable rule transformation engine that generates the accounting entries, validates and transforms it into accounting journals. The rules can be configured based on the attributes of the transaction. For example Tax Accounts could be determined based on the country of transaction.

Different rules can be configured for different divisions complying with the local accounting regulations. FAH also captures additional attributes of the transaction for reference and reporting purposes.

FAH_Fin and Acc SS1.JPG

Some of the salient features of Fusion reporting are:

-          Fixed format reports and local statutory reports can be created using Oracle BI Publisher and Financial Reporting Studio/Workspace.

-          Interactive financial reporting and drill down can be achieved either by Oracle BI Publisher, Oracle transactional Business Intelligence, Account Monitor and Account inspector

-          Seeded BI reports are delivered in OTBI

-          Live and interactive reporting with multiple output options like HTML, Excel, PDF; available in Smart View

-          Drill down of the report information upto detailed journal and sub-ledger transaction level using Account Inspector

-          Bursting option available with BI Publisher to split the report and email or print them as per output option selected

-          Functionality to embed charts and graphs in the report

-          Drag and Drop report grid and dimensions

FAH also offers features for Budgeting and Budget Reporting, Consolidation and Inter-company processing. The advantage of FAH for an Account and Finance Shared Service specifically lies in its fitness to be integrated with diverse sub-ledger applications and providing robust accounting platform along with impressive reporting and analytics solution.

Continue reading " Accounting and Finance Shared Services- Oracle Fusion Capabilities for Record-to-Report and Analytics " »

January 14, 2015

Hyperion Data Integration Tools - A Comparison

Continue reading " Hyperion Data Integration Tools - A Comparison " »

January 13, 2015

The new improved Multi-Load functionality in FDMEE

Continue reading " The new improved Multi-Load functionality in FDMEE " »

December 3, 2014

FDMEE - The future of Hyperion Integrations

Part 2

Mappings Redefined

Co Author : Payal Kapoor(payal_kapoor@infosys.com)

In previous part we discussed the recently launched tool FDMEE (Financial Data Quality Management, Enterprise Edition) that was introduced in the EPM release, 11.1.2.3.

In this part we are going to cover some great mapping features introduced in FDMEE that were not available in its predecessor FDM. 

 

 

Continue reading " FDMEE - The future of Hyperion Integrations " »

September 22, 2014

Capabilities of Siebel Mobile Disconnected Mode for Field Service

By Yusuf Kaydawala, CRM Consultant, Manufacturing Unit, Infosys

 

Out of the many exciting features in the latest Siebel Innovation Pack, the most interesting feature for me is the Siebel mobile disconnected mode. Siebel mobile disconnected application allows users to access the CRM application on the browser in their tablets and smartphone even when the user is not connected to the Siebel application. Once the connectivity with the Siebel server is restored, the application provides capability to synchronize the changes back to server. This application is ideal for a travelling sales or field service technician who have access to the network for most of their time.

Disconnected mode functionality should work on all the latest mobile devices available in the market that are HTML 5-compliant. User can engage the disconnected mode functionality on Chrome or Safari browser with at least 50 MB of available storage on the mobile device.

I have mapped various tasks performed by a field technician with the capabilities of Siebel Mobile Disconnected mode:

Field Engineer's Task

Task Details

Siebel Mobile Disconnected Capabilities

Miscellaneous Tasks

Logging in the mobile application

Supported

Logging off in the mobile application

Not supported

Viewing broadcast message

Not supported

Creating bookmark

Not supported

Invoking Menu

Not supported

Back button on UI

Not supported

Using Calendar features

Not supported

Exchanging data with external applications

Not supported

Create Orders

Supported

Preparing for a site visit

Creating Siebel Messages

Supported

Viewing Service request

Supported for synced Service requests

Viewing Account details like Service History, Assets, Entitlements and Contacts

Supported for synced Accounts

Viewing My Activities

Supported

Creating Orders

Supported

Running queries

Supported

Viewing Assets

Supported for synced Assets

Viewing Directions/Maps

Not supported

Checking required parts

Supported

Checking steps and instructions for the job

Supported

Checking Own Inventory position

Supported

Running PDQs to find other Activities

Not supported

Performing service

Changing activity statuses

Supported

Capturing time tracker

Supported

Capturing Part tracker

Supported

Committing Part tracker

Supported

Capturing expenses

Supported

Creating new Service Request

Supported

Creating new Activities

Supported

Adding Attachment to Service Request

Not supported

Viewing All Parts in the application

Supported for synced parts

Closing a service call

Closing Activity

Supported

Invoking Business rules / Validation on Activity closure

Partially Supported. DVM/WFs/Server scripting validations will not work


One of the key considerations for the Disconnected Application is that only 50 MB of offline storage is possible. To overcome the storage limitation, the business admins needs to do a careful analysis of the data and setup data filters to determine the data that needs to be downloaded on the mobile device.

Siebel mobile provides the ability to configure filters on various business entities to only download relevant data for offline usage like:

  • Accounts of only certain country
  • Activities in certain statuses
  • Products which can only be used as spare parts

Field service is one of the toughest jobs in the industry with field engineers servicing complicated equipment, often under unrealistic deadlines and customer expectations. The Siebel Mobile Disconnected application empowers the field engineer by enabling them to perform their daily tasks when they are on the road even without network connectivity.

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 :

 ODI.png

 

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

 

FTI.png

 

 

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.

December 27, 2012

Relevance of Data Governance in Big Data

Enterprises always had more data than their infrastructure and processes could handle, even in past let aside the thought of deriving actionable intelligence for effective decisioning from them. The same problem has now intensified several folds with larger volumes, variety of data from social media, online channels & most critical is the "Urgency" to handle such data.

Continue reading " Relevance of Data Governance in Big Data " »

September 25, 2012

Oracle E-Business suite on Exadata - A Reality

Guest post by
Vinayak Gangadhar Kurdekar, Technology Lead, Infosys

 

Exadata when it was launched by Oracle a couple of years back initially created a sensation in the market as a hardware platform engineered by Oracle in collaboration with HP for hosting large databases. Later as time progressed and technology matured, Exadata became synonymous as a machine that provided extreme performance and scalability for both OLTP and datawarehouse applications.  Both Oracle developer and DBA community had the impression that Exadata has been mainly developed for hosting databases with large amount of data typically seen in a datawarehouse environment and were not aware if oracle's E-Business suite of applications can be hosted on Exadata. The answer is yes; currently Oracle E-business suite release 11i with 11gR2 database is certified with Oracle Exadata V2 machine. Oracle is currently working on the certification of the E-Business suite release 12 on exadata and the same should be available in the near future.

Continue reading " Oracle E-Business suite on Exadata - A Reality " »

September 17, 2012

Oracle Fusion Procurement - Empowering Procurement Function (Part -1)

Guest post by
Sirish Newlay, Consultant, Infosys

 

Purchasing department in an enterprise has taken a center stage in the recent years with more and more enterprises investing hugely to make sure they buy the best, at the best and from the best it becomes immensely important for buyers to make sure they are abreast with latest trend in the procurement world.

Also the race to remain on top has made a great impact in way procurement business functions align with other business functions in an enterprise today and in future for example looking ahead in time with expansion of procurement scope we see importance of rethinking talent management. From financial perspective we see a high dependency on costing methodologies.
In this blog, I provide an overview of "Oracle Fusion Procurement" application and briefly discuss the recent procurement industry trends and in the Part-2, I will provide our point of view regarding how Oracle Fusion Procurement and its capabilities cater to the recent procurement trends.

Continue reading " Oracle Fusion Procurement - Empowering Procurement Function (Part -1) " »

July 3, 2012

CRM to CXM to C3E - Innovation or Evolution?

While CXM (Customer Experience Management) was floated as a concept almost a couple of years ago, it seems quite recent in wake of the fact that CRM (Customer Relationship Management) has been the mainstay of enterprises worldwide for almost 2 decades now. Despite the fact that most of the organizations are yet to latch on to this, and the fact that the ones who have latched on are yet to mature the concept when implemented on ground, the industry is looking for something newer already. The new acronym on the block is C3E (Cross-Channel Customer Experience), and at least for now it seems to satisfy everyone's appetite for innovation.

Continue reading " CRM to CXM to C3E - Innovation or Evolution? " »

November 28, 2011

Exalytics - BI and Big Data Tuned to Perfection

Analytics as we know is all about gaining insights from data to aid effective decision making. However, the vision of delivering fast, interactive, insightful analytics has eluded most of large Enterprises.

Continue reading " Exalytics - BI and Big Data Tuned to Perfection " »

November 18, 2011

Bridging Two Islands: A curious case of Oracle AIA

Guest post by
Vinod Kumar, Consultant, Infosys

 

Telecom sector has been chronically plagued by revenue leakage problems and often seen to be spending the maximum energy and budget on areas around how to not let it happen or in other words having in place an effective Revenue Assurance mechanism. Making it one of the most published area in the industry are the solutions around it yet the clients, be it the newcomers or the old-timers, are often marred by this problem. Not that there are no solution around it but it's the understanding of the solution/product offering and the judicious implementation which makes a solution stand out.

Continue reading " Bridging Two Islands: A curious case of Oracle AIA " »

November 4, 2011

Why Oracle Fusion Procurement? How does it add value?

Guest post by
Suchitha Prabakaran, Consultant, Infosys

 

In the current global business environment, efficient Procurement techniques, methodologies and processes play a vital role in providing a competitive edge- both operationally and financially for any organization irrespective of the size, nature of business, products dealt with, area of operations etc. Corporates now have realized the importance of streamlining and strategizing procurement processes as it makes a huge difference to the revenue and profitability of the organization.

Continue reading " Why Oracle Fusion Procurement? How does it add value? " »

October 4, 2011

Leveraging Fusion Business Process Model Methodology in Project Portfolio Management (PPM)

Guest post by
Sandeep Suresh Deshpande, Principal Consultant, Infosys

 

In today's world, business is exposed to a constantly changing environment where organizations face the most challenging situations -

  • Information silos across the value chain
  • Parallel processing amongst distributed systems
  • Mismatched products to support complex end-to-end business processes
  • Complex and long-running projects
  • Real-time project consolidation and budgeting

Oracle has done an extensive internal and external research, took the best practices from Oracle E-Business Suite, Oracle PeopleSoft, Oracle JD Edwards, Oracle Siebel and all other acquisitions to come up with a number of industry business process areas with multiple levels of decomposition. These world class business processes can be leveraged to deliver in the complex and challenging environment.

Continue reading " Leveraging Fusion Business Process Model Methodology in Project Portfolio Management (PPM) " »

September 27, 2011

Effective Sales Planning with Oracle Fusion Sales Planning Solution

Guest post by
Sushal Subashchandra Shetty, Consultant, Infosys

 

Are you not able to define effective territories for your sales organization?

Is your sales team swimming in the sea without targets?

Is your sales team cherry picking on prospects and you are not aware how to tackle it?

Are you losing track of your sales team's performance?

If answer to all/one of the above questions is yes, then my cent that you ought to read this further. The top problems which one of the large manufacturing company was facing were loss of productivity due to redundant and manual process, lack of consistent and efficient reporting, inaccurate commissioning.

If you are also facing the same problems as above then sales planning solution based on Oracle Fusion Applications is the one-stop solution for you.

Continue reading " Effective Sales Planning with Oracle Fusion Sales Planning Solution " »

September 7, 2011

BACKUP and RECOVERY in EXADATA

Guest post by
Vinayak Gangadhar Kurdekar, Technology Lead, Infosys

 

Businesses today need to increasingly leverage a unified platform to host all their database and applications at one place. To meet this challenge, Oracle has designed the Exadata server technology that bundles database and applications together to provide high performance, high availability, scalability and throughput. Mere implementation of the exadata server and its components is not enough. Disasters can strike at anytime. To ensure survivability and safeguard against any major disasters, effective backup and recovery solution is a must. The backup and recovery strategy needs to be not only precise but proven in all aspects. To achieve this Oracle has come out with multiple backup and recovery solutions designed in-house and third party.

  1. Disk based backup and recovery.
  2. Tape based backup and recovery.
  3. Backup and recovery using dataguard.

Continue reading " BACKUP and RECOVERY in EXADATA " »

July 19, 2011

Centralized Procurement with Oracle Fusion

Introduction

With the business expanding across globes and with manufacturing organizations resorting to sub-contracting, there is a need for organizations to look at procurement beyond their current markets.  This introduces the need for a centralized procurement function for better purchasing efficiency, better control over organization spend, and central and simpler management of contracts with suppliers.  Oracle Fusion Procurement introduces new and better features that aid organizations to better manage their procurement functions.  The following are the advantages of a centralized procurement function:

  • Better control over organization spend
  • Consolidated purchasing across business units
  • Leverage volume discounts by consolidated demand
  • Better supplier relationship management
  • Single point of contact in buying organization for supplier
  • Centralized contracts - easier implementation and better management
  • Consolidated measurement of supplier performance
  • Reduced overheads

Continue reading " Centralized Procurement with Oracle Fusion " »

May 11, 2011

Oracle Exadata - A platform for consolidation (Part-1)

Guest post by
Umesh Tanna, Senior Technology Architect, Oracle Practice, Enterprise Solutions, Infosys Technologies Ltd.

 

Consolidation is one of the many key reasons for deploying and using Exadata. Oracle Exadata is an appliance - hardware and software bundled and engineered to provide maximum performance. It is a database machine that is purpose built and integrated. True, that there are high end systems that are best suited to be replaced by Exadata platform considering the growth and performance need of those system. However, by design, Exadata offers high end configuration and specification which not all types of Oracle database application that today runs in IT department need.  Hence, solid business case can be built for those systems if, some type of consolidation solution is considered which can simplify, increase availability and performance and ultimately reduce total cost of ownership.

Continue reading " Oracle Exadata - A platform for consolidation (Part-1) " »

March 15, 2011

How to measure ROI for SOA projects? A Tollway Approach

Guest post by
Prasad Jayakumar, Technical Lead, Oracle Practice, Enterprise Solutions, Infosys Technologies Ltd.

 

Early morning I was hitting I-94W to meet my client in Milwaukee.  I wish I had my I-PASS; toll varied from 25 cents to little more than a dollar.  I was wondering "Why not the government builds the infrastructure out of tax collected and let us free?"  Immediately I realized my ignorance.  My discussion topic with client was "How to measure ROI for SOA Projects?"  It was a meeting to see if we can present benefit of SOA in a tangible way to business.  I was wondering if the toll way could answer the question.

Continue reading " How to measure ROI for SOA projects? A Tollway Approach " »

March 10, 2011

Hybrid Cloud and Weblogic WAN Clustering

I was reading up on clouds and their drawbacks and one issue that kept repeating was customers loosing control of their applications and data to the cloud service providers. One of the key themes of Cloud computing is to scale the computing infrastructure on the go as well as pay for only what you use. So i was wondering if it is possible for customers to use the cloud only for scaling their existing computing infrastructure without moving their entire application to the cloud. As i read more on this problem, I stumbled on a new concept (new for me :-)) called the "Hybrid cloud".

Continue reading " Hybrid Cloud and Weblogic WAN Clustering " »

February 22, 2011

Oracle SOA 11g - One Less, One More

Guest post by
Prasad Jayakumar, Technical Lead, Oracle Practice, Enterprise Solutions, Infosys Technologies Ltd

 

One Less, One More™ -  "one less negative thought or action, and one more positive thought or action, and soon our lives will be less stressful, and if practiced as a community [...]  would move in the direction of our collective goals, dreams and desires" by Robbie Vorhaus,  Communications, crisis and reputation advisor.

Oracle acquired many best-of-breed products on SOA landscape may be for architecture excellence or for concept/idea or for market share or to fill the void or based on some other strategy which only acquisition experts know.  But, what's interesting is how Oracle managed to unify all the acquired products and paved a path to Success as a corporate and for Oracle SOA practitioners.

Continue reading " Oracle SOA 11g - One Less, One More " »

February 18, 2011

Do we need SOA Governance ?

Guest post by
Prasad Jayakumar, Technical Lead, Oracle Practice, Enterprise Solutions, Infosys Technologies Ltd.

 

In my recent client discussion the ever pondering question popped up, "Do we need SOA Governance?" Definite YES, I told without second thought. If they would have asked me "Do we need SOA?" the answer would have been based on whether business is ok to WALK or wants to DRIVE.  Since the question was about governance, it is as simple as saying "If you want to drive safely, better hold a valid driving license."

Continue reading " Do we need SOA Governance ? " »

January 31, 2011

Starting a SOA Project? Don't forget the Service Registry!!

In the SOA world, there are several pieces of the architecture which are considered de-facto for an SOA. e.g. Service Bus, BPEL process Manager, Business Activity Monitoring etc. But a key component which is only added as an after-thought in most implementations is the Service Registry.

Continue reading " Starting a SOA Project? Don't forget the Service Registry!! " »

September 21, 2010

Is Fusion CRM game for it?

The success rates of CRM implementation have been reported low traditionally. Various studies attribute the reason to various factors like user adoptability, system adaptability, high TCO etc. Should I take the liberty of saying that marketing and sales users (next to warehouse users) would be ranked first in discarding a system which is not easy to use and fit the requirements. So, Is Fusion ready for sales and marketing users? Let us have a look at the features which marketing and sales users would go gala about it.

Continue reading " Is Fusion CRM game for it? " »

September 16, 2010

Oracle's promising BI Roadmap - Taking the joy ride together (Part 1) !!

The relevance of information is defined by the accuracy, timeliness and efficiency with which it can be leveraged. 'Change' is a constantly happening process that reflects the present and defines the future, overcoming the flaws of the past. A company's legacy applications and technology might be outdated and needs to be modernized to perform and deal with competition.

Continue reading " Oracle's promising BI Roadmap - Taking the joy ride together (Part 1) !! " »

September 14, 2010

How can you manage user expectations while transitioning from existing BI platforms and applications to Oracle BI Fusion Edition?

Managing user expectations is increasingly becoming the key concern of organizations while implementing or upgrading BI software applications and platforms. Goading as well as guiding the users to embrace the change is extremely important for successful implementation of Oracle's BI Fusion platform and its pervasive use within the company. So how can a company manage user expectations and upgrade to Fusion keeping both users and management in sync. Is this really possible?

Continue reading " How can you manage user expectations while transitioning from existing BI platforms and applications to Oracle BI Fusion Edition? " »

May 28, 2010

Can material bins themselves serve as kanban signals?

Kanban has come to be established as an effective means of material movement in manufacturing plants. Kanbans not only relpenish materials, they also trigger production activities at upstream processes. As such, kanbans have become an industry- wide accepted means of signalling material movement and production. Along with kanbans, kanban cards have gained widespread acceptance. These cards generally store useful information such as item number, the replenishment location and quantity, the replenishing process etc.. These cards are generally attached to the bins that store the materials.


Continue reading " Can material bins themselves serve as kanban signals? " »

May 17, 2010

Use RBAC to secure your eBiz suite

To realize the early benefits of an ERP implementation and to comply with all the legal requirements, it is important that the applications and data are properly secured by exploring all the available security option within Oracle Applications

Oracle ebiz suite has various security features like:
a) Application Security using Access Control, Identity Management , Password Management etc
b) Physical Data Security using oracle database security , back ups etc
c) Security for imodules using firewalls, proxies etc


As part of Application security, User Management or RBAC (Role Based Access Control) was introduced by Oracle few years back, the major features of User management are:

- In the User Management model, a role would point to a set of functions and separately point to a navigation menu that should be used to access those functions.
- This navigation menu may contain a superset of functions but only those functions which have been granted to the user (via the roles) would be enabled (other functions would be filtered out)
- The navigation menu can be organized in the most intuitive way for finding functions in the navigator, while the roles can be defined purely based on the security / organization requirements

What is the difference with the traditional Responsibility approach?

Under User Management / RBAC, rather than presenting the user with a list of responsibilities which may have the same menu or slightly altered versions of the same menu presented multiple times, one would present the user with a list of product areas, and all the functions which they can access in that product area regardless of the role through which the function was given.

RBAC / User Management still has long way to go with challenges like an organization should have a clear RACI(Responsibility-Accountability-Consultation-Information) matrix defined with proper roles but eventually it would replace the Responsibility based security model of oracle. 
 

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter