Design And Implementation Of Currency Conversion Program For Financial System In Commercial Bank

Commercial bank's existing MIS system is distributed system which based on C/S architecture, it is deployed to all branches. Each branch has its own separated accounting and reporting system. It's hard for the bank to centralize management of data storage, financial accounting and disclosure of information. It affects the bank to disclose information in time and accurately.According to research and comparative analysis, based on Oracle applications 11i's general ledger, payable and assets modules, we will design and implement general ledger interface, currency conversion program and financial reports. So the bank can establish a unified centralized financial system. Firstly, general ledger interface can import accounting data of Core Banking System into Oracle Applications 11 i general ledger module with conversion and mapping rules, import and post journal entries at the same time. Secondly, because of the limitations of Oracle Applications 11 i, it can only provide the original currencies data of beginning balance, period balance and ending balance of its basic branchs. It is necessary to design currency conversion program in financial system, in order to 1) summarize results of its branches at first level and second level; 2) summarize accounts at first level and second level; 3) generate the data with converting all original currencies into CNY and US dollar. Finally, based on the results of currency conversion program, it also can generate financial reports indexes to meet the requirements of the bank's uniform financial accounting and disclosure of information.Software engineering is used as main line in this paper, we will introduce how to design and implement general ledger interface, currency conversion program and financial reports by requirements analysis,architecture design, design and implementation, testing and verification. Make sure that they connect with Oracle Applications 11 i perfectly, the data is consistent, accurate and timely. After releasing to production, financial system can deal with 150,000 journal entries, summarize 6 million records, generate more than 300 financial reports for 41 branches and 700 second level branches every day. It made a good economic return.