EEX: An error message is being displayed when trying to get the employee profile for EMPLID with multiple JOB records via Travel and Expenses -> Update Employee profile. (Doc ID 972487.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

An error message is being displayed when trying to get the employee profile for EMPLID with multiple PS_JOB records via Travel and Expenses -> Update Employee profile

Replication Steps:
------------------
The issue can be reproduced at will with the following steps:

1. Please have an EMPLID have 2 job records in PS_JOB table.
2. Now navigate to Travel and Expenses -> Manage Employee Information -> Update Profile and search for the employee who has multiple job records.
3. Please note that the following error message will be displayed.

Error Message:
----------------
Hide: Row2 not found in Scroll Level 1. (2, 156) EX_EE_ORG_WRK.EMPL_RCD.ROW_INIT PCPC 583 Statement 13
The specified row number is invalid for the indicated scroll level. This may occur with various peoplecode buitl in functions that specify a row within a scroll.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view the employee profile of an employee who has more than one job record.

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