POG Data Corruption: Update-insert Regression After Applying Patch 23606636 (Doc ID 2203351.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle HRMS (Netherlands) - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Whenever a datetracked update insert operation is performed on an assignment with future changes, the end_date field of the related PAF record in the PAY_OBJECT_GROUPS table gets corrupted, resulting in errors in the payroll processing.

STEPS

1. Login using NL HRMS Manager,
2. Datetrack to 01 October 2016 and create a future change in DT update mode (add grade):
3. Now datetrack to 01 September 2016 and do a DT update insert change (add collective agreement)
4. Now the PAY_OBJECT_GROUPS table looks like:
OBJECT_GROUP_ID SOURCE_ID SOURCE_TYPE START_DATE END_DATE PAYROLL_ID GROUP_DEFINITION_ID PARENT_OBJECT_GROUP_ID PERIOD_OF_SERVICE_ID
2198458 95340 PPF 01-08-2016 31-12-4712 1 2533434
2198459 112211 PAF 01-08-2016 30-09-2016 61 2198458
Where the end date on the PAF record is clearly wrong.

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