ORA-29881: failed to validate indextype When Install 11i.ATG_PF.H.Delta.7 On : 11.5.10.2 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIE

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ORA-29881: failed to validate indextype When Install 11i.ATG_PF.H.Delta.7
On : 11.5.10.2 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES

When attempting to install 11i.ATG_PF.H.Delta.7
the following error occurs.

ERROR
-----------------------
package /u01/oracle/visappl/fnd/11.5.0/patch/115/sql/affileup.sql
Could not find any objects to create in package mode.

Unable to process file in PACKAGE mode.

Converting file for Invoker's Rights.
Source file: /u01/oracle/visappl/fnd/11.5.0/patch/115/sql/affileup.sql
Dest file: /u01/oracle/visappl/admin/VIS/out/p002invok.sql


sqlplus -s APPS/***** @/u01/oracle/visappl/admin/VIS/out/p002invok.sql
UPDATE fnd_lobs set file_name=REPLACE(REPLACE(REPLACE(file_name,
*
ERROR at line 1:
ORA-29881: failed to validate indextype

Symptoms:

11i.ATG_PF.H.Delta.7 [RUP7, patch#6241631] FAILED
On investigation found:
1. Number of invalid objects of APPS schema is 174
2. RA-04063: package body "APPS.FND_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_STATS"
ORA-06512: at line 3

Error in AD_CHECK_FILE_TEMP.

Log files:

adwork002.sql

Start time for file is: Tue Jun 15 2010 12:36:21

package /u01/oracle/visappl/fnd/11.5.0/patch/115/sql/affileup.sql
Could not find any objects to create in package mode.

Unable to process file in PACKAGE mode.

Converting file for Invoker's Rights.
Source file: /u01/oracle/visappl/fnd/11.5.0/patch/115/sql/affileup.sql
Dest file: /u01/oracle/visappl/admin/VIS/out/p002invok.sql


sqlplus -s APPS/***** @/u01/oracle/visappl/admin/VIS/out/p002invok.sql
UPDATE fnd_lobs set file_name=REPLACE(REPLACE(REPLACE(file_name,
*
ERROR at line 1:
ORA-29881: failed to validate indextype




Solution:


The error in file affileup.sql indicates a problem with the indexes.

Follow steps in note 73605.1 to rebuild the indexes.

References:

note 73605.1

Get Oracle Certifications for all Exams
Free Online Exams.com