oracle信息化管理(英文版)

1、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 b

2、usiness 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 relativ

3、ely 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 t

4、ime 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

5、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 Deve

6、loper/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 rea

7、lize 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

8、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 Quot

9、ation 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

10、 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 ScopeOracle Applications Modules- Section 3.3Internal Satellite Systems- Section 3

11、.4Extensions- Section 3.5 Interfaces- Section 3.6Reports- Section 3.7Training- Section 3.9 Project Milestones- Section 3.10Project Organization- Section 3.11Project Gantt Chart andCritical Path- Section 3.12Project Team (Oracle and HKT)Resource Estimate- Section 3.13Key Deliverables- Section 14.23.2

12、.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 Or

13、acle 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

14、 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 testin

15、g 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 wh

16、at 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, i

17、f 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 u

18、nderstanding 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

19、 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

20、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 AlertOracle InventoryOracle Bill of MaterialsOracle ServiceOracle QualityOracle MPS/MRPOracle PurchasingOracle O

21、rder EntryOracle Work in ProcessOracle 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 applicati

22、on 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

23、this proposal.Identified modifications included as part of this proposal:Vendor Lead Time Capture and PlanningTotal 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

24、 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 pr

25、esent 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 requis

26、itions 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 req

27、uirement, 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 Purc

28、hase 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 in

29、ventory 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

30、.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 sho

31、rtest -length cables to meet the best fit (may be with acceptable tolerance %)3.5.6 Accounts PayablesRequirementsModification DescriptionAccounts PayablesDue 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 invoice

32、s 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.Alternate PayeeIn a number of i

33、nstances 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

34、 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 o

35、f 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

36、.2Invoice TrackingWith the functionality outlined in , 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 loca

37、tion 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 flexfieldsBank AccountsThe system shall be ab

38、le 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 :based on the account code to determine the type of expenses : CAPEX or OPEXThere are specific bank accounts assigned for CAPE

39、X and OPEX expenses respectively.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 :In bank account maintenance, add fields to specify whether the bank account will b

40、e used for OPEX and CAPEX and for what amount range.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)In payment bat

41、ch creation, user still need to specify they want to pay OPEX or CAPEX expenses and amount range by specifying the bank accountChange 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

42、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 t

43、o Satellite Systems that are identified being stand alone systems . From information given to Oracle, the following internal satellite systems are standalone: Warranty Repair SystemPhone-card SystemSerialized Stock Tracking SystemDelivery Order Transmission systemStores Location SystemEquipment regi

44、stration SystemNon- code Item Inventory Control SystemPetty CashMRIContract Information SystemPowerbase 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

45、 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 int

46、erfaces, 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 cr

47、eate 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

48、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

49、 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

50、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

51、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 Accoun

52、ts 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

53、, 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 Inve

54、ntoryMediumScrap removal InformationInboundScrap information from Oracle InventoryMediumTransaction StoresInboundTransaction information from Oracle InventoryMediumBTBS project InformationInboundIssue ,receipt and return information from Oracle inventoryMediumReceipt InformationInboundInspection req

55、uirements from Oracle PurchasingMediumVendor InformationInboundVendor information to Oracle PurchasingMediumUtilities InformationInboundWater, Electricity payment Information to Oracle APMediumRent&Rates InformationInboundPayee Information to Oracle APMediumCheck Printing InformationIn/OutboundPrint

56、ing 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 informationOu

57、tboundOracle 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 RequestsInbound

58、Point-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 Purchas

59、ingMediumWork 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 Quan

60、tityOutboundOracle 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 PayableLowAutocr