Cause: FDPRRC failed due to ORA-01654: unable to extend index APPLSYS.FND_CONCURRENT_REQUESTS_N4 by 16 in tablespace APPS_TS_TX_IDX

Users are complaining that they request's are not completing and getting below error.

Error in Concurrent manager logfile *:--
------------------------------------------------
Cause: FDPRRC failed due to ORA-01654: unable to extend index APPLSYS.FND_CONCURRENT_REQUESTS_N4 by 16 in tablespace APPS_TS_TX_IDX

Cause:tablespace APPS_TS_TX_IDX is 100%.Please resize or add a datafile to to tablespace
according the situation.

TABLESPACE_ AVAIL USED FREE Used % FREE_PC Required MB
----------- ---------- ---------- ---------- ------- ------- -----------
APPS_TS_TX_ 343452 343452 0 100.00 0.00 60609.1765

IDX

Solution*:-
SQL> alter database datafile '+EBSTEST1_DATA/DATABASE/datafile/apps_ts_tx_idx.732.824471231' resize 7200m;

Database altered.


SQL>

Thanks for visiting my blog.!!!!!!!!!!!!!!!!!