|
Subject: Bulk Sync Errors With ORA-20002: 4008: "Originating system FND_USR is hierarchy enabled" in Applications 11i
Doc ID: Note:292625.1 Type: PROBLEM
Last Revision Date: 24-DEC-2006 Status: PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Workflow Cartridge - Version: 11.5 to 11.5
This problem can occur on any platform.
Symptoms
An warning occurs when running request set: 'Synchronize Workflow LOCAL tables' as System Administrator responsibility:
The Request set completes with the following message on for FND_USR and FND_RESP with this error message in the log file:
ORA-20002: 4008: Originating system FND_USR is hierarchy enabled and hence cannot participate in Bulk Synchronization
Concurrent Request log file:
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 19-NOV-2004 07:46:30
+---------------------------------------------------------------------------+
**Starts**19-NOV-2004 07:46:30
**Ends**19-NOV-2004 07:46:30
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-20002: 4008: Originating system FND_USR is hierarchy enabled and hence cann
t participate in Bulk Synchronization.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
Cause
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.
Solution
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.
References
Note 171703.1 - 11.5.x: Implementing Oracle Workflow Directory Service Synchronization
|
