E-ORA/UPG: During The Peopletools Upgrade, The INITIAL ALTER AUDIT Fails with ORA-31603 Error
(Doc ID 3066130.1)
Last updated on JANUARY 07, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.59 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run the INITIAL ALTER AUDIT during the Peopletools Upgrade from PT8.59 to PT8.61 from change assistance,
the following error occurs.
System Error : File: E:\PT859P11B_2206290502-retail\peopletools\src\psbld\bldcreat.cppSQL error. Stmt #: 2862 Error Position: 0 Return: 31603 - ORA-31603: object "PS_CSH_OFF_RECEIPT_MONERIS_ID" of type INDEX not found in schema "SYSADM"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_ME
Failed SQL stmt: SELECT DBMS_METADATA.GET_DDL('INDEX',:1) from dual
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_ME
Failed SQL stmt: SELECT DBMS_METADATA.GET_DDL('INDEX',:1) from dual
The issue can be reproduced at will with the following steps:
1. Run below sql to create an extra index for record CURRENCY_CD_TBL
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 |
| References |