While Applying Patch 26639970_R12.JAI.B - Adworker Fails For File Jain87.odf
(Doc ID 2312390.1)
Last updated on SEPTEMBER 05, 2019
Applies to:
Oracle Financials for India - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to apply patch 26639970_R12.JAI.B, the following error occurs.
ERROR
-----------------------
The table is missing the index JAI_ITEM_TEMPL_DTLS_N1
or index JAI_ITEM_TEMPL_DTLS_N1 exists on another table.
Create it with the statement:
Warning: Object "JAI_ITEM_TEMPL_DTLS" is not registered in table "FND_OBJECT_TABLESPACES".
Start time for statement below is: Fri Sep 15 2017 11:44:11
CREATE INDEX JA.JAI_ITEM_TEMPL_DTLS_N1 ON JA.JAI_ITEM_TEMPL_DTLS
(TEMPLATE_DTL_ID) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 26639970_R12.JAI.B
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 |