版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進行舉報或認(rèn)領(lǐng)
文檔簡介
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
2、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 relati
3、vely 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
4、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
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 Dev
6、eloper/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 re
7、alize 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 Quo
9、tation 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 exi
10、sting 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 Satel
11、lite 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 (
12、Oracle and HKT)Resource Estimate- Section 3.13· Key Deliverables- Section 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-ho
13、use 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
14、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
15、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:
16、 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
17、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
18、 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 th
19、e 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 testi
20、ng: 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 Phas
21、e 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 Satelli
22、te 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
23、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 Tim
24、e 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
25、 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 Ti
26、mes 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 t
27、he 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 extensio
28、n, 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 defaul
29、ts 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 an
30、d 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 PurchasingUpo
31、n 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 cabl
32、es 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 invoices selected or edit
33、 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 instances suppliers
34、 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 oth
35、er 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 prog
36、ram 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.Invoice Tracking
37、With 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 location of the action
38、 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 able to automaticall
39、y 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 e
40、xpenses 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
41、 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 bat
42、ch 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 sele
43、ct 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 interface
44、s 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·
45、; 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
46、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 Satell
47、ite 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 informa
48、tion 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.
49、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
50、(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
51、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.Interfa
52、ce 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
53、 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
54、(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 checkin
55、g informationto Oracle InventoryMediumRework phone trackingInboundRework phone tracking information from Oracle InventoryMediumScrap removal InformationInboundScrap information from Oracle InventoryMediumTransaction StoresInboundTransaction information from Oracle InventoryMediumBTBS project Informa
56、tionInboundIssue ,receipt and return information from Oracle inventoryMediumReceipt InformationInboundInspection requirements from Oracle PurchasingMediumVendor InformationInboundVendor information to Oracle PurchasingMediumUtilities InformationInboundWater, Electricity payment Information to Oracle
57、 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 Purchasin
58、gMediumAvailable 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 Ma
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- 小學(xué)四年級數(shù)學(xué)小數(shù)加減法計算題練習(xí)卷
- 電焊管道焊接技術(shù)
- 美食烹飪行業(yè)調(diào)味技巧培訓(xùn)實踐
- 物流行業(yè)倉儲管理心得總結(jié)
- 電影院服務(wù)員的服務(wù)技巧
- 印刷行業(yè)采購工作心得
- 文化傳媒推廣經(jīng)營合同三篇
- 五年級班主任期中工作總結(jié)培養(yǎng)學(xué)生的團隊合作精神
- 門診部熱情服務(wù)舒心就診工作總結(jié)
- 廣西賀州市八步區(qū)2023-2024學(xué)年六年級上學(xué)期英語期末試卷
- 【信息技術(shù)應(yīng)用能力提升工程2.0】A3演示文稿設(shè)計與制作 初中語文《雖有嘉肴》主題說明
- 爛尾樓工程聯(lián)建檢測與鑒定
- 乒乓球比賽第二階段對陣圖表
- 機制砂檢測報告
- 省教育廳檢查組接待方案
- 跌落測試(中文版)ISTA2A2006
- 氣動潛孔錘施工方案
- 云南省教育科學(xué)規(guī)劃課題開題報告 - 云南省教育科學(xué)研究院
- 人民法院涉訴信訪案件終結(jié)辦法
- S7-200 SMART_產(chǎn)品介紹PPT_20131104
- 大數(shù)據(jù)技術(shù)與應(yīng)用專業(yè)申請書
評論
0/150
提交評論