The job has been failing recently with the following BG log error:
ERROR 2021-07-30 16:29:00,793 [Dispatch Investment Allocation : [email protected] (tenant=clarity)] niku.njs (clarity:admin__xxxxxxx:Investment Allocation) Error executing job: 6510145
SQL error code: 22924
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-22924: snapshot too old
This is an Oracle issue regarding the LOB corruption
The DBA will need to analyze the error of this type.
Here are possible resolutions:
1. Increase the parameter of UNDO_RETENTION
2. Use larger rollback segments.