Infosys-Oracle Blog

Oracle Implementation projects at large organizations typically tend to span over a long period of time and quite often into years. Wide scope of requirements, complexity of design, elaborate testing efforts and smooth cutover planning, all mandate substantial investment of time. This may lead to substantial time getting elapsed between start of the project and the go-live of implementation.

During the implementation, the project teams start with a given version of oracle code and design the solution based on that version. In large implementations, substantial number customizations are built for the customer specific requirements. During project implementation duration itself, oracle may come out with new Rollup patches for the modules that are being implemented. As applying the Rollup patches may significantly impact the already built customizations and since they require significant analysis and regression testing, these new Rollup patches are not applied to Oracle instance used during the implementation, unless it is a must to resolve a project specific issue, Thus, more often than not, the oracle version that gets implemented at go live is the same that was started with at the time of design.

Further, after the go live, the projects teams and client business teams are focused on making the production environment stable. The thrust is on making sure that all the built components and solution work as has been expected as per the designed solution. So it takes some more time to make sure the production environment is stable and running smoothly and during this time the new Rollup patches are not taken up for application. Further, successful implementations are very close in being able to provide to the customers almost all the functionalities that they sought from the implementation. With requirements being met, the client organization’s IT and support team’s next goal is to ensure continuity of systems to the business and operations. Due to this, the latest Rollup patches do not get applied to the production environments even further down the line.

Also, since the oracle implementation are large initiatives for the client organizations, they tend to be sticky in the sense that customers tend to harness the implemented oracle system for a good number of years before planning for any major change unless it is required by a new initiative.  And, in some situations, the cost of large implementations leads to client management ramping down teams and focus on maintaining the system rather than bring any further changes that may impact the existing system. This tendency further causes delays in taking up the Rollup patches for application.

Thus multiple years would have passed on since the start of the Oracle implementation without the newer Rollup patches being applied to the system. As a result of all this, the oracle version in production would have become woefully out of sync with the latest versions from Oracle. In case of some rapidly evolving oracle modules (e.g. WMS), this gap becomes even more pronounced.

This can be a very drastic situation for production environments that are at the core of running large scale business operations. What further increases the gravity of the situation is the fact that this criticality may not be borne out to system managers until the production system runs into a major issue with Oracle standard code. When a major production issue occurs and it needs to be resolved in the oracle code, then to be able to fix the issue Oracle support expects the client systems to be close to the latest system versions vis-à-vis the program files pertaining to the issue. Often times the issue may not be replicable within oracle support instances due to version differences. Then oracle development and support further necessitate that the production system version be the latest. Moreover, it may not be possible for oracle to fix the issue in isolation as changing just few of the files may have impacts that are widespread in the system.

So, it might lead to a situation that there is not an existing oracle patch to resolve the issue and Oracle is not able to provide a one off customer specific patch. Even if it is possible, Oracle may take some time in building a one off patch and testing it. If the issue is so critical that it is stopping the operations, this time lag may lead to huge losses to business. This can cause a scenario wherein the latest rollup patch needs to be applied urgently. As this would require significant regression testing, it will significantly delay the resolution time of the issue. Also, applying the rollups within a short timeframe may not leave enough time for proper planning and rigorous testing of the patch.

Therefore, it is highly imperative for system managers to ensure that the Oracle versions in production are timely updated with latest rollup patches. The application of rollup patches should be taken up in earnest and due importance should be paid to this activity. This will help in planning properly for the application of these patches and performing rigorous end to end testing of the same. Further, this will ensure that the system is capable of handling any eventuality if it arises. The resolution turn around time for any critical issue will be short and business and operations will be affected to a lesser extent in case of issues.

Also, with the system being on the latest versions, any new initiatives and new solution that need to be brought in to the oracle system can be taken up quickly as and when they come up and implementing these solutions will not require an extra effort of bringing the systems in sync with the latest version. Overall, it makes a lot of business sense to continually asses and evaluate the new Rollup patches provided by oracle for application in the production systems and ensure the sustainability of the system.

Posted by Pragyesh Dwivedi at 02:08 AM | Permalink | Comments (0) | TrackBacks (0)

Taiichi Ohno, the father of Toyota Production System says, “Transportation is a waste and has to be reduced”. Transportation within the organization is considered a waste which does not add any value. What many overlook is the fact that transportation does not only imply inside the manufacturing facility but also outside it. The outside transportation can, not only help add value but also act as a differentiator. With many companies implementing Lean Manufacturing concepts, it is of paramount importance that the Logistic strategies are also aligned to it. Let us analyze the different wastes in transportation and how they can be reduced using Oracle Transportation Management (OTM), a Transportation Management System (TMS) by Oracle.

