GP UK - RTI Reconciliation Report - FPS And EPS Have Nil Heading. FPS Has Nil Payroll Data (Doc ID 2132011.1)

Last updated on APRIL 28, 2016

Applies to:

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

Symptoms

RTI reconciliation report, FPS and EPS have nil heading.  FPS has nil payroll data.
Also, RTI reconciliation report run to error:


SQL
error. Function: CreateSQL Error Position: 0 Return: 900 -
ORA-00900: invalid SQL statement Statement: ) FROM PS_GPGB_FPS_SUBMIT
WHERE PAY_ENTITY = :1 AND GPGB_TAX_BGN_YR = :2 AND PYMT_DT > =
TO_DATE(:3,'YYYY-MM-DD') AND PYMT_DT <= TO_DATE(:4,'YYYY-MM-DD') AND PYMT_DT
<= TO_DATE(:5,'YYYY-M M-DD') AND EXISTS (SELECT 'X' FROM PS_GPGB_EE_RSLT B
WHERE B.EMPLID = PS_GPGB_FPS_SUBMIT.EMPLID AND B.EMPL_RCD =
PS_GPGB_FPS_SUBMIT.EMPL_RCD AND B.CAL_RUN_ID = PS_GPGB_FPS_SUBMIT.CAL_RUN_ID) Original
Statement: ) FROM PS_GPGB_FPS_SUBMIT WHERE PAY_ENTITY = :1 AND
GPGB_TAX_BGN_YR = :2 AND PYMT_DT >= %DateIn(:3) AND PYMT_DT <=
%DateIn(:4) AND PYMT_DT <= %DateIn(:5) AND EXISTS (SELECT 'X'
Fatal
SQL error occurred. (2,125) GPGB_RTI_REC.PAY_FLD.GBL.default.1900-01-01.Step01.OnExecute
PCPC :5471 Statement:61
Process
161785 ABENDED at Step GPGB_RTI_REC.PAY_FLD.Step01 (PeopleCode) -- RC = 8 161785
GPGB_RTI_REC PAY_FLD Step01 PeopleCode 8

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