R12: Upgrade : During Upgrade From 12.2.4 to 12.2.11 the Patch 31856789 Failed With Error "The table is missing the index PA_DRAFT_CONSOLIDATED_INV_U1"
(Doc ID 2967587.1)
Last updated on AUGUST 14, 2023
Applies to:
Oracle Project Billing - Version 12.2.4 and laterOracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.
Symptoms
During upgrade from 12.2.4 To 12.2.11,the patch 31856789 failed with error.
Below is the error from worker log.
Error:
The table is missing the index PA_DRAFT_CONSOLIDATED_INV_U1 or index PA_DRAFT_CONSOLIDATED_INV_U1 exists on another table.
Warning: Object "PA_DRAFT_CONSOLIDATED_INV_ALL" is not registered in table "FND_OBJECT_TABLESPACES".
CREATE UNIQUE INDEX PA."PA~DRAFT~CONSOLIDATED~INV~U1" ON
PA.PA_DRAFT_CONSOLIDATED_INV_ALL (BILL_GROUP_ID, DRAFT_INVOICE_NUM)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 255 COMPUTE STATISTICS ONLINE TABLESPACE APPS_TS_TX_IDX
AD Worker error: The index cannot be created as the table has duplicate keys.
Warning: Object "PA_DRAFT_CONSOLIDATED_INV_ALL" is not registered in table "FND_OBJECT_TABLESPACES".
CREATE UNIQUE INDEX PA."PA~DRAFT~CONSOLIDATED~INV~U1" ON
PA.PA_DRAFT_CONSOLIDATED_INV_ALL (BILL_GROUP_ID, DRAFT_INVOICE_NUM)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 255 COMPUTE STATISTICS ONLINE TABLESPACE APPS_TS_TX_IDX
AD Worker error: The index cannot be created as the table has duplicate keys.
STEPS:
The issue can be reproduced at will with the following steps:
1.Apply the upgrade patch.31856789
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 |
| References |