电信项目实施文件03option1phase.doc

Section 3 : Option 1 Phase 1 Implementation (Logistics)3.1 SummaryOracle has recognized the HONGKONG TELECOM requirement to meet Y2000 compliance within its Logistics Information System. Oracle therefore proposes an approach to provide that compliance and minimize operational change for day to day business operations. In Option 1 for implementation of a new Logistics system, legacy satellite systems will remain unchanged and to a minimum extent interfaced to the new Logistics System. This approach builds a foundation for further improvements using Oracles products and services and is a relatively safe way to meet short term goals and also satisfy long term strategic objectives with a cost effective program.Oracle also recognizes the complexity in building interfaces with a number of legacy systems, and recommends HONGKONG TELECOM work with Oracle in creating these interfaces in a rapid time frame. Option 1 Phase 1 Logistics of the Business Support System will be positioned as the core element of Hongkong Telecoms integrated information system which will allow Logistics operational analysis and forecasting at both the management and operational level. The core of the Option 1 Phase 1 solution is the Oracle Distribution applications modules. These application software modules are “off the shelf” applications which support the business activities of Order Management, Purchasing, Supply Chain Planning and Distribution. These applications have been built using standard Oracle Developer/2000 on Oracle RDBMS.Surrounding this core package will be a minimum set of custom extensions to support agreed upon functionality gaps not supported by the proposed applications. Initially these gaps will be carefully reviewed for Option 1 Phase 1 impact with a desire to minimize risk and realize a faster implementation. Custom extensions will be developed using Oracle Developer/2000 for consistency in the user interface. 3.2 ScopeA well-defined scope establishes the parameters and outcomes of the project. This section presents our current understanding of Hongkong Telecom requirements to address the stated system needs. The scope of this proposal is based on the Request for Proposal information , interviews with the key users from the main business functions, and other correspondence on this subject . We have referred to the Hongkong Telecom “Requested Scope And Strategy For Quotation From Suppliers” dated 3 October 1997, which is outlined in the following sections.In Option 1 Phase 1 of the project, Oracle will implement Oracle Logistics modules for HONGKONG TELECOM Logistics PMO functionality and replace the current D&B Logistics Systems. Internal interfaces with existing Logistics satellite systems will be included and external interfaces with other legacy systems will be created. Moreover, interface between D&B General Ledger and Oracle General Ledger will be built.3.2.1 Included in Scope Oracle Applications Modules- Section 3.3 Internal Satellite Systems- Section 3.4 Extensions- Section 3.5 Interfaces- Section 3.6 Reports- Section 3.7 Training- Section 3.9 Project Milestones- Section 3.10 Project Organization- Section 3.11 Project Gantt Chart andCritical Path- Section 3.12 Project Team (Oracle and HKT)Resource Estimate- Section 3.13 Key Deliverables- Section 14.23.2.2 Out of Scope AreasThe scope of work in this implementation proposal does not include any tasks or activities related to the following : Data Conversion This task involves extracting the data from the in-house system and loading it into the Oracle Applications. This task will not be performed by Oracle Consulting Service (OCS). A flat file format will be supplied to HKT by the OCS project team and it will be the responsibility of HKT to supply the conversion data in the ASCII file format provided and load this into the Oracle Application. It is the responsibility of HKT to ensure the validity and accuracy of this data. Interfaces: The provision of any interfaces into or out of the Oracle Financials that has not been included in the Interfaces Table outlined in section 5.6 of this proposal will be out of the scope of the project. Any time spent assisting HKT on the design, build or testing of these additional interfaces will be subject to change control. End User Training: All end user training will be conducted by Hongkong Telecom. Business Process Reengineering/Redesign: The assumption that we make in this proposal is that the business processes will not differ substantially from what was provided in the tender document provided HKT. The team members will perform analysis and understand these processes and map it to the proposed package. They will not undertake to recommend changes or undertake to change these processes. However in the course of mapping these to the package, if a modification to the process is necessary and has a positive result, the team may recommend a change. This will have to be accepted by HKT before any implementation. Again any changes proposed will have to be handled as per the Change Control Procedure. Additional Custom Extensions: Based on our understanding of the tender a number of custom extensions have been identified (please see section 3.5 of this proposal). Any additional custom extensions will be handled as per the Change Control Procedure. Hardware selection: Oracle proposal for the implementation of Oracle Financials does not cover the selection of a hardware vendor. Information can be provided on the certified platforms but any selection of vendors is outside of this scope.Network or Benchmark testing: The only testing that Oracle will undertake is the unit testing of custom extension. OCS may perform ad-hoc conference room pilot testing of system functionality but this is at the discretion of the OCS project manager.3.3 ModulesThe Oracle Applications modules to be implemented in Option 1 Phase 1 are : Oracle Alert Oracle Inventory Oracle Bill of Materials Oracle Service Oracle Quality Oracle MPS/MRP Oracle Purchasing Oracle Order Entry Oracle Work in Process Oracle General Ledger (Shell) Oracle Payable3.4 Internal Satellite SystemsThere is no HONGKONG TELECOM satellite system to be replaced in Option 1 Phase 1 implementation.3.5 ExtensionsIt is recommended that Hongkong Telecom should implement each of the Oracle application modules with minimal changes and/or modifications for OPTION 1, Phase 1. We have based this proposal on the assumption that the project team will make no changes to our applications modules except as delineated below. Listed below are the known custom extension requirements which are included in this proposal.Identified modifications included as part of this proposal: Vendor Lead Time Capture and Planning Total Landed Cost Capture and AssignmentOracle has also recognized minor functional enhancements required to meet HONGKONG TELECOM needs. These will be further analyzed during the Definition phase of the implementation project, and during the Build phase Oracle will work with HONGKONG TELECOM to design the most appropriate solution to fit the HONGKONG TELECOM needs.3.5.1 Vendor Lead Time ManagementHongkong Telecom has the requirement, which will be provided by a custom extension, to present the following functionality in Phase 1: Identification of the Lead Times per Item for each Vendor, and to have the Vendor ranked in order of preference. Automatic creation of requisitions when the available quantities in Inventory are not sufficient to satisfy demand. Automatic creation of requisitions based upon best match for the item promise date (on the order) when vendor lead time is taken into account. Automatic user notification if no Vendor can provide delivery of specific items to meet the Promise Date on the Order Lines.3.5.2 Total Landed Cost AssignmentHongkong Telecom has the requirement, which will be provided by a custom extension, to present the following functionality in Phase 1: Identification of algorithms, or percentages, that assign the values of Freight, Duty and Insurance to the item specific cost at time of receipt. Identification of these percentages for each Purchase Order Line. Providing defaults of these percentages based upon the item category for each Purchase Order Line. Ensuring that the percentages for all Purchase Order Lines, on one Purchase Order, exactly sum to 100%. The ability to record the Freight, Duty and Insurance costs associated with each inventory receipt and add these extra costs to the receipt cost of the particular item.3.5.3 Order EntryAt Order Entry Screen, it is required to give the user a sorting option in viewing the existing lots (drums) in descending order based on variance percentage (requested length vs available length).3.5.4 PurchasingUpon rejection of goods after receipt, give user a option to auto generate a debit memo. Oracle Alert should hold the payment for all the invoices with the matching PO item shipment line.3.5.5 Cable Stock Management SystemBest Fit Pick Process (Batch) - Start searching for all the shortest -length cables to meet the best fit (may be with acceptable tolerance %)3.5.6 Accounts PayablesRequirementsModification DescriptionAccounts Payables1.3.2.2Due DateThe system must be capable of selecting invoices for payment on the basis of a range of dates and the user may then pay all invoices selected or edit the selected invoices prior to initiating the payment process.You can only enter a due date in the payment selection, not a due date range.Provide another payment selection program, or change the existing program to allow enter due date range.1.4.1.2Alternate PayeeIn a number of instances suppliers have directed payment to be made to a third party at an address different from that of the supplier. The system must be capable of maintaining the necessary records to support an alternate payee. The system shall be able to settle all invoices of a vendor, including all redirected invoices from other vendors using the alternate payee function, in one single cheque in a payment cycle.You can store alternative payee name or use one of the contact person as alternative payee.Create a flag to indicate whether alternative payee will be used or not by descriptive flexfieldChange of the payment program to select alternative payee based on the flag.Another way is to create the alternative payee as a normal vendor in the systemUse descriptive flexfields to store the vendor code of the alternative payee.Change the payment program to use the alternative payee vendor details.1.5.3.2Invoice TrackingWith the functionality outlined in 1.5.3.1, the system must be capable of tracking the progress of the invoice by location and processing stage. This information should be accessible to users enquiring of the progress of the invoice.System should be able to record the name and location of the action officer who approve the invoice or perform invoice matching to PO.Descriptive Flexfields can be created to store the required informationCreate a new invoice inquiry function which allow user to enter criteria in the descriptive flexfields1.2.4.9Bank AccountsThe system shall be able to automatically assign the appropriate bank account for paying the invoices based on account code, amount and currency.The system should be able to perform the following :1. based on the account code to determine the type of expenses : CAPEX or OPEX2. There are specific bank accounts assigned for CAPEX and OPEX expenses respectively.3. For OPEX expenses, if the amount is less than a predefined amount (e.g. 1M), a particular bank account will be used. Otherwise, another bank account will be used.Program modifications :1. In bank account maintenance, add fields to specify whether the bank account will be used for OPEX and CAPEX and for what amount range.2. In invoice, store the information which can be used to determine the type of expenses (note that the account code structure may be changed so that it may be not able to use the account code to determine the type of expenses in future)3. In payment batch creation, user still need to specify they want to pay OPEX or CAPEX expenses and amount range by specifying the bank account4. Change the invoice selection program to provide the intelligent to base on the flag stored in the invoice to determine the type of expenses and amount range. It then select only those invoices for payment.3.6 InterfacesThe complex mix of existing legacy Satellite Systems, 25 systems recognized as internal and another 12 systems recognized as external to the logistics system, make interface development a critical part of the project. Oracle will not develop interfaces to Satellite Systems that are identified being stand alone systems . From information given to Oracle, the following internal satellite systems are standalone: Warranty Repair System Phone-card System Serialized Stock Tracking System Delivery Order Transmission system Stores Location System Equipment registration System Non- code Item Inventory Control System Petty Cash MRI Contract Information System Powerbase Purchasing SystemOracle will develop interfaces to external Satellite Systems as defined explicit in the RFP and as defined in the list below. The Oracle project manager together with the Hongkong Telecom project manager will manage the interface development process using Oracles interface development procedures. 3.6.1 System InterfacesOracle will develop forty (40) interfaces between internal and external Satellite Systems and the Oracle Applications. All interfaces will be file-to-file interfaces, not program-to-program interfaces. Data will be exchanged via a flat ASCII file. For outbound interfaces from Oracle Applications, Hongkong Telecom will specify the format of the file to be produced. The information to be provided must be available to the Oracle Applications. Oracle will create a file on the server where the Oracle Applications exist. These files will exist in a temporary holding area where Hongkong Telecom can pick up the file and transfer the data to other external systems if necessary. For interfaces that are inbound to the Oracle Applications, Oracle will specify the format in which the information is to be provided. Hongkong Telecom needs to provide the file to the server where the Oracle Applications exist. This format will be consistent with the application program interfaces (APIs) that are available for Oracle Applications.A list of interfaces by Oracle Application Module is provided below, along with an indication of the complexity of each interface. The cost and time to complete the interface work is based on the number of interfaces and the complexities. Interfaces may be added or removed during the Operations Analysis phase without any impact to cost or time to implement, provided the total number of interfaces and the complexity mix does not change. Any changes to the number or complexity mix of interfaces is outside the scope of the Phase I proposal.Interface PointInbound or OutboundOrigin and Destination SystemsComplexityAccount Code combinations from D&B General LedgerInboundD&B General Ledger to Oracle General LedgerMedium Account Journals from the GL InterfaceOutboundOracle General Ledger to.D&B General Ledger.Very HighShipment Details for Invoice creation within D&B Accounts ReceivableOutboundOracle Order Entry to D&B Accounts ReceivableHighReturn Material Authorization information for Credit Memo creation within D&B Accounts receivableOutboundOracle Order Entry to D&B Accounts ReceivableMediumCustomer Interface (including Credit Ratings)InboundD&B Accounts Receivable to Oracle Order EntryHighInvoice Information (Types, Terms etc.)InboundD&B Accounts Receivable to Oracle Order EntryMediumCable Stock InformationIn/OutboundCSMS to/from Oracle InventoryComplexStock Check InformationInboundStock checking informationto Oracle InventoryMediumRework phone trackingInboundRework phone tracking information from Oracle InventoryMediumScrap removal InformationInboundScrap information from Oracle InventoryMediumTransaction StoresInboundTransaction information from Oracle InventoryMediumBTBS project InformationInboundIssue ,receipt and return information from Oracle inventoryMediumReceipt InformationInboundInspection requirements from Oracle PurchasingMediumVendor InformationInboundVendor information to Oracle PurchasingMediumUtilities InformationInboundWater, Electricity payment Information to Oracle APMediumRent&Rates InformationInboundPayee Information to Oracle APMediumCheck Printing InformationIn/OutboundPrinting information to/ from Oracle APMediumArchive Data InformationInboundTracking Information From Oracle APMediumCurrency InformationOutboundCurrency Information to Oracle PurchasingMediumAvailable Item QuantityOutboundOracle Inventory to Complex DragonMediumAvailable Quantities and ATP informationOutboundOracle Inventory to Mobile Sale & Administration SystemMediumAvailable Quantities and ATP informationOutboundOracle Inventory to Point-of-Sale SystemMediumPurchase OrdersInboundMobile Sale & Administration System to Oracle PurchasingHighIssues, Receipts and Shipment/Reservation RequestsInboundPoint-of-Sale System to Oracle InventoryHighQuality Inspection TransactionsInboundQuality Inspection Management System to Oracle QualityLowPurchase Order Commitment InformationInboundPathfinder to Oracle PurchasingLowPurchase RequisitionsInboundSupplementary Material Control System to Oracle PurchasingMediumWork Order Information/Cable Stock RequestsOutboundOracle Service to Project Control SystemMediumStock Transfers and Work Order InformationInboundProject Control System to Oracle ServiceHighWork Order InformationInboundCL Works Order System to Oracle ServiceMediumItem Number, Available QuantityOutboundOracle Service to CL Works Order SystemMediumAutoClear for presented cheque for bank reconciliation purposeInboundBank of East Asia to Oracle Accounts PayableLowAutoClear for presented cheque for bank reconciliation purposeInboundHongKong Banks Hexagon to Oracle Accounts PayableLowAutocredit for payment purposeOutboundOracle Accounts Payable to HongKong BankMediumHR payment informationOutboundOracle Accounts Payable to Hong Kong Telecoms Payroll system which is Oracle PayrollMediumAP invoice import for mobile refund payment requestsInboundHong Kong Telecoms GSMIS to Oracle Accounts PayableLowForeign currency payment information for printing bank draftOutboundOracle Accounts Payable to World Link of CitibankMediumForeign currency payment information for payment in TTOutboundOracle Accounts Payable to Pay 2 system of Bank of AmericaMediumAP invoice import for civil works payment requestsInboundProject Control System to Oracle Accounts PayableLowProgram to control rollbacks of interfacesProgramLowOutbound interfaces from existing Hongkong Telecom legacy systems are the responsibility of Hongkong Telecom. Outbound interfaces from non-Oracle systems are the responsibility of those respective software and hardware vendors.Oracle will prepare detailed design specifications for the interfaces shown above. Hongkong Telecom will be required to review and sign-off on the detail design specifications for each interface, prior to the commenc