错误信息：

WIP 成批装入请求中的警告：

Cannot read value for profile option RPM_CONC_PROCESS_ID in routine &ROUTINE.

也不知道是不是这个错误导致的。如果是因为这个错误，那么是不是两个工单都要成功，或者两个工单都失败？

但是结果是一个成功一个失败。

折腾我我整整一天，心情很郁闷。网上也找了WIP_MASS_LOAD 相关的资料也没有解决。

今天早上测试环境不能用。

等到10点多的时候，重新进去测试环境，发现另外一个工单也导入成功。

不知道是不是服务器或者应用端的问题。

看来很多事情不能一个人扛，还是需要开发，DBA 的给力支持。

记录工单导入的笔记：

WIP_JOB_SCHEDULE_INTERFACE:

LOAD_TYPE: We can perform multiple actions on a discrete job/schedule. LOAD_TYPE is used to specify the type of action you want to perform using WIP Mass Load program. Also it decides whether the interface table column is a requited or optional/derived column. 

 LOAD_TYPE Type of control 

 1 Create Standard Discrete Job 

 2 Create Pending Repetitive Schedule

 3 Update Standard or Non-Standard Discrete Job 

 4 Create Non-Standard Discrete Job 

 ALLOW_EXPLOSION: This column is used to determine whether the system uses the standard bills of material (BOM) and routing or a custom BOM and routing that you supply.

 If this flag is set to N or n, you must manually provide a custom BOM and routing; otherwise the system uses the standard BOM and routing.

 If Allow Explosion flag is set to Yes, either the start or completion date is used if the other date is null. If Allow Explosion flag set to No, and values are provided for both start and completion dates, the job is rescheduled from completion date (that is, it is backward scheduled). If Allow Explosion flag set to No, and either start or completion date is provided, the WIP Mass load program fails because the other date cannot be derived. 

The default value for the allow explosion flag is Yes.

GROUP_ID: This column is used to identify the batch of records that need to be processed for each run of the WIP Mass Load concurrent program. HEADER_ID: This column is used to determine individual job/schedule information in the interface table for a given group/batch. HEADER_ID used to link the header records with the detail records. 

PROCESS_PHASE: This will be used in combination with PROCESS_STATUS to identify the current status of the record in WIP_JOB_SCHEDULE_INTERFACE table. The default value we need to populate is validation(2).

 PROCESS_PHASE Meaning

 2 Validation 

 3 Explosion 

 4 Completion 

 5 Creation 

 PROCESS_STATUS: This will be used in combination with PROCESS_PHASE to identify the current status of the WIP Mass Load program. 

 PROCESS_STATUS Meaning 

 1 Pending 

 2 Running 

 3 Error 

 4 Complete

 5 Warning 

 Records should be inserted into the WIP_JOB_SCHEDULE_INTERFACE table with a PROCESS_PHASE = 2(Validation) and a PROCESS_STATUS = 1(Pending).

SCHEDULING_METHOD: This column is used for specifying the type of scheduling during the creation of the discrete job or repetitive schedule. The default value of SCHEDULING_METHOD is routing based (1). 

 SCHEDULING_METHOD Meaning 

 1 Routing-Based 

 2 Lead Time 

 3 Manual

STATUS_TYPE: This column is used to specify the status of the job while loading through WIP Mass Load program. You can create a job in any of the following status. 

 STATUS_TYPE Meaning 

 1 Unreleased 3 Released 4 Complete 5 Complete No Charge 6 On Hold

7 Cancelled 8 Pending Bill Load 9 Failed Bill Load 10 Pending Routing Load 11 Failed Routing Load 12 Closed 13 Pending- Mass Loaded 14 Pending Close 15 Failed Close

CLASS_CODE: If NULL on standard job creation uses default class from WIP parameters. Ignored on reschedule and derived for Repetitive schedules. If the value is NOT NULL, issues a warning message. If a wrong value specified for this column then WIP Mass Load program errors on records that fail validation. 

 INTERFACE_ID: This column is used for identifying each work order that is loaded individually.   

WIP_JOB_DTLS_INTERFACE:---导入工单明细的物料，工艺路线资源等信息。可以没有，没有的导入的工单工艺路线，物料要来源于BOM .(WJSI 表中：SCHEDULING_METHOD:1)

 The following are the controlled columns in WIP_JOB_DTLS_INTERFACE LOAD_TYPE: This is used to specify the type of modification you are planning against a Discrete Job or Repetitive schedule. Also LOAD_TYPE controls whether the interface table column is a requited or optional or optional/derived column. LOAD_TYPE Meaning 1 Loading a resource 2 Loading a component 3 Loading an operation 4 Loading multiple resource usage 5 Changing between primary and alternate resources 6 Load an operational link 7 Associate/Disassociate serial numbers 8 Dispatching resource instance 9 Loading a resource instance usage SUBSTITUTION_TYPE: This column is used to specify how you are modifying the job operation, resource or component. SUBSTITUTION_TYPE Meaning 1 Delete 2 Add 3 Change Any other values will cause an error.