My Oracle Support Banner

EPY: EMPL_COMP_SRCH4 Only Accesses Data for Employee's Current Company (Doc ID 617900.1)

Last updated on MARCH 17, 2021

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.


EMPL_COMP_SRCH4 only accesses data for employee's current Company.

Tax Update 03-B changed search view for many Payroll components to use EMPL_COMP_SRCH4.
We have no trouble accessing any of these employees in personal data, job, etc.  The problem appears when we attempt to view their payroll balances from a prior company.  If the employee's historical job rows have a
department in the historical company that is still active on the department table, we can view their balances.  However if their historical job rows only have departments which are currently inactive we can not view their
balances. All of the departments are on the current tree whether inactive or


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

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