My Oracle Support Banner

Unable to Remove Some Images from Collections with "ORA-02292: integrity constraint (XXXXX_ADMINCAT.CC_CAT_IMAGES2_F) violated - child record found" Error (Doc ID 2439000.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Commerce Cloud Service - Version N/A and later
Information in this document applies to any platform.
Reported Version:


Unable to remove images from some collections. The following error is displayed on Admin UI.

Reproducible Steps:
1 In occs-admin, go to Catalog
2 Right click on the problem collection and Edit
3 Open 'Media' tab
4. Hover over the problem image and press 'x' to remove image.
5. "Remove Images" warming message is displayed, press 'Remove'  --> The error occurs.


The environment was upgraded to 18B recently.


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

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