ORA-01502: Index is in unusable state

Scenario:

After Moving the Index and Tables from APPS_TS_QUEUES tablespace to other and when open the forms to run a request it shows the following Error.

Error :

While compiling the flexfields, the procedure wf_event.raise failed with following
parameters:
event_name = oracle.apps.fnd.flex.dff.compiled
event_key = FND.$SRS$.FNDSCURS

The error raised is:

ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'APPLSYS.SYS_C00169351' or partition of such index is in unusable state

Solution:

=======

select index_name,status from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Now It shows the Index which are all unusable. So rebuild the following indexes by

select 'alter index 'owner'.'index_name' rebuild;' from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Note: This query shows the output to alter all the indexes that are unusable in the particular tablespace . SO take the outpu of the above query and save it as .sql and run the following sql to make it valid state. Now try running the concurrent Request