GPES: Error Integrity In Job Data (Doc ID 1593133.1)

Last updated on SEPTEMBER 01, 2015

Applies to:

PeopleSoft Enterprise HRMS Global Payroll Spain - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, General

When attempting to change the EFFDT in JOB data and then go to Update Contracts,
the following error occurs.

ERROR
-----------------------
No matching buffer found for level. (15,26)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query the records before make any change PS_WKF_CNT_TYPE, PS_CONTRACT_DATA, PS_JOB and PS_WKF_CNT_TYP_ESP and verify the EFFDT
2. Go to Workforce Administration-> Job Information-> Job Data
3. Search for employee KE0001 and make the change for EFFDT and save
4. Query the records after making the change PS_WKF_CNT_TYPE, PS_CONTRACT_DATA, PS_JOB and PS_WKF_CNT_TYP_ESP and verify the EFFDT. All the records except PS_WKF_CNT_TYP_ESP are updated
5. Now go to Workforce Administration-> Job Information-> Contract Administration-> Update Contracts and got the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot modify the EFFDT in correct history because one record got orphan rows.

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