ITPub博客

首页 > 应用开发 > IT综合 > PR(请购单)不能approve 的原因探讨

PR(请购单)不能approve 的原因探讨

原创 IT综合 作者:moonsoft 时间:2019-07-08 11:06:05 0 删除 编辑

在别人的帮助下终于解决了一个离奇的PR不能approve问题.总结一下,顺遍总结一下不能approve PR的几种原因

[@more@]

这两天发生的离奇问题:

请购单(PR)不能核准(APPROVE)问题

在Oracle PO 的user开请购单的时候,当item ,数量,需求日, 会计科目都添好后,能够approve,但是状态始终不能变成approved. 而是incompleted.

开此单的user在PO里的employee 设置原先设置错了,我给改正过来可是还是不能核准.

有人说work-flow没有启动, they were probability right.

大家遇到过这种情况没有,指点一下什么原因.
不能每次此用户开PR我都手动用pl/sql update 状态吧
急啊

问题解决了,流程设置都没有错!

1.错的是原先负责PO的人建错了用户名
2.此人又胡乱修改过资料(hr_employees)
3.我建立了正确的用户名,可是设置权限的时候用了原先错误的用户名(设置权限的时候关联)

采取动作:
1.停掉错误的用户名
2.关联正确的

有的时候以前错误的资料,包括重新输入或乱改的真让人头疼

没有办法.积累经验吧

还有不能approve的原因:

1.rate 问题(手动update)

解决方法:

select po_header_id
from po_headers_all
where segment1='&1';

select rate,PO_DISTRIBUTION_ID
from po_distributions_all
where po_header_id = '&1'

update po_distributions_all
set rate = ''
where PO_DISTRIBUTION_ID = '&2';

SQL> select po_header_id
2 from po_headers_all
3 where segment1='&1';
Enter value for 1: 20502665
old 3: where segment1='&1'
new 3: where segment1='20502665'

PO_HEADER_ID
------------
63526

