My Oracle Support Banner

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

Last updated on MAY 02, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.