Gather Schema Statistics Failed with “FDPSTP failed due to ORA-20005: object statistics are locked”

Error:
=========
ORACLE error 20005 in FDPSTP

Cause: FDPSTP failed due to ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at “APPS.FND_STATS”, line 805
ORA-06512: at line 1

Cause: Find the Table which statistics are locked by using below query.

select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;

Ex:
SQL> select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null;

OWNER TABLE_NAME STATT
—————————— —————————— —–
APPLSYS FND_LOB_ACCESS ALL

SQL>

Solution: Unlock the Tables which got locked

exec DBMS_STATS.UNLOCK_TABLE_STATS (‘OWNER’,’TABLE_NAME’);

Ex:

SQL> exec DBMS_STATS.UNLOCK_TABLE_STATS (‘APPLSYS’,’FND_LOB_ACCESS’);
PL/SQL procedure successfully completed.

It should resolve the issue.

Thanks
Reddy