SQL> desc po_distributions_all;
Name Null? Type
------------------------------- -------- ----
PO_DISTRIBUTION_ID NOT NULL NUMBER
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER
PO_HEADER_ID NOT NULL NUMBER
PO_LINE_ID NOT NULL NUMBER
LINE_LOCATION_ID NOT NULL NUMBER
SET_OF_BOOKS_ID NOT NULL NUMBER
CODE_COMBINATION_ID NOT NULL NUMBER
QUANTITY_ORDERED NOT NULL NUMBER
LAST_UPDATE_LOGIN NUMBER
CREATION_DATE DATE
CREATED_BY NUMBER
PO_RELEASE_ID NUMBER
QUANTITY_DELIVERED NUMBER
QUANTITY_BILLED NUMBER
QUANTITY_CANCELLED NUMBER
REQ_HEADER_REFERENCE_NUM VARCHAR2(25)
REQ_LINE_REFERENCE_NUM VARCHAR2(25)
REQ_DISTRIBUTION_ID NUMBER
DELIVER_TO_LOCATION_ID NUMBER
DELIVER_TO_PERSON_ID NUMBER(9)
RATE_DATE DATE
RATE NUMBER
AMOUNT_BILLED NUMBER
ACCRUED_FLAG VARCHAR2(1)
ENCUMBERED_FLAG VARCHAR2(1)
ENCUMBERED_AMOUNT NUMBER
UNENCUMBERED_QUANTITY NUMBER
UNENCUMBERED_AMOUNT NUMBER
FAILED_FUNDS_LOOKUP_CODE VARCHAR2(25)
GL_ENCUMBERED_DATE DATE
GL_ENCUMBERED_PERIOD_NAME VARCHAR2(15)
GL_CANCELLED_DATE DATE
DESTINATION_TYPE_CODE VARCHAR2(25)
DESTINATION_ORGANIZATION_ID NUMBER
DESTINATION_SUBINVENTORY VARCHAR2(10)
ATTRIBUTE_CATEGORY VARCHAR2(30)
ATTRIBUTE1 VARCHAR2(150)
ATTRIBUTE2 VARCHAR2(150)
ATTRIBUTE3 VARCHAR2(150)
ATTRIBUTE4 VARCHAR2(150)
ATTRIBUTE5 VARCHAR2(150)
ATTRIBUTE6 VARCHAR2(150)
ATTRIBUTE7 VARCHAR2(150)
ATTRIBUTE8 VARCHAR2(150)
ATTRIBUTE9 VARCHAR2(150)
ATTRIBUTE10 VARCHAR2(150)
ATTRIBUTE11 VARCHAR2(150)
ATTRIBUTE12 VARCHAR2(150)
ATTRIBUTE13 VARCHAR2(150)
ATTRIBUTE14 VARCHAR2(150)
ATTRIBUTE15 VARCHAR2(150)
WIP_ENTITY_ID NUMBER
WIP_OPERATION_SEQ_NUM NUMBER
WIP_RESOURCE_SEQ_NUM NUMBER
WIP_REPETITIVE_SCHEDULE_ID NUMBER
WIP_LINE_ID NUMBER
BOM_RESOURCE_ID NUMBER
BUDGET_ACCOUNT_ID NUMBER
ACCRUAL_ACCOUNT_ID NUMBER
VARIANCE_ACCOUNT_ID NUMBER
PREVENT_ENCUMBRANCE_FLAG VARCHAR2(1)
USSGL_TRANSACTION_CODE VARCHAR2(30)
GOVERNMENT_CONTEXT VARCHAR2(30)
DESTINATION_CONTEXT VARCHAR2(30)
DISTRIBUTION_NUM NOT NULL NUMBER
SOURCE_DISTRIBUTION_ID NUMBER
REQUEST_ID NUMBER
PROGRAM_APPLICATION_ID NUMBER
PROGRAM_ID NUMBER
PROGRAM_UPDATE_DATE DATE
PROJECT_ID NUMBER
TASK_ID NUMBER
EXPENDITURE_TYPE VARCHAR2(30)
PROJECT_ACCOUNTING_CONTEXT VARCHAR2(30)
EXPENDITURE_ORGANIZATION_ID NUMBER
GL_CLOSED_DATE DATE
ACCRUE_ON_RECEIPT_FLAG VARCHAR2(1)
EXPENDITURE_ITEM_DATE DATE
ORG_ID NUMBER
KANBAN_CARD_ID NUMBER
AWARD_ID NUMBER(15)
MRC_RATE_DATE VARCHAR2(2000)
MRC_RATE VARCHAR2(2000)
MRC_ENCUMBERED_AMOUNT VARCHAR2(2000)
MRC_UNENCUMBERED_AMOUNT VARCHAR2(2000)
END_ITEM_UNIT_NUMBER VARCHAR2(30)
TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2(1)
RECOVERABLE_TAX NUMBER
NONRECOVERABLE_TAX NUMBER
RECOVERY_RATE NUMBER
OKE_CONTRACT_LINE_ID NUMBER
OKE_CONTRACT_DELIVERABLE_ID NUMBER

SQL> select rate,PO_DISTRIBUTION_ID
2 from po_distributions_all
3 where po_header_id = '&1';
Enter value for 1: 63526
old 3: where po_header_id = '&1'
new 3: where po_header_id = '63526'

RATE PO_DISTRIBUTION_ID
---------- ------------------
.071656 152210

SQL> update po_distributions_all
2 set rate = ''
3 where PO_DISTRIBUTION_ID = '&2';
Enter value for 2: 152210
old 3: where PO_DISTRIBUTION_ID = '&2'
new 3: where PO_DISTRIBUTION_ID = '152210'

1 row updated.

SQL> commit;

Commit complete.

2.所对应料号厂商不是合格供应商

解决方法,添加合格供应商

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/226700/viewspace-830505/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2005-01-20

  • 博文量
    412
  • 访问量
    334903