My Oracle Support Banner

Error In "iStore Search Insert Concurrent Program" Performance. (Doc ID 1293504.1)

Last updated on MARCH 21, 2018

Applies to:

Oracle iStore - Version and later
Information in this document applies to any platform.


When attempting to run the "iStore Search Insert Concurrent Program" the following error occurs:

"ORA-00001: unique constraint (IBE.IBE_CT_IMEDIA_SEARCH_U1) violated".

Concurrent Program Log
ORACLE error 1 in FDPSTP

 Cause: FDPSTP failed due to ORA-1: unique constraint
 ORA-6512: at "APPS.IBE_SEARCH_SETUP_PVT", line 323
 ORA-6512: at line 1

The issue can be reproduced at will with the following steps:
1) Set Profiles Options -
 "IBE: Category Set Filter for Product Search" = null  (blank)
 "IBE: Web Status Filter for Product Search" = All

2) Login as the iStore Concurrent Programs Responsibility - iStore Concurrent Programs -> iStore Search Insert


To view full details, 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 a vibrant support community of peers and Oracle experts.