ERP System Survey Questionair

Comment on ERP Usage related to your work
1 Which ERP module(s) you use currently:
Inventory Control Module yes/no
Sales Module yes/no
Purchase Module yes/no
Manufacturing Module yes/no
MRP Planning Module yes/no
Accounting Module yes/no
2 How important of ERP system relative to your daily work very important / less important / no comment
3 How important of ERP system affect your dept/whole company business operation very important / less important / no comment
4 ERP can provide info to help better management decision-making strongly agreed / not agreed / no comment
5 You can logon and use ERP anytime and anywhere, i.e. good system availability to users. strongly agreed / not agreed / no comment
6 ERP can provide function to meet nowadays requirement as well as future business operation needs strongly agreed / not agreed / no comment
Pls identify what system function need to be improved_______________________________
Comment on Overall System Operation
7 ERP is easy for users to operate, i.e. very User-Friendly. strongly agreed / not agreed / no comment
8 ERP response time for performing data update or report generation is acceptable. strongly agreed / not agreed / no comment
9 ERP provides a very accurate management information, i.e. good data integrity. strongly agreed / not agreed / no comment
10 ERP helps to decrease the workload of users significantly. strongly agreed / not agreed / no comment
If you feel your productivity declined by using ERP, please give up to three reasons you feel this happened:

_______________________________________

11 ERP user access right application is under well control, i.e. good authorization procedure. strongly agreed / not agreed / no comment
12 Users aware their liability on the system usage, especially perform data update function, i.e. system increases users accountability.
13 ERP provides sufficient logging report to check user action, i.e. good traceibiltiy function. strongly agreed / not agreed / no comment
14 MFG/PRO system is protected from both internal and external hacker, i.e. high system security. strongly agreed / not agreed / no comment
Comment on local/external consultant and training support:
15 Users clearly understand the ERP Helpdesk procedure to ask for support, e.g. who and how to request ERP support,
16 Users clearly understand the ERP support organization, i.e. the responsibility of system owners, Dept expert/key users, the first and 2nd line technical support among HK, Shanghai and Shenzhen IT-Depts as well as external vendor consultant support.
17 The function of ERP user group committee in Shanghai and Shenzhen factory is well recongized, i.e. each dept respesentatives activity participate the user group committee meeting to improve ERP operation and raise usefull request.
18 Training document and operation manual for ERP are adequate and esay assessable. strongly agreed / not agreed / no comment
Pls identify which missing operation document you need:_______
19 Training or consultant support from your supervisor is adequate strongly agreed / not agreed / no comment
20 Training or consultant support within users dept’s expert/key user is adequate strongly agreed / not agreed / no comment
21 Training or consultant from IT dept is adequate strongly agreed / not agreed / no comment
22 Training or consultant from external vendor consultant is adequate strongly agreed / not agreed / no comment
Comment on Problem Handling
23 Users clearly understand the error handling procedure to solve any ERP error, i.e. who and how to report ERP error. strongly agreed / not agreed / no comment
24 Users satisfy the software quality of MFG/PRO in term of mininal program bug and data update error. strongly agreed / not agreed / no comment
25 Users satisfy the error handling procedure as well as the response time to error and fix. strongly agreed / not agreed / no comment
26 IT Dept and external vendor consultant support are technical enough to solve error. strongly agreed / not agreed / no comment
Comment on further System Development
27 IT Dept and vendor consultant support are technical enough to provide professional advice on system development. strongly agreed / not agreed / no comment
28 ERP system is flexibility enough to build/enhance function to meet new requirement. strongly agreed / not agreed / no comment
29 Company allocates sufficient internal IT man-power resource on ERP function enhancement strongly agreed / not agreed / no comment
30 Company reserves sufficient funding for external vendor on ERP function enhancement strongly agreed / not agreed / no comment
31 The development progress on function enhancement by IT Dept is under well control strongly agreed / not agreed / no comment
32 The development progress on function enhancement by vendor consultant is under well control strongly agreed / not agreed / no comment
33 The project management/monitor on function enhancement by IT Dept is well performed strongly agreed / not agreed / no comment
34 Cost of function charge by external consultant is high strongly agreed / not agreed / no comment
35 Your Overall rating to ERP System Excellent / Not Acceptable / no comment

