EGL92: Cannot Drop the Index 'PS_HR_ACCTG_LINE.PS_HR_ACCTG_LINE', Because It Does Not Exist Or You Do Not Have Permission
(Doc ID 2265551.1)
Last updated on JANUARY 03, 2023
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
During an upgrade receive the error - Cannot drop the index [record name.index name] because it does not exist or you do not have permission - examples below:
'DROP INDEX PS_HR_ACCTG_LINE.PS_HR_ACCTG_LINE
Msg 3701, Level 11, State 7, Server XXXXXXX\PS, Line 1
Cannot drop the index 'PS_HR_ACCTG_LINE.PS_HR_ACCTG_LINE', because it does not exist or you do not have permission'
In Application Designer see the following error:
Error: HR_ACCTG_LINE - SQL Error. Error Position: 0 Return: 601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot drop the index 'PS_HR_ACCTG_LINE.PS_HR_ACCTG_LINE', because it does not exist or you do not have permission
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