Sunday, May 17, 2009

TRACKING System

Posted by Aries Wandari

Company policy in Health Safety and Environment is No Accident, No Harm to People, and Conserve Environment by Prevent Pollution. The company will regularly identify safety issue associated with all activities and take appropriate action to manage the risks and hence prevent or reduce the impact of potential accidents or incidents. And its all elements of the company mandate to create such safe workplace and environment.




Currently we has built and maintain TRACKING inhouse application software for this HSE matters. Built with VB6 and DBMS MSSQL 2000 .TRACKING is an electronic HSE management system as an automation in recording, reporting and documenting of HSE Input and Output. The system maintain safety issue of the company, such as Incident, Nearmiss, Substandard, Safety Inspection, etc. It provide as a paperless and fast communication since it generate an email notification and weekly reminder to every person related to the safety issue outstanding action. The system try to record all system (potential) failures in the company to prevent future incident. As the (potential) incidents reported and investigated, HSE team will try to discover basic cause of the incident and indentify what action/program need to be taken to control that losses.





Tracking Workflow
















All personnel is responsible to record and entry the safety input and output on tracking system. Personnel who don’t have email facilities can delegate it to tracking system custodian.

Secretary or custodian job:

  • To make sure that the HSE input from his/her department are entry or recorded in tracking system.
  • To monitor and control the close out action from his/her department.


HSE Terms

Incident
An undesired event that result in harm to people, damage to property or loss to process.

Near Miss
An undesired event which under slightly different circumstances could have resulted in harm to people, damage to property or loss to process.

Substandard
  • Action: Activities that can harm people if the activities procedure not getting improved.
  • Condition: A tools or workplace condition that can harm people if such condition not getting improved.

Inspection
Planned or unplanned departmental or personal inspection (safety patrol).

Safety talk
Departmental activities discussing a safety issue.

Suggestion
Personal suggestion about safety issue.

HSE Committee
A group of committee from every level of company organization hopefully to decrease information gap of safety issue.

Emergency drill
A simulation of emergency condition.

SA (safety audit)
Independent assessment of the safety management system to check its validity and reliability.

House keeping
Departmental housekeeping.

Hazard Operation
A physical situation with potential for injury to people, and or damage toproperty or the environment.

We’ve been accepting 6 proposal for our new weighbridge system so far. Two main qualification that the system can read our (old) weighing hardware correctly, and it has to be connected to SAP. This brand new weighbridge system will be:

  • Connected to SAP (customer, material, and transporter master data, pick Delivery Order directly).
  • To release truck, DO must pick directly from SAP. But its also can release truck in offline mode in case the SAP system is down. There is some flag that tell that the system is on offline mode. On offline mode, operator has authority to release truck. But there is validation routine once SAP connection establish.
  • Because SAP not allow user to access directly to SAP, the system must access via BAPI, and its follow as a normal transaction so that it follow normal transaction flow.
  • Approval mechanism in case the weight beyond tolerance, or validation routine after SAP system down. Tolerance configuration defined locally on the system, and it has to be easy to maintain.
  • Source code and manual, to tackle the need of system extension in the future.
  • User authorization: operator, administrator, manager (system approval).
  • Print ticket and update DO data in SAP telling that this DO has been carried out.
  • Weighing routine support for 2 types of material, finish good/non finish good.



My job is making technical evaluation of these vendor and propose rank of them. We can see their qualification based on proposal quality, system understanding on their presentation, and software demo. Source code, manual, and maintenance period is also one of big concern. And the price? We left it for procurement team and boss.


For those 6 proposal, 4 vendor do come and discuss what they have for our requirements.
  • Vendor A, the vendor which I get my SAP training. There is no doubt that this vendor is a SAP master. They also have good understanding on weighbridge business flow. But we have no data whether they can handle legacy weighbridge hardware (read the value of the weighbridge hardware). They do promise a demo on the second meeting.
  • Vendor B, sure an old player in weighbridge world, but not in SAP. Tight schedule of this weighbridge system make us force the vendor do a demo, showing that their software can connect to SAP and connect to weighbridge hardware. They do show us their program connect to weighbridge hardware. Its failed. One big loss for their rank, their system using third party component to connect to weighbridge hardware, and will be separate licence of the system. It does mean –eventhough we had the source code- we can’t extend the system since we don’t have the component.
  • Vendor C, good understanding in both weighbridge and SAP. Good software demo showing its integration with SAP. They miss first trial of demo connect to weighbridge hardware. But on later demo, they succeed reading value of the hardware. They give us VB.NET and VB6 demo, and both work.



  • Vendor D, thanks for their good effort. Old player of weighbridge system with lack of SAP experience. But they fail reading weighbridge hardware. They using many software to read com port traffic data, and even de-compiling our old weighbridge software to see how the software communicate with the hardware.


With that qualification, the sequence is (big point first) is: vendor C, vendor B, vendor A.


SAP Weighbridge Workflow

Weighbridge Software, Legacy

Posted by Aries Wandari



Weighbridge software is one of softwares IT responsible to maintain. Starting its duty on 96-an till now, with Windows 95 operating system using old PC with small harddisk space and without any network slot. We had try install it on Windows 2000, but the system become unstable. Meanwhile, the vendor stop supporting this legacy system. Its hard to maintain the software on those conditions. With current requirement that Weighbridge System must integrate with SAP, its time to replace the system.







Two weighing hardware connect to computer via com port 1 and 2, supporting 2 paralel weighing routine. Software can be configured whether it can only weighing in one direction (in or out only), or both.



Weighing routine flow chart