With Lean Manufacturing implementation the supplier and the manufacturer collaborate to tune themselves to listen to the customer demand and produce only what is required. They continuously aim to reduce inventory and create a pull system. This requires the transportation to have frequent truck runs with lesser quantity. Most organizations prefer going for Milk Runs with the right size equipments.

Customers also prefer smaller and frequent orders and this reduces the opportunity for full truckloads and direct shipments. In this case organizations have to look at other modes to transfer the goods. Mostly LTL transport is looked at. In many cases the orders are such that they are not fit for LTLs (more weight or volume) but do not fully utilize the full truckload capacity either. In such cases the planners forget the fact that multi-stop shipments can fully utilize the trucks.

One of the key factors for instantaneous response is proper communication between the carrier and the manufacturer. Visibility of the shipments for various reasons like warehouse planning, customer queries etc. is essential. The delivery times for all the carriers needs monitoring so that the efficient carriers can be identified.

To implement lean transportation, organizations are looking at their transport network very closely. Every route is being rationalized so that better vehicle utilization can be achieved. This exercise needs to be done continuously for reduction in the waste.

For some of the above OTM can be very useful, become partners for waste reduction and make the system lean.

Ø  The schedule for the Milk Run is entered in OTM and the shipments are formed accordingly, helping the manufacturer have several runs for a pre-defined route.

Ø  The planning engine of OTM takes care of the customer order planning. It helps in giving you the right mode with the right equipment to deliver the shipment to the customers at the right time.

Ø  Planning engine takes care whether to build a Multi-Stop, LTL, Direct or a Multi-Leg based on all the constraints on the order.

Ø  OTMs powerful Supply Chain Event Management tracks the shipment which helps in planning at the warehouse and answering customer queries quickly. It gives immediate information about the current status of the shipment. The shipments are routed to the correct Dock so that the time wastage on unloading is reduced.

Ø  Cooperative Routing feature of OTM identifies repetitive routes and helps in determining the right number of vehicles required for a particular route. This supplements the Transport Network rationalization.

Ø  Fusion Transportation Intelligence module provides a means to monitor Key Performance Indexes like number of on-time deliveries, number of late deliveries, total load pre lane etc. These help in making strategic decisions and revise the carrier collaboration programs to make the supply chain more effective and leaner.

Reducing wastes in transportation is one of the key factors for making the supply chain lean and OTM can act as a strategic partner to achieve it.

Acknowledgement: Anirban Roy

Posted by Nilabja Dey at 04:30 AM | Permalink | Comments (0) | TrackBacks (0)

From my past experiences, I have observed that we often build a data warehouse as a way of integrating multiple sources of data to gain effective business intelligence. This is both time and resource consuming and also can potentially disrupt the IT roadmap of an organization if not handled with utmost maturity.

In this rapidly changing world of technology, new paradigms have evolved which have the possibility of simplifying the process of aggregation of multiple sources. One such technology which I found very exciting is Data Federation technology which is also known as Information-as-a-service, Data Virtualization or EII(Enterprise Information Integration).

Heart of this technology is a “virtual database” or a Federated Database as was defined by McLeod and Heimbigner long back in 1985. Simply speaking, a virtual database is storage of data definitions and not the data itself. The virtual database will have information about the location of the data.When a single call is made to a virtual database, the technology ensures multiple calls to underlying databases and is also responsible for meaningfully aggregating the returned result sets.

Primary benefit of the above approach is that data need not be moved from the source systems for analysis.It also saves the cost of building and maintaining a permanent warehouse.  Since data is not being moved, this enables quick and real time data delivery. 

The biggest challenge that needs to be handled for such a system to deliver what it promises is the heterogeneity of the DBMS giving rise to naming, schema, domain, model conflicts. These can be  typically handled by designing multiple stacked-up schemas which accurately translates
the data model,as visible to the user, to actual data models of the component DBMS.  

Areas where this technology will have ready acceptance are the organization’s divisions (like fraud detection units) which heavily rely on real time intelligence from disparate systems to drive business. Data Architects may also find this approach very efficient for maintaining master dimensions which are typically time consuming at an enterprise level.

Vendors like Oracle, SAS, Informatica etc have already lined up extremely comprehensive solutions in the market. Now it’s on the Consultant and Architect community to go out there and propose solutions which are truly ‘out of the box’!  

Last but not the least, what is the experts’ take on this?
Talking to some of the data warehousing connoisseurs, I felt people are divided on the appropriateness of this approach of replacing a data warehouse with federated architecture. Weighing in the pros and cons, I can safely conclude that at this point of industry maturity, this approach definitely merits an augmentation to a traditional data warehouse but we need to wait and watch how best it evolves to become the mainstream.

