My Oracle Support Banner

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.

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

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.