iStore - EBS (MOSC)

MOSC Banner

iStore Search Insert program error

edited Nov 4, 2016 4:09AM in iStore - EBS (MOSC) 5 commentsAnswered ✓

We are using EBS version 12.2.4

When run the Search insert program, we get the following error:

Cause: FDPSTP failed due to ORA-00953: missing or invalid index name

ORA-06512: at "APPS.IBE_SEARCH_SETUP_PVT", line 663

ORA-06512: at line 1.

I searched on the site and found note 1671997.1 which indicates that it might be a bug. But the error is not the exact error we have.

There is another note, 828915.1 indicates that exec ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM'); might need to run to update product. However this note indicates that it is for version from 11i to 12.1.3. I wanted to give it a try and see if this will work in 12.2.4 version. So, I follow the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center