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 APRIL 03, 2018

Applies to:

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


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


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