Posted by Dwaipayan Das at 11:20 AM | Permalink | Comments (2) | TrackBacks (0)

The recently released movie 3 Idiots, based on 3 college graduates experimenting and challenging a deeply rooted, established education system, has turned out to be quite a huge hit in India. Taking a cue from the 3 Idiots, I cannot help but ruminate on the impact that the 3 Critical Changes will have on how the India Inc does its business? Will India Inc emerge a winner or a loser? There is no doubt that all three financial changes i.e. IFRS, GST, Direct Tax Code, which are supposed to be effective from 2011, will have some effects. Even if implemented in silos, they’ll change the way business is done and the financial statements are prepared. As an example, IFRS is not just an accounting change but it will also have an impact on overall policy changes that effect each and every stakeholder of the organization, be it an employee or a shareholder

 

Continue reading "India Incs 3 Critical Financial Changes in 2011- will they be winner like 3 idiots" »

Posted by Giriraj Somani at 01:53 PM | Permalink | Comments (0) | TrackBacks (0)

Russia, post USSR days, though small has its own share of uniqueness. It has 83 states/provinces and 11 Time Zones. Given the fact that there are unique legal requirements, any ERP implementation becomes a challenge.

Continue reading "Playing the Russian Roulette" »

Posted by Sandeep Chatterjee at 04:23 AM | Permalink | Comments (0) | TrackBacks (0)

a)    Choose a costly Partner than a cost effective vendor
    One must thoroughly assess all of options in evaluating potential external implementation companies. Software companies aren't always the best at implementing their own software, and some are more expensive than others. An organization should look at a vendor who can partner with them in their ERP initiatives not only for software implementation but also in managing the non-technical aspects of the project, such as organizational change management, training, and ERP benefits realization.

 

b)    Map the software to Business requirements don’t just buy it
    If an organization has decided that ERP is the route it needs to take, it is important to begin by looking at the desired software to implement. In most of the cases, package selection is influenced by top executives who have previously worked on particular package.
    Instead, executives should define and document key business requirements irrespective of the package that may be selected. This includes not only nice-to-haves, but also requirements that can be "proposal-breakers" if the software is unable to accommodate. The package selected should focus on achieving measurable business value for the organization, and one should choose the software that best enables to do this

 

c)    Focus less on System training and more on Change management / Executive sponsorship
    What is your Business Case and ROI? This is where many companies fall apart. Answering and documenting this question is important to get Executive sponsorship and ownership for an ERP program.
    The lack of a change management approach as part of the program can prevent a program from succeeding. Resistance to change is human nature and is quite often caused by (1) A failure to convince a case for change, (2) Lack of involvement by those responsible for working with changed processes (3) Inadequate / Improper communication (4) Lack of visible top management support and commitment, and (5) Arrogance.  A lack of buy-in often results from not getting end-users involved in the project from the very start, thereby negating their ownership of the new system and processes.
    ERP-related training is also crucial as most employees must learn new software integration and business processes which affect the operation of the entire organization. Appropriate focus should also be given on this part of the ERP implementation else it leads to much pain and suffering downstream.

 

d)   Don’t just Save Dollars sometimes?
    One of the key causes of ERP implementation failure is unnecessary cost cutting. In an effort to avoid multi phased roll out costs, repetitive conversion costs, some companies take a very risky route and go live “Big-bang” at multi-plant sites simultaneously, subjecting all plants or some plants to a total shutdown, should there be a failure
    Some projects have compressed schedules in order to save on expenses, only to eventually overrun both schedule and budget.
    Sometimes the question “What is my Value for Money / ROI?” should take a back seat as some projects should be treated as an upgrade to the company infrastructure that is necessary to maintain or gain a strategic and competitive advantage.
e)    Yes we can but are we prepared for Failure?
    Best organizations would prepare themselves for unforeseen contingencies, similarly all implementation projects should have a fail over plan. No matter how well-run a project is, one should be prepared for failure.
    If the project failed or if the software was not implemented correctly, what will be the backup plan? Would users be able to access legacy systems? Would certain processes be performed manually until the system is brought up? Catastrophic failures may not be common, but they do happen on occasions, so companies should be prepared for the "what-ifs."

 

Posted by Sachin Chitlange at 01:45 PM | Permalink | Comments (0) | TrackBacks (0)

 

The Copenhagen Climate Summit is grabbing the newspaper headlines all over the world. This led me to introspect about how Oracle Transportation Management (OTM), a Transportation Management System (TMS) by Oracle, can help in making the world a better place to live.

