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 09, 2022

Applies to:

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

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