MRP-程式说明-20110816.pptVIP

解讀MCP CFM之confirm1 4) confirm程式指令使用oracle工具SQL loader.命令為sqlldr ,其中參數sqlldr/sqlldr為登入帳號及密碼,direct=true參數意思是直接載入資料,不產生任何日志,速度非常快,rows=50000表示導入50000行記錄才做一次commit,這也會提高導入速度.control=…,指定的文件中定義導入表和txt檔欄位的對應關系,以及導入資料方式(append,truncate,replace,insert) ,下圖為SQL*Loader處理邏輯: Control File The control file tells SQL*Loader how to interpret the data in the flat file. SQL*Loader pumps data into the database SQL*Loader reads data from a flat file. Flat File Bad File Discard File Datafile Datafile Datafile Records not meeting selection criteria are written to a discard file. Records that cause errors are written to a bad file. SQL*Loader Oracle Database software Log File Log of pump data into DB are written to log file. 解讀MCP Confirm之confirm1 5) Control File 說明(以load MCP_DEMAND_SUPPLY為例) Action Specifying the input file The old data of table process method(truncate or append or insert or replace). Specifying the table to load The fields of input file are terminate by what character (comma , tab and so on.). The fields mapping of input file and database table End TKS! QA * * * * * * * * * * * * * Author: Fandy Date: 2011/08/16 AcBel ERP system MRP 程式邏輯說明 MRP 執行流程 解讀 MCP00 解讀 AUTO_MCP.EXE 解讀MCP Confirm之程式confirm1 概述 Plan MO Suggest PR SAP R/3 SAP NT(BNT33) MRP 執行流程 R6(brs01) PI 1 2 每日凌晨1:00 Procedure MCP00 每日上午6:30 Unix JOB confirm1 MCP第一次(含buffer) 每日凌晨4:00 Delphi7 AUTO_MCP MCP第二次(無buffer) Delphi7 AUTO_MCP_ NO_BUF FTP(get) Delphi7 AUTO_MCP MCP第三次(含buffer) FTP(put) 3 4 5 6 8 7 10 9 delphi C_PUI503_BL …… 11 12 Open PR每日23:00 落點管理每日0:00 其它 2分鐘 BMRP2 解讀Procedure MCP00 BMRP2 每日凌晨1:00 Procedure MCP00 MCP00主要功能: 從數據庫BMRP2中讀取料號及BOM基本資料,以及目前OPEN之需求及供給面資料,並產生固定格式之text file 讀取DB中半成品及成品之Operation及Resource等,以利MCP排程用,並產生固定格式之text file(如上紅框內檔案,目前為舊功能,意義不大) 記錄程式是否執行成功,入table MCP_EXPORT,以利下步AUTO_MCP作判斷並執行 解讀Procedure MCP00 解讀Procedure MCP00 解讀Procedure MCP00 mcp03; SOF 注: 1. PM每天會在SAP上對業務訂單作落點管理,每晚12:00會自動(job)下傳R6, 此程式抓取T欄不為*號之