Several researchers have revealed the fact that 15% of the global emissions and 31% of the Ozone release can be attributed to transportation. This suggests that we have a large gap to fill in. Being a Transportation and OTM consultant my first thought was how OTM helps to fill up this gap.

Oracle itself builds products which are “ISO 14001 Environment Management Standard” compliant. It helps organizations fulfill its environmental policies. This led me to believe that the same has been built into OTM as well. The benefits for the environment are plenty. Before we get into the environmental benefits let’s try to figure out the benefits every company is looking for after an OTM implementation. Then we’ll see how the 2 are connected. Organizational benefits after an OTM implementation:

·         Route Optimization without any compromise on delivery dates/time.

·         Explore multi-modal and continuous move opportunities while planning

·         Explore consolidation opportunities while planning

·         Automated shipment execution (includes tendering and visibility) and freight settlement process

·         Automate pool and cross dock planning

·         Reduction in Transportation Costs

What many ignore is the fact that most of the above benefits inherently helps reduce the company’s carbon footprint and makes it greener. Let’s try to break it up.

1.       Route Optimization without any compromise on delivery dates/time –

a.        Reduction in truck miles

2.       Explore multi-modal and continuous move opportunities while planning –

a.       Reduction in truck miles

b.      Reduction in number of trucks

3.       Explore consolidation opportunities while planning –

a.       Reduction in number of trucks

4.       Automated shipment execution (includes tendering and visibility) and freight settlement process –

a.       Paperless environment

The points above make it very apparent that OTM reduces the fuel consumption and in turn reduces the CO₂ emissions. EDI integration for Shipment Execution (204, 990 & 214) and Freight settlement (210, 110) makes the entire process paperless and also automates it. Apart from the above, “Cooperative Routing” helps corporations make strategic decisions on which route to optimize and in turn optimize the fleet utilization.

Want to know how much your corporation emits after OTM implementation? Very soon OTM’s Transportation Intelligence module, FTI, will help in providing a dashboard for knowing the CO_2, NO_X and Fuel Consumption for each transport modes run by the corporation’s transportation department.

OTM TMS is a very effective way to reduce the unnecessary emissions of a corporation due to transportation. OTM combines the environment protection and cost reduction in such a symbiotic way that it not only helps the organizations but society at large.

Courtesy: Anirban Roy

Posted by Nilabja Dey at 09:09 AM | Permalink | Comments (1) | TrackBacks (0)

Trade locally had become a very old practice for any economy across the world; global trade is the new axiom any enterprise is looking at for global business to survive. In this context Transportation of goods in the Supply value chain has a prominent role in any Enterprise Global Trade Management. As the word goes (Global); the goods has to cross across borders moving from one location to another and in the process has to stop and go at the point of Customs.
Oracle Transportation Management (familiarly known as OTM) has built its architecture to address the latest Global Trade Management solutions in its Application. The Application is very robust that it has in-built functions of Denied Party Screening, Embargoed Country Screen Service, Import/Export Ban Country Service. Apart from the above functions various customization of the application facilitates OTM(Oracle Transportation Management) to serve as an information supplier to AMS (Automated Manifest System) of US Customs and Border Protection (AMS is a multi-modular cargo inventory control and release notification system).
The above functionality can be achieved:
Ø  Outbound integration of the service provider’s OTM Application to the US Customs and Border Protection system
Ø  Inbound integration of the US Customs and Border Protection system to the service provider’s  OTM Application

Out-bound Integration:

Service Provider’s (Shipping Liner, NVOCC) OTM application will create the vessel – cargo manifest by considering all the details required by the US Customs and Border Protection system and have them validated in the BPEL middleware. BPEL transforms the required AMS data elements (Vessel/Voyage ID, Ports of Source and Destination, Cargo Description, SCAC, B/L, Shipper/Consignee etc.) from the Shipment information into the respective file format which customs would accept. The data file will be sent to AMS system from OTM through the external system setup.

In-bound Integration:

US Customs and Border Protection system will process the Carrier’s request and allows faster identification and release of low risk shipments if the information is accurate as per the Custom rules and regulations. If the rules were not matching as per the customs regulations the service providers receive the corresponding status or alerts which helps them to modify the said information in the Shipment manifest.

Conclusion:

OTM – AMS integration reduces reliance on paper documents and speeds the processing of manifest and waybill data. As a result, cargo remains on the dock for less time, participants realize faster tracking, and Customs provides better service to the importing community.
 

Courtesy: satya_vabilisetty

Posted by Nilabja Dey at 05:31 AM | Permalink | Comments (0) | TrackBacks (0)