电信项目实施文件609Application.doc

Section 9: Oracle Applications 9.1 OverviewEnabling Commerce for the 21st CenturySet against the backdrop of accelerating rates of change in highly competitive global markets, businesses today struggle to align information management strategies with the renewable business processes. Operational effectiveness and compelling economic performance will increasingly require balanced information access and constant cycle time reduction beyond the enterprise.Overcoming the Impedance MismatchCorporate downsizing and rightsizing efforts of the last ten years have yielded results to enterprises which realized that reengineering was not a project or destination, but, indeed, a journey of constant renewal of the business, its people and its relationship with customer, partners and suppliers. This recognition of constant transformation as a permanent part of 21st century business culture requires business systems, which will not only accommodate change over-time, but will indeed become the foundation to propel change rapidly within the enterprise and beyond the legal enterprise to the supply chain.With the tremendous progress in information management tools and technologies over the past decade businesses are still anchored to applications which have evolved over the last quarter century on computer architectures and operational theories of the sixties and seventies. This phenomenon has triggered the explosive growth of open systems and client/server business computing. A significant global appetite for core business application systems developed specifically for global, distributed operational environments where “one-size fits all” approaches are too cumbersome, too impractical and totally unresponsive to change.THE MISSION OF ORACLE APPLICATIONSOracle, a recognized market leader in information management worldwide, is a solutions leader in business systems which enable continuous processes improvement across the extended enterprise-the supply chain. Information flow throughout the supply chain is as critical to the success of the enterprise as is the flow of goods and services. Oracle is uniquely positioned to assist businesses throughout the world with information systems implementations which address the competitive environment today and tomorrow. Simply, we want to help our customers get ahead and stay ahead.Oracle Applications are suites of business system designed specifically to drive continuous business process improvement. Cycle time reductions can be achieved by eliminating paperwork which accompanies transactions and the elimination of non-value-added, people intensive workarounds caused by islands of automation and ineffective inter-enterprise information access.Oracle ApplicationsORACLES APPROACH: THE ENTERPRISE VALUE CHAINThis Business Process Model provides the framework for understanding the operational challenges of your business. In this context, how do Oracle Solutions advantage our clients with their customers? The key issue is the ability to renew business processes, and the people skill sets which drive them, through technology leveraged business applications at the same time-continuously. Economic leverage will accrue to those enterprises which possess the leadership, the courage and the tools to exploit the challenge of self-renewal in the more complex business environment of the 21st century.ENTERPRISE VALUE CHAINFive customer-centric business processes are focused around the value proposition which connects you to your customers. Constant pursuit of best practices in each of these processes can only be achieved through superior information access at the point of need throughout the supply chain. Oracle Applications are designed to improve these five customer-centric processes and your financial and human resource management requirements. All products are built on Oracles leading information management technology infrastructure.The concept of flexible, extensible business systems which drive process improvement continuously must be engineered on a foundation of rapid implementation in the first place. Oracle has distinguished itself in flexible design and open interface strategies which radically reduce up-front time, effort and cost in implementing client-server applications to either replace or complement existing heterogeneous systems within the enterprise. Today, Oracle Applications operate in more than 4000 customer sites around the world and are the recognized leader in “time to benefit” from rapid implementation experiences in virtually every industry setting. Measurable improvements begin with the measure of time to implement the enabling application systems.The SmartClient 10 Release of Oracle applications extends the standard by which all application companies must now be measured. SmartClient 10 now delivers the most powerful user interface in the industry combining the familiarity of standard desktop tools with powerful enterprise application functionality optimized for ease of learning and ease of use. Additionally, the unique ability to attach media-objects with transaction processes provide practical solutions for a paper-free workplace.Disconnected computing support delivered in SmartClient 10 now make enterprise system connection of the mobile workforce possible and economically practical. Sales and service personnel can now deliver improved support to your customers needs. Additionally, market intelligence feedback to enterprise business systems can improve operational effectiveness and timely insight to strategic decisions based on fact-not feel.Oracles SmartClient 10 products are designed to integrate business processes, information management resources and administrative system within the enterprise value chain. Product features afford workflow directed productivity enhancement at a personal department or enterprise level. True process improvement is extended to suppliers and customers throughout the supply chain.MAKING TRADING PARTNERS PART OF THE ENTERPRISEElectronic Commerce is critical to the reduction of time, cost of interpretation and discontinuities in processes, relationships with trading partner throughout the supply chain. SmartClient 10 delivers for the first time practical integrated solutions to enable you to connect your strategic customers and suppliers to your extended enterprise business systems exploiting the power, the reach and the economic leverage of the World-Wide Web.YOUR SUCCESS IS THE MEASURE OF OUR SUCCESSThe underlying premise in Oracles SmartClient 10 release is that we grow and prosper only if we enable you to grow and prosper. Growth and prosperity is a measure of success in recognizing new markets, new opportunities and new ways to serve those markets. Insightful decision making requires effectively harnessing available information and knowledge. This is now a reality with integrated data warehousing support with the SmartClient 10 business applications. Oracle is the first global applications provider to offer the power of On-line Analytical Processing Systems integrated with transaction driven business systems.The pipeline to sustainable competitive advantage is now a reality. Oracles SmartClient 10 business systems are designed to put you back in control of your destiny-right where you want to be.Oracle Product Coverage of the Enterprise Value Chain9.2 Year 2000 ComplianceIntroductionYear 2000 Compliance requires five main factors to be satisfied with respect to date datatype processing:1. Correctly handle date information before, during, and after 1st January 2000 accepting date input, providing date output and performing calculation on dates or portions of dates 2. Function according to the documentation before, during and after 1st January 2000 without changes in operation resulting from with the advent of the new century assuming correct configuration 3. Where appropriate, respond to two digit date input in a way that resolves the ambiguity as to century in a disclosed, defined and pre-determined manner4. Store and provide output of date information in ways that are unambiguous as to century 5. Manage the leap year occurring in the year 2000, following the quad-centennial ruleThese criteria are a superset of the Year 2000 conformance requirements set out by the British Standards Institute in DISC PD-2000-1 A Definition of Year 2000 Conformity Requirements.The Oracle ServerThe Oracle Server is Year 2000 Compliant (i.e. fully comply with all five of the factors described above).Applications that use the Oracle RDBMS (Oracle7 and Oracle8 Server) and exploit the DATE data type (for date and/or date with time values) need have no concerns about their stored data when the year 2000 approaches. The Oracle7 and Oracle8 Server DATE datatype stores date and time data to a precision that includes a four digit year and a time component down to seconds (typically YYYY:MM:DD:HH24:MI:SS).No operational problems are expected with the Oracle Server, networking and system management products. Oracles Development Organisation has conducted tests of various Year 2000 operational scenarios to verify that there is no impact to users at the turn of the century. These scenarios included tests of replication, point-in-time recovery, distributed transactions. System management and networking features across timezones / datelines / centuries.The Oracle RDBMS has always stored dates using a four digit year (the OraDate format), hence customers using the DATE data type should not have any application level problems. To facilitate year 2000 compliance for applications that use the two digit year format the Oracle7 and Oracle8 Server provides a special year format mask RR. Using the RR format, any two digit year entered will be converted thus:Current Year Two Digit Year Year RR Format Last Two Digits Specified Returns0-49 0-49 Current Century 50-99 0-49 One Century after current 0-49 50-99 One Century before current 50-99 50-99 Current CenturyTherefore, regardless of the current century at the time the data is entered the RR format will ensure that the year stored in the database is as follows:If the current year is in the second half of the century (50 - 99) and a two digit year between 00 and 49 is entered: This will be stored as a next century year. E.g. 02 entered in 1996 will be stored as 2002 and a two digit year between 50 and 99 is entered: This will be stored as a current century year. E.g. 97 entered in 1996 will be stored as 1997.If the current year is in the first half of the century (00 - 49)and a two digit year between 00 and 49 is entered: This will be stored as a current century year. E.g. 02 entered in 2001 will be stored as 2002.and a two digit year between 50 and 99 is entered: This will be stored as a previous century year. E.g. 97 entered in 2001 will be stored as 1997.The RR date format is available for inserting and updating DATE data in the database. It is not required for retrieval/query of data already stored in the database as Oracle has always stored the YEAR component of a date in its four digit form.Oracle ApplicationsFrom Release 10.7, Smart Client (GUI) version is fully Year 2000 Compliant (i.e. fully comply with all five of the factors described above).With Release 10.7 reports still display two-digit years in most cases. However, the two-digit years are assigned to the appropriate century using the RR format mask. Most date fields in 10SC forms already support four-digit years. As of Release 10.7, all concurrent programs fully support both 20th and 21st century dates.9.3 Applications EnvironmentHardware, Operating System and Network EnvironmentsPlatform IndependenceThe Oracle database and Cooperative Applications run on the largest number of platforms and networks of any of our competitors.Supported PlatformsAmdahl UTSIntel Solaris (x86)AT & T 7000MIPS UnixAT & T 7000 R3MS Windows ClientAT & T System 3000OS/2AT&T Global Information Solutions MP RASPyramid 116 DC/OSx Bull DPX/20SCO-Open ServerDatapoint SVR4SCO UNIXDEC Alpha AXP Open VMSSequent DYNIX/ptxDEC VAX Open VMSSGI 168 Digital UnixSiemens Nixdorf 600 DG-UX, AViiONSun OS Fujitsu DS90Sun SolarisHP MPESun Solaris 2.x HP MPE-iXTandem Integrity S2HP-UXTandem Integrity NR281 IBM AIXTandem Integrity FT 764IBM MVSUNISYS ptxIBM RS6000 Unisys SVR4 IBM RS6000 AIXUnisys UnixwareICL DRS 3000Windows NT ICL DRS 6000 88open SystemsISC UNIXCore Database and Tools TechnologyLeveraging the Industrys Best Database SoftwareOracle Applications are engineered to take full advantage of Oracles leading-edge relational database technology. Oracle7.1 Cooperative Server Database:Oracle Applications are driven by a robust database architecture that efficiently and reliably accesses all data types, including records, audio/video, and text/image Oracle Applications use stored procedures and database triggers to madularize and minimize applications code and dramatically improve client/server performance Oracle7 Release 7.3 provides customers with a universal server for managing all types of informationrelational, spatial, text, images, video and audioby including significant advances for enterprise-wide distributed applications, scalable systems management, and corporate Internet and multimedia applications. Oracle7 Release 7.3 creates an architecture that scales from gigabytes to terabytes of information. This latest version of Oracle7 delivers superior support for enterprise-class data warehousing and on-line transaction processing (OLTP) systems, and provides the industrys first integration of scalable audio/video server technology to support rich data, including audio and video data streams. Leveraging the Industrys Best Applications Development ToolsOracle use its complete and integrated set of application development and CASE tools to design, implement, and document Oracle Applications. Developer/2000 and Designer/2000 are Oracles second generation tools for developing high-productivity, business-critical, client/server applications. Together, Developer/2000 and Designer/2000 offer the most integrated suite for all development, spanning rapid application development to high-end systems modeling. Oracle Discoverer is a suite of query and analysis tools that enables end-users to access and analyze their enterprise data, such as data found in corporate data warehouses. All Oracle Applications reports are developed through Oracle Reports, a graphical, user-friendly report writer. Users can easily modify reporting format or content to meet individual needsOracle Applications Release 10.7 is built on Oracle Server version 7.3. The minimum server version supported is 7.3.2.3. Oracle Applications requires the following Oracle tools in addition to the Oracle Server :Oracle ProductDescriptionCertified VersionOracle Server (with distributed processing and procedural options)Oracle Server7.3.2.3.0SQL * Formsprovides the basis for online forms2.4.0.0.0 and 4.5.7.1.8 (Oracle HRMS uses the 4.5.7.1.8 release)CRT UtilityGenerates CRT terminal definition files, and required by SQL * Forms1.1.0.0.0SQL* Reportprint a few oracle Applications reports1.1.10.3.1SQL * Plusused to configure and update the database3.3.2.0.2PL/SQLprovides procedural language extension of SQL2.3.2.3Oracle Reportsprint most Oracle Applications reports2.5.5SQL * Net connects network and client/server systems2.3.2.1.6SQL * Loadermoves data from files to database tables7.3.2.3The following tools are needed for optional features of Oracle Applications :Oracle ProductDescriptionCertification VersionOracle InterOfficeused with Oracle Alert4.0.4Pro*Cused to build custom applications2.2.2Oracle Bookprovides access to online documentationNetwork RequirementsOracle had performed some network testing on the SmartClient version of Oracle Applications and found that the percentage of user actions that produced each class of round trip traffic remained roughly the same and are as follow : 78% of user actions produced no round trips 12% produced 1-3 round trips 6% produced 4-10 round trips 4% produced more than 10 round trips Expressed another way: a delay of 1-3 round trips occurs about 2 times per minute a delay of 4-10 round trips occurs about 1 time per minute a delay of 10 round trips occurs about 1 time every two minutesThe duration of a round trip delay varies with the latency of the network. Typical latencies we have observed are: 100 ms in the US 200 ms in Europe 250-300 ms in Asia Pacific So, in a WAN with a latency of 300 ms (typical in Asia Pacific): a delay of 3.0 seconds occurs about 1 time every two minutes Round TripA round trip is a call from the client to the database server followed by a response from the server to the client. A client call may contain a SQL statement (such as a query), a stored procedure request, or a request for some other database operation, such as a commit or the opening/closing of a cursor. A server response may include data that the client requested, or a simple acknowledgment that the requested database operation was performed. Examples of user interface actions that may require round trip processing include the entry of a field value that requires complex validation, or a list of values validation where the list of valid values is no