My Oracle Support Banner

'ORA-02292: Integrity Constraint (DOCKERDB_CONTAINER_5.FK_HSP_SEL_ITM_MBR) Violated - Child Record Found' Error While Trying To Delete Scenario Dimension Member (Doc ID 3026910.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version 24.03.55 and later
Information in this document applies to any platform.

Symptoms

While trying to delete a Scenario dimension member "Actual_Sep", the below error was observed.

[EPMServer0] [NOTIFICATION] [oracle.EPMHSP.fccs.DimensionEditorProcessor] [SRC_METHOD: deleteOwnershipInformationForScenario] Delete Member : Delete member from Scenario Actual_Sep with parent Scenario

[EPMServer0] [NOTIFICATION] [SRC_METHOD: executeUpdateInternal] An error occurred executing query DELETE FROM HSP_MEMBER WHERE MEMBER_ID = ? with parameters [54050][[

java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (XXXX.FK_HSP_SEL_ITM_MBR) violated - child record found

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:526)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.