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 126.96.36.199.000 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!