壹佰网|ERP100 - 企业信息化知识门户

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 1948|回复: 0

[采购] Oracle EBS R12采购订单审批状态为“预审批”或"处理中"的处理方法

[复制链接]
发表于 2013/8/15 18:55:38 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622  。

您需要 登录 才可以下载或查看,没有帐号?注册

x
oracle SR上的文档ID 462695.1
当单据管理器故障原因为Doc Mgr Error 1(审批管理器超时)或Doc Mgr Error 2(单据审批管理器无效),审批过程将寄送单据管理器故障的通知给在工作流POERROR之工作流属性SYSADMIN_USER_NAME 配置的用户

使用这个脚本来确定通知及通知拥有者:

select recipient_role, subject from wf_notifications
where status = 'OPEN'
and message_type = 'POERROR'
and message_name = ' DOC_MANAGER_FAILED_SYSADMIN'
and subject like '%&document_number%';

由于Doc Mgr Error 3(其他例外在审批单据管理器代码)的单据管理器故障,通知可以发送给编制人(提交单据的人)或者单据所有者二者之一。


使用这个脚本来确定通知及通知拥有者:

select recipient_role, subject from wf_notifications
where status = 'OPEN'
and message_type = 'POERROR'
and message_name = 'DOC_MANAGER_FAILED'
and subject like '%&document_number%';

How to find additional error messages

When the purchase order or requisition approval workflow fails with a Doc Mgr Error 3 exception, the POERROR workflow will send a notification to the preparer or owner of the document. This notification will display additional error messages. These messages come from the SYSADMIN_ERROR_MSG workflow attribute that is populated by the purchase order or requisition approval workflow during its execution.

2. In order to see the errors via SQL*Plus, follow these instructions to obtain the value of the SYSADMIN_ERROR_MSG error message for a specific workflow:

2.1. Identify the workflow item type and item key for the document.

Requisition:

     SQL > select hr.name, prh.segment1, prh.wf_item_type, prh.wf_item_key
     from po_requisition_headers_all prh,
     hr_all_organization_units hr
     where prh.org_id = hr.organization_id and
     prh.segment1 = '&Enter_Req_Number';

Purchase Order:

     SQL > select hr.name, poh.segment1, poh.wf_item_type, poh.wf_item_key
     from po_headers_all poh,
     hr_all_organization_units hr
     where poh.org_id = hr.organization_id and
     poh.segment1 = '&Enter_PO_Number';

Purchase Order Release:

     SQL > select hr.name, poh.segment1, por.release_num, por.wf_item_type, por.wf_item_key
     from po_headers_all poh,
     po_releases_all por,
     hr_all_organization_units hr
     where poh.org_id = hr.organization_id and
     por.org_id = poh.org_id and
     poh.po_header_id = por.po_header_id and
     poh.segment1 = '&Enter_PO_Number' and
     por.release_num = '&Enter_Release_Num';

2.2. Run this script using the values retrieved from step 2.1 to see the SYSADMIN_ERROR_MSG value:

     select wiav.name attr_name,
     substr(nvl(wiav.text_value, nvl(to_char(wiav.number_value),to_char(wiav.date_value,'DD- MON-YYYY hh24:mi:ss'))),1,300) value
     from wf_item_attribute_values wiav,
     wf_item_attributes wia
     where wiav.item_type = '&item_type'
     and wiav.item_key = '&item_key'
     and wia.item_type = wiav.item_type
     and wia.name = wiav.name
     and wiav.name = 'SYSADMIN_ERROR_MSG'
     and wia.type <> 'EVENT';

3. Use the error messages to find possible solutions in this next table for your application release.

Most common issues for Release 11.5.10
Message name (sysadmin error message)
Workflow activity/Package
Comprenhensive list of known issues
Null (sysadmin error message is null)
Error might occur in any package that calls the document manager
POXDM-210: Subroutine poxdmaction() returned erro
POACA-870: Subroutine poacasetup() returned error
POACA-790: ORA-01403: no data found
VERIFY_APPROVER_AUTHORITY (Does Approver Have Authority?)
PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY

