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

Last updated on AUGUST 23, 2016

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.

Symptoms

EMPL_COMP_SRCH4 only accesses data for employee's current Company.

ISSUE1:
Tax Update 03-B changed search view for many Payroll components to use EMPL_COMP_SRCH4.
ISSUE2:
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms