Why many ERP implementations fall short of expectations and how to prevent failure?

Normally if you understand why ERP implementations fail then most probably you could address the issues accordingly, and I think there are more solutions for each of the below reasons for failure:
– not understanding what an ERP is about – functionality and intrinsic requirements
– not evaluating/assessing ERP’s functionality beforehand
– not getting the accept/involvement of all stakeholders + politics
– not addressing the requirements beforehand, especially in the area of processes
– not evolving/improving your processes
– not addressing the data cleaning/conversion adequately
– not integrating the ERP with the other solutions existing in place
– not having in place a (Master) Data Management vision/policy that addresses especially data quality and data ownership
– not involving the (key) users early in the project
– not training and motivating adequately the users
– lack of a reporting framework, set of reports (reporting tools) that enables users to make most of the ERP
– lack of communication between business and IT professionals
– relying too much on external resources, especially in the PM area
– the migration of workforce inside the organization or outside (e.g. consultants coming and leaving)
– inadequate PM, lack of leadership
– the lack of a friendly User Interface (referring to the ERP system itself)
– inadequate post-Go Live support from the ERP vendor and business itself
– the lack of an ERP to evolve with the business
– too many defects in the live system (results often from inadequate testing but also vendor related issues)
– too many changes on the last 100m of the project
– organization’s culture
– attempting to do too much in lesser time than needed/allocating more time than needed.

No matter how many methodologies people like to philosophy with, between theory and practice it’s a long way, in addition not two projects are the same given the various contexts, constraints and requirements. A methodology that worked in one context might not work in another, people who performed well in one project might not perform well in another, and so on… If somebody’s coming with a 100% guarantee that the ERP implementation will succeed no matter what, I would regard its optimism with reserves, and those who worked in several implementations know what I’m talking about.

There are so many articles already on this topic, everybody searching for the Holy Grail of ERP implementations…

Oracle – Need help – One 2 One Support / help

  • Need help to update your resume’ / CV appropriately to reflect your skills
  • Looking to get help to identify your technical strength to face technical interviews.
  • Need someone to tell what you read/ study more on topic to get confident and cover it appropriately to deliver answers properly.
  • Want to know which certification exam you should go and what and how it will be beneficial for you.
  • Stuck in any problem technically and don’t know what to do NEXT

I am sure either you or your friends/ collegues get stuck in such things, Here you can reach out and ask your question /query or if needed then let’s talk out to resolve things.

Do write me at shivmohan(dot)purohit@gmail.com or on Contact link on top right side.

thanks – Shiv

Oracle Apps – Any technical or functional help

We are planning and looking forward to start new initiative.

  • Advisory on Technical topics
  • Advisory / help on functional topics
  • Any help require on project or implementation or developement tasks

As these all are FREE so the steps that i would prefer to follow as

1. Sent a mail with stating your need/ problem/ query etc

2. If answering using Email possible then will reply via email

3. If it need to discuss and interaction require then we can decide a time to have either audio chat or phone discussion.

Reach me at email – shivmohan(dot)purohit(at)gmail.com


Click on “Contact” on top right side and put ur meesage.

thanks – Shiv

Min-Max Planning and Move Orders

Min-Max planning is one of the three major replenishment methods in Oracle Inventory. The others are – Reorder Point Planning and Kanban Replenishment. Min-Max planning can be executed either at the inventory organization level or at the subinventory level.
Here is the full document and demo for min max planning



Oracle Project Intercompany Invoices to Payables

Friends, here is Oracle Project billing insight on its integration with AR. How to Interface Oracle Project Intercompany Invoices to Payables


To explain how intercompany invoices are interfaced to Payables


When the provider operating unit runs the Tieback Invoices from Receivables process, the intercompany invoices are automatically copied into the interface table of the receiver operating unit’s Payables. Intercompany invoices interfaced to Payables are identified with the following attributes:


Source. All intercompany invoices have a source of Projects Intercompany Invoices.

• Supplier. The supplier is identified by the provider operating unit’s internal billing implementation options.

• Supplier Site. The supplier site is based on how the provider operating unit defines the receiver controls for the receiver operating unit.

• Invoice Amount. The Payables invoice amount is the amount of the related Receivables invoice, including taxes. The interface process populates the project–related attributes for intercompany Payables invoice distributions, as indicated below:

• Project Number. The number of the cross charged project indicated in the invoice line.

Task Number. The number of the task specified in the Intercompany Tax Receiving Task field on the cross charged project.

• Expenditure Item Date. The invoice date of the intercompany Receivables invoice.

• Expenditure Type. The expenditure type specified by the receiver operating unit in the Receiver Controls tab.

