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 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.

Symptoms

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'

OR

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

Cause

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