Oracle Apps R12 Login page error

Issue:  When users try to login, gets below error

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.fnd.cache.CacheException;

Error Log shows

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 27, block # 183616)

ORA-01110: data file 27: '/oradata/testdata/ERPTEST/a_txn_data04.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option

Cause : Tablespace  holding wf table got corrupted. This issue will occur in cloned instance or any other instance.

Solution :

·         Verify the data file which has block corruption using DBV (dbverify)

·         Connect to APPS user using sqlplus and submit Concurrent program “Sync workflow local tables” from back end.

begin

    apps.wf_local_synch.BULKSYNCHRONIZATION(

        P_ORIG_SYSTEM=>'ALL',

        P_PARALLEL_PROCESSES=>2,

        P_LOGGING=>'LOGGING',

        P_RAISEERRORS=>TRUE,

        P_TEMPTABLESPACE=>'APPS_TS_TX_DATA');

END;

/

·         Restart application services.