Online Bank Transaction Processing System for Ceylon Petroleum Corporation

Abstract

The Ceylon Petroleum Corporation (CPC) was establish as a state own enterprise by Act. No. 28 of 1961 by Parliament of Sri Lanka. The main objectives of Ceylon Petroleum Corporation are carry out import, export, refine & distribution of Petroleum Products. CPC distribute main products (Petrol, Diesel, Kerosene, Fuel Oil etc) via 1,100 filing stations through 3 terminals & 12 island wide bulk depot. Customers (Dealers & Bulk Consumers) place the orders to distribution terminals or bulk depot. More than 90% of orders handle by cheques of COD (Cash On Delivery). CPC Management observe Cash / Cheque deposit & Cheque realization delay of many transactions and search workable mechanism to avoid such delays. Therefore, hear I proposed to implement “Online Bank Transaction Processing System” to avoid such delays & malpractices. After implementation of this system, CPC customer can place order as previously and payments can make directly through bank via bank transfers or Cash or Cheque deposits. Banking system validate customer number and product area before accept the payment. If payment is validated, bank made credit entry for CPC bank account and update this system via web service. After receiving bank transaction details from bank system updates SAP ERP system via another web service. After receiving SAP ERP update confirmation system automatically send SMS or /and email confirmation to Customer. This system Customer requirement and required outputs are very clear. Therefore, I selected iterative waterfall methodology for this development and Object oriented methodology used for system design. Also this system mostly used existing IT infrastructure such as software license of SQL Server Database, IIS server, email service, Visual studio development environment. For the clients environment used Microsoft Windows workstations and existing IPVPN used for island wide branch communication. In-addition to CPC has to purchase SMS gateway and provide to connectivity with CPC head office with Bank Branches. System test on module wise & final product. Customer confirmation get module wise and do some minor changers finally carry out user training and system evaluation. All system modules success more than 75%. Due to unavoidable circumstances this system so far not implemented. If this system is implemented, all sales transactions much more similar to cash base transaction. Therefore, CPC can remove customer credit limits, remove complexity of the present payment collection system and improve CPC cash inflow.