My Oracle Support Banner

GP UK - FPS Reconciliation Fails After Applying PG Loan DGI Changes (Doc ID 2503559.1)

Last updated on MARCH 09, 2020

Applies to:

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

Symptoms

RTI FPS rec process ending in error

cannot insert NULL into ("SYSADM"."PS_GPGB_REC_TAO1"."GPGB_DSGSED_PTD")
Disguised income fields and PG loan fields not added to FPS Rec process.
Has this been released in a seperate patch, or has it been missed?

Replication steps
==================
Run payroll
Run RTI FPS process

Error
========
File: /view/licai-85413-retail-slc05roj/vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1707 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_GPGB_REC_TAO1"."GPGB_DSGSED_PTD")
Failed SQL stmt: INSERT INTO PS_GPGB_REC_TAO1 (PROCESS_INSTANCE , EMPLID , CAL_RUN_ID , ......................................)
2019-01-29-05.54.17.309089 GetNextStateRecord [68] Exception logged: RC=3.

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
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.