Primavera Gateway Error "Integrity Constraint (GATEWAYUSER.FLOWSTEPINST_FLOWSTEP_FK) Violated" Occurs When Trying To Remove Installed Customization

(Doc ID 2206740.1)

Last updated on JANUARY 24, 2017

Applies to:

Primavera Gateway - Version 16.1.0.1 to 16.2.0.0 [Release 16.1 to 16.2]
Information in this document applies to any platform.

Symptoms

When attempting to remove a Gateway provider customization, the following error occurs.

ERROR
-----------------------
ORA-02292: integrity constraint (GATEWAYUSER.FLOWSTEPINST_FLOWSTEP_FK) violated - child record found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Gateway configuration utility.
2. Choose Manage Customizations.
3. Check the box in the Remove column and then click Update to remove the customization.

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