WebCenter Interaction - Missing Triggers Can cause Failures in User Profile Sync (Doc ID 780276.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Interaction ID Service for LDAP - Version 1 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2014***

Symptoms

In cases where triggers are missing from a WCI Oracle Database, problems can arise in the LDAP profile sync. Users are initially created OK, however they are not properly added to the ptvgroupmembership table. The nature of the problem is such that no error is thrown during the account sync because everything appears to be working correctly.

When the profile sync job is run the error seen is - 

LDAP:Error Code 1

Changes

In order for the problem to occur, the triggers must have been removed directly from the database. This would not be done by the WCI application.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms