My Oracle Support Banner

Unable to drop this Index HR.PAY_PAYROLL_ACTIONS_PK Error While Loading pay_payroll_actions_tab.xdf (Doc ID 2489797.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payroll - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to apply the patch that contains pay_payroll_actions_tab.xdf, the worker job fails with the following error.

Index PAY_PAYROLL_ACTIONS_PK exists under HR schema.
Checking for differences
Column_name and Uniqueness match for both file and DB Indexes
ALTER INDEX HR.PAY_PAYROLL_ACTIONS_PK INITRANS 11 MAXTRANS 255
Start time for statement above is Thu Dec 06 08:05:31 EST 2018
End time for statement above is Thu Dec 06 08:05:31 EST 2018
Index Storage Altered Successfully.
Partition information for the index does not match the index in the database
DROP INDEX HR.PAY_PAYROLL_ACTIONS_PK
Start time for statement above is Thu Dec 06 08:05:31 EST 2018
Unable to drop this Index because there is a corresponding Constraint

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Apply the patch that contains pay_payroll_actions_tab.xdf.
  2.  Worker job fails loading pay_payroll_actions_tab.xdf.



Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.