CN104809557A - Transaction processing system based on Oracle EBS platform - Google Patents
Transaction processing system based on Oracle EBS platform Download PDFInfo
- Publication number
- CN104809557A CN104809557A CN201510196093.4A CN201510196093A CN104809557A CN 104809557 A CN104809557 A CN 104809557A CN 201510196093 A CN201510196093 A CN 201510196093A CN 104809557 A CN104809557 A CN 104809557A
- Authority
- CN
- China
- Prior art keywords
- transaction
- business
- transaction information
- coding
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention relates to a transaction processing system based on an Oracle EBS platform. The transaction processing system works according to the following steps of achieving fire coal complete flow service functions through the code compilation and deployment of an EBSR12 platform rear-end server, conducting united transaction function design on the service functions, conducting coding to obtain a list structure, a view, a trigger and the like of transaction information, achieving the synchronization correlation between transactions and service data through the compilation storage process and the registration transaction program request, obtaining approval actions of the service dada in real time, obtaining and storing transaction information through types of the service data and basic information of service operation, compiling transaction information statistics and analysis codes, calling an OPENINTERFACE interface through coding, and achieving the joining of the transaction information and the service functions and the traceability of the service data through foreground standardized interface display. By means of the transaction processing system, the digital management of coal yards, reduction of all the service functions and unified integration of various service types and financial modules can be rapidly and effectively achieved.
Description
(1) technical field
The present invention relates to a kind of based on Oracle EBS platform transacter.
(2) background technology
Transaction methods is a kind of method of science, simple and clear material statistical study, is the effective means of the standardized management to existing thermal power plant fuel system fire coal.Issued transaction is derived from the computing method of the material statistics and analysis of the stock control of ORACLE ERP.
The essential information of issued transaction comprises the information such as transaction types, affairs coding, traffic ID, transactions, the affairs amount of money.Transaction types confirms type and the scope of business function, the affairs code verification unique identification of transaction information, traffic ID is as the tie of transaction information and business function, reviewing of business datum can be realized, transactions and the affairs amount of money are then the essential informations of affairs, are the basic foundations of Transac-tion processing.The application of issued transaction effectively can not only solve the problem of data integration of FAM fuel system as complete ADS and ORACLE ERP standard module, scientific and normalization management can also be carried out to fire coal, realize the digital management of coal-fired coal yard, improve coal yard fine-grained management level.
A coal-fired kind as material is the business main line of whole fuel system.Using fire coal as the basic object of issued transaction, be used as the primitive rule of Transac-tion processing with the implementation procedure of business function, by the transactional process to all coal-fired power plant system all functions modules, realize the stripping of Business Stream and data stream.System cost calculates, intellectual analysis all carries out statistics and analysis based on the basis of Transaction Information.By realizing the calculating of affairs and ORACLE ERP finance and the data integration of goods and materials module.
By associating one by one of business function and transaction information, not only can realize reviewing of coal-fired business datum, can also reduce the basic process of service computation, realize the Whole Course Management of coal-fired data statistics.All synchronizing traffic data are generated transaction information, unified management and analysis is carried out to transaction information, avoids the problem of multi-dimensional data collection and arrangement, substantially increase the efficiency of systematic analysis.
FAM Fuel Management Information System is the fuel Whole Course Management infosystem based on the complete self-service exploitation of ORACLE EBS platform.Carry out unified standard and management by the fuel business of coal fired power generation unit belonging to electricity to China, reach the information-based regulatory level improving fuel, reduce the target of coal-fired cost.FAM Fuel Management Information System is because systemic-function is huge, class of business is various.And often kind of business and reverse flow process thereof all can have an impact to the Coal-fired capacity quality and price of system and the amount of money thereof.How to realize the digital management of coal yard fast and effectively, realize all business functions reducible, realize the unified integrated important topic being FAM Fuel Management Information System and needing to study of multiple business type and fiscal module.
(3) summary of the invention
The present invention in order to make up the defect of prior art, provide a kind of fast and effeciently can realize coal yard digital management, realize all business functions reducible, realize multiple business type and the unified integrated Oracle EBS platform transacter of fiscal module.
The present invention is achieved through the following technical solutions:
A kind of based on Oracle EBS platform transacter, it is characterized in that: comprise the following steps:
1) worked out by code server and dispose, erection that ORACLE 11G installing DB realizes Oracle EBS R12 platform, by realizing FAM Fuel Management Information System whole process business function to the coding of fuel functional module and deployment;
2) according to business function and implementation procedure thereof, carry out unified Transaction Design, confirm the essential information of affairs, create transaction table by coding;
3) request that performs of coding registration transactions, distinguishes different business function according to transaction types, realizes associating one by one of affairs and business datum;
4) by WORKFLOW synchronization call, the examination & approval activity of real-time monitoring business data, when business function carries out review operation, is stored in transaction information table by the essential information of business datum ID and business operation thereof;
5) by the transaction information logic deletion of encoding when realizing business datum contrary operation or the synchronous operation upgraded;
6) write transaction information statistics and code analysis, add up to the transaction information quantity of all participation coal-fired costs, the amount of money, unit price and quality information are weighted average treatment, finally obtain coal-fired cost;
7) the data-interface table of transaction information write fiscal module is realized by coding, and synchronization call OPENINTERFACE interface, realize the data integration with fiscal module;
8) realized the foreground standardized interface displaying of affairs details by coding, and according to the business datum ID retained in transaction information, the association carrying out business datum is called, and realizes reviewing of business datum.
The invention has the beneficial effects as follows:
1) computation complexity to the combinatory analysis of multiple business function is reduced based on issued transaction, just can be collected the quantity amount of money and the computation process information of all business function implementations by transaction table, not need again the different list structures of inquiry system different service types.
2) the basic calculating process of transaction information record traffic function, achieving business datum can review, the reducible effect of service computation process.
3) call OPENINTERFACE by inquiry transaction information and can realize the integrated of the multiple business data such as expense before advice of settlement, prepayment, pre-knot, payment, factory and finance, avoid the situation that often kind of business all needs to do separately interface exploitation.
4) transaction processing facility is by reference more simple and convenient when realizing system and ORACLE ERP system standard module integrated.
(4) embodiment
Be below specific embodiments of the invention.This kind, based on Oracle EBS platform transacter, comprises the following steps:
1) worked out by code server and dispose, erection that ORACLE 11G installing DB realizes Oracle EBS R12 platform.By realizing FAM Fuel Management Information System whole process business function to the coding of fuel functional module and deployment.
2) according to business function and implementation procedure thereof, carry out unified Transaction Design, confirm the essential information of affairs.The Back ground Informations such as transaction table structure, view, trigger, synonym, sequence number are created by coding.
3) request that performs of coding registration transactions, distinguishes different business function according to transaction types, realizes associating one by one of affairs and business datum.
4) by WORKFLOW synchronization call, the examination & approval activity of real-time monitoring business data, when business function carries out review operation, is stored in the essential information of business datum ID and business operation thereof in transaction information table.
5) transaction information logic when realizing business datum contrary operation by coding is deleted or the synchronous operation such as renewal.
6) write transaction information statistics and code analysis, add up to the transaction information quantity of all participation coal-fired costs, the amount of money, unit price and quality information are weighted average treatment, finally obtain coal-fired cost.
7) the data-interface table of the modules such as transaction information write finance are dealt with, receivable, general ledger is realized by coding, and synchronization call OPENINTERFACE interface, realize the data integration with fiscal module.
8) realized the foreground standardized interface displaying of affairs details by coding, and according to the business datum ID retained in transaction information, the association carrying out business datum is called, and realizes reviewing of business datum.
Except technical characteristic described in instructions, all the other technical characteristics are those skilled in the art's known technology.
Claims (1)
1., based on an Oracle EBS platform transacter, it is characterized in that: comprise the following steps:
1) worked out by code server and dispose, erection that ORACLE 11G installing DB realizes Oracle EBS R12 platform, by realizing FAM Fuel Management Information System whole process business function to the coding of fuel functional module and deployment;
2) according to business function and implementation procedure thereof, carry out unified Transaction Design, confirm the essential information of affairs, create transaction table by coding;
3) request that performs of coding registration transactions, distinguishes different business function according to transaction types, realizes associating one by one of affairs and business datum;
4) by WORKFLOW synchronization call, the examination & approval activity of real-time monitoring business data, when business function carries out review operation, is stored in transaction information table by the essential information of business datum ID and business operation thereof;
5) by the transaction information logic deletion of encoding when realizing business datum contrary operation or the synchronous operation upgraded;
6) write transaction information statistics and code analysis, add up to the transaction information quantity of all participation coal-fired costs, the amount of money, unit price and quality information are weighted average treatment, finally obtain coal-fired cost;
7) the data-interface table of transaction information write fiscal module is realized by coding, and synchronization call OPENINTERFACE interface, realize the data integration with fiscal module;
8) realized the foreground standardized interface displaying of affairs details by coding, and according to the business datum ID retained in transaction information, the association carrying out business datum is called, and realizes reviewing of business datum.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510196093.4A CN104809557A (en) | 2015-04-23 | 2015-04-23 | Transaction processing system based on Oracle EBS platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510196093.4A CN104809557A (en) | 2015-04-23 | 2015-04-23 | Transaction processing system based on Oracle EBS platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104809557A true CN104809557A (en) | 2015-07-29 |
Family
ID=53694365
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510196093.4A Pending CN104809557A (en) | 2015-04-23 | 2015-04-23 | Transaction processing system based on Oracle EBS platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104809557A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108197268A (en) * | 2018-01-04 | 2018-06-22 | 国网福建省电力有限公司 | Data center analyzes numeric field data Synchronous fluorimetry method for improving |
| CN111966764A (en) * | 2020-08-20 | 2020-11-20 | 上海明华电力科技有限公司 | Data processing system compatible with Oracle EBS and SAP system |
| CN115587883A (en) * | 2022-11-22 | 2023-01-10 | 荣耀终端有限公司 | Cost pricing method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1758274A (en) * | 2005-09-26 | 2006-04-12 | 郭军 | Universal service processing method and its computer system |
| US20100082497A1 (en) * | 2008-09-18 | 2010-04-01 | Sap Ag | Providing Foundation Application as Enterprise Services |
-
2015
- 2015-04-23 CN CN201510196093.4A patent/CN104809557A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1758274A (en) * | 2005-09-26 | 2006-04-12 | 郭军 | Universal service processing method and its computer system |
| US20100082497A1 (en) * | 2008-09-18 | 2010-04-01 | Sap Ag | Providing Foundation Application as Enterprise Services |
Non-Patent Citations (1)
| Title |
|---|
| 易洋: ""基于ORACLE EBS的物资需求管理系统的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108197268A (en) * | 2018-01-04 | 2018-06-22 | 国网福建省电力有限公司 | Data center analyzes numeric field data Synchronous fluorimetry method for improving |
| CN111966764A (en) * | 2020-08-20 | 2020-11-20 | 上海明华电力科技有限公司 | Data processing system compatible with Oracle EBS and SAP system |
| CN115587883A (en) * | 2022-11-22 | 2023-01-10 | 荣耀终端有限公司 | Cost pricing method and device |
| CN115587883B (en) * | 2022-11-22 | 2024-03-08 | 荣耀终端有限公司 | Cost pricing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10956911B2 (en) | System and method of managing data injection into an executing data processing system | |
| CN104700275A (en) | Electronic commerce platform financial accounting method and system | |
| CN104240024A (en) | Financial budget system and method based on B/S structure | |
| CN109670943B (en) | Settlement system, settlement method, computer equipment and storage medium | |
| CN104992279A (en) | Performance assessment method and device | |
| CN104657808A (en) | System and method capable of realizing real-time inquiry and management of fund data of enterprise | |
| CN104809557A (en) | Transaction processing system based on Oracle EBS platform | |
| CN104463648A (en) | Big data system based on network invoice and processing method | |
| CN114840527A (en) | Data processing method, device and computer readable storage medium | |
| CN112613711A (en) | Water affair big data index management method and system based on six analysis methods | |
| CN104200585A (en) | Method for remote invalidation of self-service invoicing | |
| CN104700335A (en) | Method and system for managing real estate transaction taxes | |
| CN114187045A (en) | Digital intelligent operation system | |
| CN206178965U (en) | A information -based management system for power communication | |
| CN111222967A (en) | Group enterprise full-tax-variety taxpayer payment and declaration method and system | |
| CN111241143A (en) | Distributed calculation method and system for water supply amount and water fee | |
| CN111415237A (en) | Invoice verification and cancellation method, system, terminal and medium | |
| CN104036368A (en) | Method and device for asset collection | |
| CN105068978A (en) | Method and system for automatically auditing daily statement and monthly statement based on database | |
| CN111311340B (en) | Method and device for identifying virtual invoice behavior | |
| CN102081785A (en) | Credit reporting and providing service system based service processing method after credit providing | |
| CN117408826A (en) | Financial data processing method and device, electronic equipment and readable storage medium | |
| Taminiau et al. | The Social Geography of the Solar Renewable Energy Credits (SREC) Market | |
| CN110990392A (en) | Method for foreign trade service supply chain | |
| TWM646999U (en) | Accounting report integration server system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150729 |
|
| RJ01 | Rejection of invention patent application after publication |