BUSINESS CONTINUITY PLAN for ERP & SFC APPLICATION

1.        Purpose

Company relies extensively on large and complex information systems for its daily operations and value creating processes. Disruption of these systems will have serious negative implications for our business. The purpose of this document is to outline the set of appropriate policies and procedures that is necessary for the management of system disruption scenarios that potentially affect our most critical information systems. This procedure allows us to minimize the impact of disruption to our most critical systems and to restore the systems to full functionality in an efficient and effective way. Read More

ERP (MFGPro) Disaster Recovery Procedure

1.        Purpose

The objective of this plan is to provide a guideline to the organization to continue managing the business through MFGPro and to minimize the disturbance to manufacturing operations in the event that the MFGPro system is totally unavailable and cannot be recovered within 48 hours.

The service provided during the disaster recovery is of survival nature, may not extend to every user, and may require end-users to re-enter the backlog transactions at the commencement of the disaster recovery and at re-starting of the normal operation.

The recovery option will be varied in nature depending on the cause of the outage. This may require set-up of LAN server, secondary processing center, etc. Read More

Blueprint Document for implementation of SAP Project

1      Management summary

The purpose of the business blueprint document is to present the results, findings and conclusions of the blueprint finalization phase of the SAP project. This document consists of:

  • The business process requirements of Company within the scope of SAP;
  • The specification for the SAP system to support these target business processes;
  • The detailed work-plan to design the SAP system and business processes.

SAP poject phase overview:

Setup and Scoping –> Blueprint  –> Core System –> Core System –> Implementation
Scoping                        finalization      realization           construction Read More

ERP Operation Policy for IT

Objective :

ERP is a multi-function and highly integrated application that supports most of the critical operations within the company.  In using such an ERP application, while we can depend on some of the built-in checks and balances embedded in the system, the most important business control and appropriate use of the system lies in the working habit and disciplines of people who use it. This Policy is devised to help ensure such work disciplines are in place among all users as well as all IT staff. Read More

Disaster Recovery Plan for MFG/PRO ERP System

1.        Definition

In this document context, ‘MFGPRO ERP System Disaster’ refers to the situation where the total system is unavailable to the users either due to hardware, network, or software problems and recovery is estimated to take more than 48 hours

‘MFGPRO Disaster Recovery’ is to offer a temporary measure/workaround solution to the organization to enable partial delivery of the processing service. Read More

Hyperion Restore Procedure

1)     Objectives

This document is to describe the methodology employed and process involved in the recovery of the Hyperion system currently operated in the company.This document will be updated and maintained by IT department, and posted in the Hyperion Planning Implementation Database for access by project members as well as the end-users.

2)     Applicability

This applies to the following server components of the Hyperion applications.

o   Application and Web Server (Application)

o   Reports Server  (Application)

o   Essbase Server  (Transaction Data)

o   Oracle Server (Application Configuration/Reports Definition Data)

These servers are located in the computer room controlled and managed by IT Department.

3)     Responsibility

IT department is responsible for the managed operation of the application, which involves systems installation, systems upgrade, backup, recovery, and technical infrastructure support while the systems owner is responsible for the maintenance of the models/reports built on the application.

Primary Support              Secondary Support

IT    Department:            ….

Application Owner:        ….

4)     Processes

4.1)  Normal Recovery

This refers to the situation where a server is corrupted due to hard disk failure and requires re-built, or alternatively, the database is corrupted and requires recovery. Advanced approval is required from the site IT Manager prior to the recovery is executed.

4.1.1 Application & Web Server (Hy-web) & Reports Server (Hy-rpt)

  1. Get the hardware ready for restore.
  2. Identify and restore the latest system backup/Ghost image of Hy-web & Hy-rpt’s C: Drive.
  3. Open the latest daily Hy-web & Hy-rpt’s ArcServe backup and restore all directories & files (i.e. Overwrite all existing directories and files).
  4. Logon to the Planning, Analyzer, and Reports on Web to test out the access and the data availability.

