Close Discrete Jobs工單有Pending Transactions也將工單關掉了？

albert.lgr

請大家幫忙看看如下問題，令我百思不得其解。


我所操作的EBS環境：Oracle Applications : 11.5.10.2

如下參數：Exclude Jobs with Pending Trans是設定為No，按照User Guide上面所述，Exclude Jobs with Pending Trans設定為No的話狀態會變為Failed Close。但是實際變為Close了。

Exclude Jobs with Pending Trans parameter provides the option to exclude or
include jobs with pending transactions during the close process.
If the value selected is Yes - jobs in this submission with pending
material, resource, move, or uncosted material transactions are ignored and will not
process.
If the value is set to No - jobs in this submission with pending
material, resource, move, or uncosted material transactions are included in the
process. The job status changes to Failed Close.


如下是處理日志（如下所有提示有Pending Transactions的工單都關閉了）:
+---------------------------------------------------------------------------+
Work in Process: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
WICDCL module: Close Discrete Jobs
+---------------------------------------------------------------------------+
Current system time is 23-MAY-2013 05:59:57
+---------------------------------------------------------------------------+
Page Length = 59, Page Width = 132
===================================================================
Debug Mode :        Disabled
Output to Terminal : No
Argument Method :   Database Fetch
Trace Mode :        Disabled
===================================================================
Argument 1 (ORGANIZATION_ID) = 479
Argument 2 (CLASS_TYPE) =
Argument 3 (FROM_CLASS) =
Argument 4 (TO_CLASS) =
Argument 5 (FROM_JOB) =
Argument 6 (TO_JOB) =
Argument 7 (FROM_RELEASE_DATE) =
Argument 8 (TO_RELEASE_DATE) =
Argument 9 (FROM_START_DATE) =
Argument 10 (TO_START_DATE) =
Argument 11 (FROM_COMPLETION_DATE) =
Argument 12 (TO_COMPLETION_DATE) =
Argument 13 (STATUS) =
Argument 14 (GROUP_ID) = 3910894
Argument 15 (SELECT_JOBS) = 2
Argument 16 (ARG_EXCLUDE_RESERVED_JOBS) = 1
Argument 17 (ARG_EXCLUDE_UNCOMPLETED_JOBS) = 2
Argument 18 (ARG_EXCLUDE_PENDING_TXN_JOBS) = 2
Argument 19 (REPORT_TYPE) = 4
Argument 20 (ACTUAL_CLOSE_DATE) = 2013/05/23 06:00:01
===================================================================
The following jobs failed the close process for the following reason:
There are transactions pending against these jobs.
ISAD02122B
IMAD03030A
ISAD04011B
ISAD04061B
ISPD04010B
IMAD04026A
ISAD04090B
ISAD04101A
ISAD04102A
ISAD04103A
ISAD04117A
ISAD04121B
ISAD04089B
ISAD04049B
ISAD04078B
IMAD04027B
ISAD04147B
ISAD04165B
ISAD04174B
ISAD05017A
LFF11305030
LFF11305031
LFF21305025
PBM135010PIB
PBM135000PIB
PBM135020PIB
ISAD05017B
ISAD05018A
ISAD05018B
ISAD05019A
ISAD04186B
LFO11305042
LFO11305045
LFF11305044
IMAD05009A
ISAD05023B
ISAD05025B
ISAD05068B
ISAD05074A
LFO11305058
LFO11305060
LFO11305061
LFO11305065
LFO11305066
LFO11305067
LFO11305068
+=================================================================+
sqlcaid =  sqlcode = %-ld  sqlerrml = %-d  sqlabc = 537166912
sqlerrmc:
ORA-01403: no data found
sqlerrp =          sqlerrd[] = {0 0 0 0 0 0}
sqlwarn =           sqlext =  
+=================================================================+
oracaid =          oracabc = 0oracchf = 0   oradbgf = 0   orahchf = 0   orastxtf = 2   orastxtl = 0
orastxtc:
orasfnmc =   oraslnr = 0  orasfnml = 0
orahoc = 0  ormoc =  0  oracoc = 0  oranor = 0  oranpr = 0  oranex =  0
+=================================================================+
0,212499
50390,212499104 Job(s) were closed successfully
***** End Of Program - Close Discrete Jobs *****
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
enter-->p_wcti_group_id: 53297835
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...Finished executing request completion options.Concurrent program returned no reason for failure.
+---------------------------------------------------------------------------+
Concurrent request completedCurrent system time is 23-MAY-2013 06:00:11
+---------------------------------------------------------------------------+

tiansoft68

是不是有BUG , 有pending的应该关不了的。

albert.lgr

tiansoft68 发表于 2013/5/29 14:28
是不是有BUG , 有pending的应该关不了的。

我也覺得是有Bug，因沒有Meta Link帳號現只能向大家求助，有沒有碰到過類似問題？

albert.lgr

這個問題不是經常會出現，偶爾會出現一次。之前用戶跟我提這個問題我還不太相信。但事實確實有這個情況。求解！

tiansoft68

我们用的R12, 没有碰到这种问题.

albert.lgr

tiansoft68 发表于 2013/5/29 17:21
我们用的R12, 没有碰到这种问题.

謝謝回復，期待有經驗的高手幫忙。