等待关闭状态的工单无法关闭

luckyang12

直接在后台更改其状态
update wip_discrete_jobs
     set status_type = 4       -- 完成状态
     where wip_entity_id =

lhyin

原帖由 luckyang12 于 2009-3-17 14:49 发表
直接在后台更改其状态
update wip_discrete_jobs
     set status_type = 4       -- 完成状态
     where wip_entity_id =

把REQUEST_ID为空，再关闭下

larrywang

我们也碰到这样的问题,一直没有解决掉好.

那位高手帮忙一下,先谢谢了/

sensifree

Cannot Close A WIP Discrete Job [ID 158674.1]   

--------------------------------------------------------------------------------

  Modified 26-APR-2009     Type PROBLEM     Status PUBLISHED   

Checked for relevance 26-APR-2009




fact: Oracle Work in Process 11.5
fact: WICDCL - Close Discrete Jobs
symptom: Cannot Close A WIP Discrete Job
symptom: Job status remains in Pending Close
symptom: Unable to reprocess using Tools / Check Requests
symptom: APP-WIP-25191: 4 of 4 records failed.
symptom: You cannot change status of jobs. Either concurrent program exists
to close these jobs or jobs did not have status of Pending Close
change: NOTE ROLE: Navigation

Work in Processiscrete Jobs:Close Discrete Jobs
cause: Unwanted records in WIP_DJ_CLOSE_TEMP.



fix:

Ideally, step 1 mentioned below should suffice to re-submit the jobs in Pending
Close status and the rest of the steps are not required. If step 1 fails, for
any reason then run steps 2 and 3 to set the jobs to the original status,
delete the records from the WIP_DJ_CLOSE_TEMP table and then re-submit the jobs
again manually for closure.

If, for whatever reason, the concurrent process is interrupted or terminated,
records can get stranded in WIP_DJ_CLOSE_TEMP.  Since all of the records in
this table have status of 'Pending Close', no close routines have been called
and committed.  

Therefore, all you need to do is reset the job status from Pending Close to
its previous status in WIP_DISCRETE_JOBS and delete the record from
WIP_DJ_CLOSE_TEMP.  You will then need to rerun the discrete job closure.

1. Resetting the job status from Pending Close to its previous status.

1.1  Navigate to Cost/Discrete Jobs/Close Discrete Jobs (Form).
1.2  Select the job in question and hit the [Open] button.
1.3  Go to Tools -> close -> select "Check Requests 1".This puts the
      job back to the status it was in prior to attempting to close
      (i.e., Complete-No Charges Allowed) and clears out any records that may
      be erroneously stuck in the WIP_Discrete_Jobs_Close_Temp table that
      could prevent records from being processed.

2. Delete the records from WIP_DJ_CLOSE_TEMP.

2.1 To find out the current status of the records in WIP_DISCRETE_JOBS for
        the records existing in WIP_DJ_CLOSE_TEMP, run this script.

          select temp.wip_entity_id, temp.organization_id org_id,
          substr(temp.wip_entity_name,1,15) dj_name,
          substr(temp.status_type,1,8) tmp_status,
          substr(wdj.status_type,1,8) dj_status
          from wip_dj_close_temp temp, wip_discrete_jobs wdj
          where wdj.wip_entity_id = temp.wip_entity_id;

2.2 Delete the corresponding records from WIP_DJ_CLOSE_TEMP.

3. Rerun the Discrete Job Closure.

To resubmit for closure go to Special -> Close.  As long as the Inventory
Accounting Period for the next month is open, the charges will be put into
that month.

我是老猫2009

楼主，请问你的问题最后是怎么解决的呢？如知，麻烦告之，ths

690175528

我是老猫2009 发表于 2011-10-12 14:42
楼主，请问你的问题最后是怎么解决的呢？如知，麻烦告之，ths

工具>检查请求  会自动变为等待关闭前的状态

然后重新关闭就好了

demon_huo

pending close的情况应该是对应的current program还没跑,所以自然也不能冲新跑,该了状态 重新关是正解

scout

今天遇到同样问题。感谢上面楼主的提示。
语句：
update wip_discrete_jobs wdj
set    wdj.request_id ='',
       wdj.status_type = 4
where  wdj.wip_entity_id in （select we.wip_entity_id
                              from wip_entities we
                              where we.wip_entity_name in  ('job number','xxxxx','xxxxxx','xxxxxxx') ）
状态变成已完成，重新关闭即可。（我是用select   from for update 改的，上面语句是后总结的）

liangjunyong100

终极解决方案：
1.查找出来对应的工单
select
wdj.status_type,
wdj.* from wip_discrete_jobs wdj
where 1=1
and wdj.wip_entity_id  = &wdj.wip_entity_id
2.清除临时表数据
delete from  wip_dj_close_temp wct
where 1=1
and wct.wip_entity_id = &wct.wip_entity_id
3.修改工单状态
update wip_discrete_jobs
set status_type = 4
where status_type in (14, 15)
and WIP_ENTITY_ID=&WIP_ENTITY_ID
and date_closed is null;