My Oracle Support Banner

12.2 Upgrade Driver Patch Failes on Paypay.odf: The Index Cannot be Created as the Table has Duplicate Keys (Doc ID 2735539.1)

Last updated on OCTOBER 14, 2022

Applies to:

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

Symptoms

Problem Statement:
12.2 upgrade driver patch failes on paypay.odf

Worker log shows:


CREATE UNIQUE INDEX HR."PAY_LEGISLATIVE_FIELD_INFO_PK" ON
 HR.PAY_LEGISLATIVE_FIELD_INFO (TARGET_LOCATION, VALIDATION_NAME,
 FIELD_NAME, LEGISLATION_CODE, RULE_TYPE) LOGGING STORAGE (FREELIST GROUPS
 4 FREELISTS 4 ) PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
 TABLESPACE APPS_TS_SE

AD Worker error:
The index cannot be created as the table has duplicate keys.

 



 

Changes

 

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
Changes
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.