My Oracle Support Banner

Error "ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, HR_SIGNON.INITIALIZE_HR_SECURITY, N, ERRNO, -1031, N, REASON, ORA-01031: insufficient privileges" when fetching Secured Views (Doc ID 2625011.1)

Last updated on DECEMBER 30, 2019

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Person / Assignment Issues

When executing the following statement as "apps" user in EBS environment
select * from apps.per_people_f, the following error occurs.

ERROR
-----------------------
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, HR_SIGNON.INITIALIZE_HR_SECURITY, N, ERRNO, -1031, N, REASON, ORA-01031: insufficient privileges
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.HR_SIGNON", line 28
ORA-06512: at "APPS.HR_SIGNON", line 631
ORA-06512: at "APPS.HR_SECURITY", line 2752


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try executing/fetching Secured Views . (Example apps.per_people_f,
  per_assignments_f,
  po_agents_name_v etc)
2. select * from apps.per_people_f
3. Getting above mentioned errors.

Note: Customer is claiming that the issue is coming after importing DB. The source DB is behaving normally. They did an export and import to another DB. The issue only happens on the imported DB.


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.