iStore Search Insert program error
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