po 无法审批 请教

renxiang

看看这些有问题的单据是不是固定的某些用户操作的，如果是可能就和用户的设置有关。

kui

yes, you should check the setup of the employee and user who create po doucment.

which version your application is?
if your app is 11.5.9, first you should run Synchronize WF LOCAL tables request by the system administrator responsiblility, then find error processes and retry.

icesoft

app  ver 11i
审批人更换过，但更换之前也有类似错误。例如：单据管理器未能向系统管理员发出通知。
po的创建人有很多，都有过这类错误。迷茫：（

icesoft

再顶

liuf19780320

能贴出英文的错误提示吗

icesoft

Document Manager failed to sysadmin
metalink 上给出的solution 都是 retry
retry 之后 有一个 exception  
问题依旧

liuf19780320

The solution is to set these attributes via the workflow builder.

Utilize the workflow builder to connect to the database followed by a load of
the 'PO Error' workflow item type.

Once the PO Error workflow process is loaded, please move to the 'PO Approval
Error' and then to the 'Item Attributes' section. You will need to find the 3
attributes - Timeout Value, System Administrator User Name, Auto Retry for
Document Manager.   

These attributes should be set to the appropriate values. By double clicking on
the attribute a properties screen will appear - which at the bottom has a
section for 'Defaults'.  In the value column - enter the appropriate value.

Ex. Timeout Value = 300
    System Administrator User Name = SYSADMIN
    Auto Retry for Document Manager = 10

Setting up the values will ensure the new PO Error process can run smoothly
when the document manager goes down or encounters an error condition.

For the Purchase Orders which are stuck in process, the following sql can be
executed:

select item_type, item_type_display_name, item_key, activity_label from
wf_item_activity_statuses_v
where item_type = 'POAPPRV'
and activity_name = 'OPEN_DOCUMENT_STATE'
and activity_result_display_name not in ('Activity Performed')
and activity_result_code = '#EXCEPTION';

This will assist in locating Purchase Order processes which have failed due to
the attributes above not being set.

It is possible to update item attributes for the given workflow processes which
are in error via the following:
1. Login as the workflow administrator.
2. Choose the Responsibility - Workflow Administrator For Web Applications
3. In the Submenu choose - Find Processes
4. Select the PO Approval process from the list of values and then enter the
   item key returned from the sql above into the appropriate label.
5. Hit the Find button - this will return both the Approval process and the
   Approval Error handling sub process.
6. Choose the Error Handling sub process - usually an item key of WF#####.
7. After the action is on the Workflow Error process, choose View Diagram
8. The diagram will appear - and at the bottom right is a button labeled
   Item Attributes - please select this button.
9. Locate the item attributes mentioned above and enter the appropriate values.
10. Click on the activity in the diagram where the workflow has stopped - it is
    where the green line ends.
11. Choose the 'Expedite' button - and then select 'Retry' from the modal window
12. Wait a moment - the workflow should now have advanced via representation of
    the green line - as the attributes are now set for the workflow generated by
    the Purchase Order Approval in question.
13. This would have to be done for all records returned in the above query.

If there are a large number of records which require this type of processing,
please raise a tar via metalink so Oracle Support Services can assist in
delivering a script that will reset the Purchase Order Approval process so the
users can take the Approval actions again.  The attributes should be updated
prior to the re-attempt of the Approval Process.

icesoft

已经试过metalink 的 solution , 问题依旧。
看样子只能cacell掉，重新create 了。
谢谢大家

happily

采购订单状态是未完成，还是处理中 。
如果提交审批后还是未完成，应该是没有提交到上级那里，是审批层次结构问题。

icesoft

还是处理中，如果是未完成就好办了。呵呵