Fusion Global Payroll: Extract Ends with Error - ORA-01502: index 'FUSION.PAY_OBJECT_ACTIONS_N1' or partition of such index is in unusable (Doc ID 2164549.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Global Payroll - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

All extracts that are been triggered are ending in error. The following error message is displayed:

"ORA-01502: index 'FUSION.PAY_OBJECT_ACTIONS_N1' or partition of such index is in unusable". The log file of one such failed extract (Payroll Flow: XX_BT_PAY_PENSION_REPORT_2016-07-22T12:41:11.111+01:00) have been attached.

The same message is displayed even when navigating to 'View Results' of already completed extracts.


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