Expenditure Organization. The expenditure organization specified by the receiver operating unit in the Receiver Controls tab.


In addition, the interface process matches the tax code from each invoice line of the Receivables invoice to the appropriate Oracle Payables tax code. This process indicates that the Payables invoice distributions do not include tax amounts, so that the Payables Open Interface process creates the invoice distributions for the entire invoice by grouping the tax lines based on the following attributes:


Tax code

Project information (project, task, expenditure item date, expenditure type, expenditure organization)

thanks – shivmohan purohit

DataLoad with Oracle E-business Suites (Oracle Applications/ Financials)

DataLoad with Oracle E-business Suites (Oracle Applications/ Financials)






DataLoad is a tool for manipulating the data and commands in Oracle E-Business and other software by sending pre-defined data and commands to the target program. These help pages are the primary source of information about DataLoad and how to use it. Follow one of the menu links on the left to the section which best fits your question or use the table of contents to find the information you are looking for. Implementing or supporting any application often requires significant effort to configure and load master and transaction data, for example from legacy systems, an expensive and time-consuming activity.

DataLoad reduces the time and costs associated with data migration. Its easy-to-use interface means that it can be used by non-technical employees, giving end-users an active role in the implementation and support of any system.

·   Non-technical users can easily configure and load data into any system

·   Recommended by Oracle, DataLoad contains specific additional features to load large volumes of data in any implementation of Oracle Applications.

·   DataLoad is sponsored by leading UK systems integrator Edenbrook, which has committed to support and improve the tool.

·   DataLoad is available in Classic and Professional editions, catering to all types of application implementation from the simple to the vastly complex.

·   DataLoad Classic is available to download free of charge.




Q. Can I use DataLoad with Oracle E-Business 11i, E-Business R12, etc?

A. DataLoad works with any Windows based applications and contains enhancements for use with Oracle E-Business. DataLoad has been tested with all current versions of E-Business that are supported by Oracle and has been proved to work correctly. As new versions of E-Business are released DataLoad is tested with these releases to ensure continued support. Full R12 compatibility was added in DataLoad V4.3.9.0.


Oracle – Technical FAQ – Part 4

 Q18.) What are the OOPS concepts in Oracle?

A18.) Oracle does implement the OOPS concepts. The best example is the Property Classes. We can categorise the properties by setting the visual attributes and then attach the property classes for the objects. OOPS supports the concepts of objects and classes and we can consider the property classes as classes and the items as objects.


Q19) What is the difference between candidate key, unique key and primary key?

A19) Candidate keys are the columns in the table that could be primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.


Q20) What is concurrency?

A20) Concurrency is allowing simultaneous access of same data by different users. Locks useful for accessing the database are

a) Exclusive — The exclusive lock is useful for locking the row when an insert , update or delete is being done. This lock should not be applied when we do only select from the row.

b) Share lock — We can do the table as Share_Lock as many share_locks can be put on the same resource.


Q21) What are the Previleges and Grants?

A21) Privileges are the right to execute a particular type of SQL statements. The grant has to be given by the owner to object.


Q22) What are Table Space, Data files, parameter file, control files?

A22) Table space: The table space is useful for storing the data in the database. When a database is created two table spaces are created.

a) System Table space : This data file stores all the tables related to the system and dba tables.

b) User Table Space: This data file stores all the user related tables.

We should have separate table spaces for storing the tables and indexes so that the access is fast.

Data files : Every oracle Data base has one or more physical data files. They store the data for the database. Every datafile is associated with only one database. Once the data file is created the size can not change. To increase the size of the database to store more data we have to add data file.

Parameter file:Parameter file is needed to start an instance. A parameter file contains the list of instance configuration parameters e.g. db_block_buffers = 500

db_name = ORA7

db_domain = u.s.acme lang

Control files : Control files record the physical structure of the data files and redo log files . They contain the DB name, name and locations of dbs , data files, redo log files and time stamp.


Q23) What is physical storage of the Data?

A23) The finest level of granularity of the data base are the blocks.

Extent : Extent is the number of specific number of contigious data blocks.

Segments : Set of Extents allocated for Extents. There are three types of segments

a) Data Segment : Non clustered tables has data segment data of every table is stored in cluster data segment.

b) Index Segment : Each index has index segment that stores data.

c) Rollback Segment : Temporarily store ‘undo’ information.


Q24) What is Normalisation ? Explain 1NF, 2NF, 3NF.

Normalization is a process of eliminating data redudancy.

1NF- No repeating groups.

2NF- Eliminates the functional dependency on the partial key field.

3NF- Eliminates the functional dependency on the non-key field.