My Oracle Support Banner

Performance Issue With Query Security Record HRS_APP_SEC_VW (Doc ID 2761163.1)

Last updated on MARCH 17, 2021

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When using query security record HRS_APP_SEC_VW with delivered records , getting performance issues.

Here is a list of records containing the significant performance hit with HRS_APP_SEC_VW listed as the query security record:
PS_HRS_RCMNT
PS_HRS_APP_PROFILE
PS_HRS_APPINDX_CTL
PS_HRS_EVAL_CATG
PS_HRS_SCR_RSLT
PS_HRS_INT_STS
PS_HRS_APP_USA
PS_HRS_INT_SCHED
PS_HRS_APP_CL_ITEM
PS_HRS_RCM_INT
PS_HRS_EE_REF_JO
PS_HRS_INT_EVAL
PS_HRS_OFF_STS
PS_HRS_RCMNT_LTR
PS_HRS_APP_CHKLST
PS_HRS_INT_LTR
PS_HRS_JOBINDX_CTL
PS_HRS_APP_RTE
PS_HR_OFFER_SUB_WL
PS_HRS_INT_NOTE
PS_HRS_INT_ATCH
PS_HRS_JO_EXP

Changes

 

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