My Oracle Support Banner

GP: Updating Job Compensation Cleans The Field GP_SEG_TRGR.CAL_RUN_ID (Doc ID 2640106.1)

Last updated on MARCH 09, 2020

Applies to:

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

Symptoms

The field CAL_RUN_ID is getting blanked when we update the compensation. If the system is updating the calendar group ID on the GP_SEG_TRGR record this causes that GP will identify a segmenation mismatching when running a retro on top of the month, that may cause errors on the retro
delta calculation.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use an employee with compensation changed in the  middle of the month. Triggers are generated
2. Calculate payroll for that month and finalize
3. Change the compensation for the second segment. The triggers will be updated:
SELECT * FROM PS_GP_SEG_TRGR WHERE EMPLID LIKE 'xxxx'


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.