Run Crediting Error -20202 : ORA-20202: ORA-01408: such column list already indexed (Doc ID 2168205.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When running crediting job for October 15, it shows as Running for 2 mins, goes into a status “Error-Auto Retry” and then goes to “Wait” status with a Scheduled time 10 mins from when it moves to Wait. And this cycle repeats continuously. Finally, it error.


ERROR
-20202 : ORA-20202: ORA-01408: such column list already indexed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms