Error: " ORA-02292: integrity constraint (SCHEMANAME.FK_HSP_HJOB_ST_UID) violated - child record found" When Deleting User from Planning Application (Doc ID 2219103.1)

Last updated on DECEMBER 30, 2016

Applies to:

Hyperion Planning - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

When migrating security Access Permissions with LCM, the following errors are encountered:

/Security/Access Permissions/Groups/<group_name>:- Errors occured during syncrhonization: [Cannot delete the following users: <username>., The following user already exists in this application: <username>.]

An error occurred executing query SQL_DELETE_USER with parameters [xxxxxx][[java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (<SCHEMANAME>.FK_HSP_HJOB_ST_UID) violated - child record found

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