Patch 3480000 : Rel 11i : AP : Datafix script $AP_TOP/admin/sql/b702458f.sql (required for upgrade
Hi there
The background is that we are in the process of applying Patch #3480000 to upgrade our
Rel 11.5.9 environment to 11.5.10 (in preparation for the next upgrade to 12.1.1)
While applying the above Patch, the Worker for file 'povnd.odf' failed with :
The table is missing the index PO_VENDOR_SITES_U1
or index PO_VENDOR_SITES_U1 exists on another table.
Create it with the statement:
CREATE UNIQUE INDEX PO.PO_VENDOR_SITES_U1 ON PO.PO_VENDOR_SITES_ALL
(VENDOR_SITE_ID) LOGGING PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE
STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
AD Worker error:
The index cannot be created as the table has duplicate keys.
The background is that we are in the process of applying Patch #3480000 to upgrade our
Rel 11.5.9 environment to 11.5.10 (in preparation for the next upgrade to 12.1.1)
While applying the above Patch, the Worker for file 'povnd.odf' failed with :
The table is missing the index PO_VENDOR_SITES_U1
or index PO_VENDOR_SITES_U1 exists on another table.
Create it with the statement:
CREATE UNIQUE INDEX PO.PO_VENDOR_SITES_U1 ON PO.PO_VENDOR_SITES_ALL
(VENDOR_SITE_ID) LOGGING PCTFREE 0 INITRANS 11 MAXTRANS 255 COMPUTE
STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
AD Worker error:
The index cannot be created as the table has duplicate keys.
Tagged:
0