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 JULY 17, 2024
Applies to:
Oracle Payroll - Version 12.1 and laterInformation 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
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:
- Apply the patch that contains pay_payroll_actions_tab.xdf.
- 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 |