SJH'S BLOGsjh.blog.chinaunix.net

Make progress every day! 技术成就梦想! 欢迎大家一起来交流学习 ORACLE DBA & IBM小型机 & STORAGE & TSM/NBU & WAS & AS/400 & DB2 & NonStop系统管理方面的知识。

  • 博客访问: 1283571
  • 博文数量: 563
  • 博客积分: 10211
  • 博客等级: 上将
  • 技术积分: 4793
  • 用 户 组: 普通用户
  • 注册时间: 2006-08-27 14:56
文章分类

全部博文(563)

文章存档

2012年(9)

2011年(3)

2010年(7)

2009年(155)

2008年(256)

2007年(117)

2006年(16)

订阅
关于 2009-04-08 09:40:43

分类: Oracle

在跑'Synchronize Workflow LOCAL tables' request set的时候,request set完成的时候会在日志中报这样一个错:
ORA-20002: 4008: Originating system FND_RESP is hierarchy enabled and hence cannot participate in Bulk Synchronization.
全部日志如下:
+---------------------------------------------------------------------------+ Application Object Library: Version : 11.5.0 - Development Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. FNDWFLSC module: Synchronize WF LOCAL tables +---------------------------------------------------------------------------+ Current system time is 08-APR-2009 00:01:10 +---------------------------------------------------------------------------+ **Starts**08-APR-2009 00:01:10 **Ends**08-APR-2009 00:01:11 +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ ORA-20002: 4008: Originating system FND_RESP is hierarchy enabled and hence cannot participate in Bulk Synchronization. +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ Executing request completion options... Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 08-APR-2009 00:01:11 +---------------------------------------------------------------------------+ 后来在metalink上查到一篇资料,说这是FND的一个bug。原文描述如下:The Concurrent Program 'Synchronize WF LOCAL tables' is not supported currently for FND_USR and FND_RESP in Oracle Applications 11.5.10.
From an internal FND bug:3838586:
If the Applications module has a security hierarchy for role based access control, it is no longer possible to run the bulk synchronize concurrent program for that original system.
The warning message you are seeing is as per design. If the bulk synchronize concurrent program ran then currently the hierarchy information would be lost.






Therefore, Application modules are currently relying on the online incremental synchronization and this should suffice.
There is a post 11.5.10 project to support bulk synchronization hierarchy enabled original systems, but this is a fairly project that may take a while before this change is implemented.解决方法:As per Note:171703.1, FND patch 2254357 enables the incremental synchronization for Application module FND. 
If this patch is already installed then you should not need to run 'Synchronize Workflow LOCAL tables' for FND_USR and FND_RESP until bulk synchronization has been enhanced to support hierarchy enabled original systems.
Patch 2254357 is also included in FND patchsets from 11i.FND.G onwards.  It is also a pre-requisite patch for Workflow from 11i.OWF.G onwards.
Therefore, if you are seeing this warning message in 11.5.9 or 11.5.10, you should not run 'Synchronize Workflow LOCAL tables' for FND_USR and FND_RESP until further notice.
This limitation is to be fixed in 11.5.10.3CU.从metalink的解释可以看出EBS目前的应用模块都依赖于在线的增量同步,而这就足够了。
 
阅读(1928) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册