BUILD_DEFAULT_APPROVAL_LIST (Build Default Approval List)
PO_APPROVAL_LIST_WF1S.BUILD_DEFAULT_APPROVAL_LIST
POXDM-250: Subroutine poxdmaction() returned erro
POCUP-080: Subroutine pocupsupply() returned erro
POCUP-395: Subroutine rvsrq_po_req_supply() retur
RVSRQ-055: Subroutine rvspos_create_po_ship_suppl
RVSPO-163: ORA-01403: no data found
OPEN_DOC_STATE (Open document state)
PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE
POXDM-250: Subroutine poxdmaction() returned erro
POCUP-080: Subroutine pocupsupply() returned erro
POCUP-395: Subroutine rvsrq_po_req_supply() retur
RVSRQ-055: Subroutine rvspos_create_po_ship_suppl
RVSPO-161: ORA-08102: indexkey not found, obj# 3
OPEN_DOC_STATE (Open document state)
PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE
POXDM-250: Subroutine poxdmaction() returned erro
POCUP-080: Subroutine pocupsupply() returned erro
POCUP-395: Subroutine rvsrq_po_req_supply() retur
RVSRQ-125: Subroutine rvsutg_maintain_mtl_supply(
RVSUT-075: ORA-01403: no data found
OPEN_DOC_STATE (Open document state)
PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE
POXDM-270: Subroutine poxdmact ion() returned error
PODUS-090: Subroutine podus auths() returned error
PODUS-270: Unknown code:
PODUS-220: ORA-1403: no data found
APPROVE_DOC (Approve the PO)
PO_REQAPPROVAL_ACTION.APPROVE_DOC
POXDM-280: Subroutine poxdmaction() returned erro
RVSRQ-025: Subroutine rvspoa_approve_po() returne
RVSPO-000: ORA-01403: no data found
APPROVE_DOC (Approve the PO)
PO_REQAPPROVAL_ACTION.APPROVE_DOC
POXDM-280: Subroutine poxdmaction() returned error
RVSRQ-125: Subroutine rvsutg_maintain_mtl_supply()
RVTUQ-83: Subroutine UomConvert() returned error
Interclass conversion between UOM-1 and UOM-2 is not defined
APPROVE_DOC (Approve the PO)
PO_REQAPPROVAL_ACTION.APPROVE_DOC


Most common issues for Release 12 and 12.1
Message name (sysadmin error message)
Workflow activity/Package
Comprenhensive list of known issues
Null (sysadmin error message is null)
Error might occur in any package that calls the document manager
po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:60:po_req_supply returned false -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call.

APPROVE_DOC (Approve the PO)
APPROVE_REQ (Approve the Requisition)
PO_REQAPPROVAL_ACTION.APPROVE_DOC
po.plsql.PO_DOCUMENT_ACTION_AUTH.reject:210:po_req_supply returned false -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
REJECT_DOC (Reject The PO)
PO_REQAPPROVAL_ACTION.REJECT_DOC

po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_update_close_status:30:100 ORA-01403: no data found
po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_close_po:120:unexpected error in updating closed status -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
OPEN_DOC_STATE (Open document state)
PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE
po.plsql.DOCUMENT_ACTION_CHECK.authority_checks_setup:40:100ORA-01403: no data found - po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in authority_checks_setup -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
VERIFY_APPROVER_AUTHORITY (Does Approver Have Authority?)
PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY


您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|小黑屋|手机版|壹佰网 ERP100 ( 京ICP备12025635号 京ICP证120590号 )

Copyright © 2005-2012 北京海之大网络技术有限责任公司 服务器托管由互联互通
手机:13911575376
网站技术点击发送消息给对方83569622   广告&合作 点击发送消息给对方27675401   点击发送消息给对方634043306   咨询及人才点击发送消息给对方138011526

GMT+8, 2020/8/12 06:29 , Processed in 0.031540 second(s), 8 queries , MemCache On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表