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

zbqboqiang

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	Note 1310935.1
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	Note 782911.1
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	Note 1252697.1
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	Note 1298629.1
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	Note 316450.1
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	Note 754953.1
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	Note 1318724.1
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	Note 374099.1

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	Note 1310935.1
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	Note 1304639.1
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	Note 1116134.1
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	Note 867855.1
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	Note 1073703.1