各位高手.我在关闭一个工单的时候出现了如下问题.其中在Transaction Summary里面包含一个Uncosted material Transactions.然后关闭工单出现错误.工单不能正常关闭.错误输出日志见下面.应该如何来处理呀?高手来指点:谢谢!

+---------------------------------------------------------------------------+

Oracle Work in Process: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

WICDCL module: Close Discrete Jobs

+---------------------------------------------------------------------------+

Current system time is 15-OCT-2007 13:28:01

+---------------------------------------------------------------------------+

===================================================================

Debug Mode :        Disabled

Output to Terminal : No

Argument Method :   Database Fetch

Trace Mode :        Disabled

===================================================================

Argument 1 (ORGANIZATION_ID) = 83

Argument 2 (CLASS_TYPE) =

Argument 3 (FROM_CLASS) =

Argument 4 (TO_CLASS) =

Argument 5 (FROM_JOB) =

Argument 6 (TO_JOB) =

Argument 7 (STATUS) =

Argument 8 (GROUP_ID) = 26996

Argument 9 (SELECT_JOBS) = 2

Argument 10 (ARG_EXCLUDE_RESERVED_JOBS) = 1

Argument 11 (ARG_EXCLUDE_UNCOMPLETED_JOBS) = NOT_DEFINED

Argument 12 (REPORT_TYPE) = 1

===================================================================

The following jobs failed the close process for the following reason:

There are transactions pending against these jobs.

7011933

+=================================================================+

sqlcaid =  sqlcode = %-ld  sqlerrml = %-d  sqlabc = 2053779232

sqlerrmc:

ORA-01403: no data found

sqlerrp =          sqlerrd[] = {0 0 0 0 0 0}

sqlwarn =           sqlext =

+=================================================================+

oracaid =          oracabc = 0

oracchf = 0   oradbgf = 0   orahchf = 0   orastxtf = 0   orastxtl = 0

orastxtc:

orasfnmc =   oraslnr = 0  orasfnml = 0

orahoc = 0  ormoc =  0  oracoc = 0  oranor = 0  oranpr = 0  oranex =  0

+=================================================================+

1253312,767

101,767

0 Job(s) were closed successfully

***** End Of Program - Close Discrete Jobs *****

+---------------------------------------------------------------------------+

Start of log messages from Plsql  program

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from PlSql program

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

Executing request completion options...

Finished executing request completion options.

+---------------------------------------------------------------------------+

Concurrent request completed

Current system time is 15-OCT-2007 13:28:06

+---------------------------------------------------------------------------+

1aaa.jpg

(72.35 KB, 下载次数: 17)

2007-10-15 13:37 上传