Essbase (Hy-Ess)

The following is for a complete rebuilt when the hard disk is totally damaged. Should only the database restore is required; the last step is needed to be executed.

  1. Get the hardware ready for restore
  2. Re-install Sun Solaris 8
  3. Re-create a user called “essbase” with home directory set to /essbase
  4. Restore root’s profile
  5. Restore the crontab file: /var/spool/cron/crontabs/root.
  6. Restore the latest daily backup (please refer to the procedures posted under “Essbase Data Restoration” in the Hyperion Planning Implementation Database). Logon to Essbase to do a sample checking of the reports in order to verify data is restored properly.

Oracle

If a complete rebuilt of the Hyperion instance is required, go to step e directly.

  1. Get the hardware ready for restore
  2. Install Oracle 8.1.6. rc2 Enterprise Server
  3. Create an instance called “hysi”
  4. Locate the latest daily Oracle backup.
  5. Run the command in DOS prompt: IMP system/manager FULL=Y IGNORE=Y FILE=<exported file> where currently, the name of the export file is called “daily_hysl_fullexp.dmp”.
  6. Logon to the Planning and do a sample checking for dimension, scenarios.
  7. Logon to Analyzer and Reports to retrieve one of the reports to see whether the data is displayed properly.

4.2)  Disaster Recovery

Disaster recovery refers to a situation where all of the server hardware is completely lost or damaged. Changeover to a temporary application infrastructure is required in order to provide minimal survival services to the user community. It is intended not to cover the entire user community, but 50% only. The fall back period is estimated to be 4-8 weeks prior to the new production hardware is acquired and set-up.

4.2.1        Backup Application Infrastructure

During the fall back period, it is planned to use a single Intel PC as a temporary machine with all products/system components installed which includes web/application, Analyzer, Report, Essbase, and Oracle. The machine should satisfy the following minimum configuration in order not to have significant performance degrade.

–          CPU of at least 2GHz,

–          At least 4G RAM,

–          At least a 100G hard disk

–          10/100M Ethernet Connection

This machine will be located in the IT area at the another Office, and it is controlled, and reserved by IT for such purpose.

4.2.2.       Recovery SLA

Tasks Estimated Time
Backup Equipment available 2 hours
Server recovery 2 days
Re-connect users PC to the backup infrastructure 1 day *
Access & Data Testing 1 day *

* Concurrent event

4.2.3        Server Recovery

Procedures to recover servers as follow

  1. Install Windows 2000 sp3 in an Intel based machine.
  2. Install Hyperion Analyzer Server, JRUN 4.0, Hyperion Planner, JRE 1.3, and Hyperion Report client in the machine used in Step 1.
  3. Install Essbase Server, create the MDS database, restore the outline files from the backup tape, and then perform full load of the Mds Application to the MDS database in the machine used in Step 1.
  4. Install Oracle 8.1.6 rc2 Enterprise Server, create a new Oracle instance called HYSL in Step 1, and then perform full import using the daily backup dump files stored in backup tape.

4.2.4        Network Connection

  1. Configure the new machine in Step 1 so that both Hyperion Analyzer, and Hyperion Planner are pointing to the Essbase database & Oracle database created in step 3 & 4.

4.2.5        Client Recovery

  1. Reinstall all the necessary thick client in each user’s PC (For those user that use thin client to access Hyperion, there is no need to perform reinstallation.

4.2.6       People Organization

During the Disaster Recovery, a project team is set-up comprising of the Application owner, site IT Manager, and the IT support staff. The Application Owner will assume the lead for this process and will co-ordinate and communicate with the user community for any systems arrangement while IT will be responsible to make sure the backup infrastructure is established, data is restored and system connection is normal.

4.2.7        Rehearsal Run

A yearly rehearsal run should be executed to ensure the above stated process is working properly. The results of the rehearsal will be documented and filed for reference.