EGL92: Cannot Drop the Index 'PS_HR_ACCTG_LINE.PS_HR_ACCTG_LINE', Because It Does Not Exist Or You Do Not Have Permission
Last updated on SEPTEMBER 12, 2017
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 DALVS315\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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms