ETL9.1: Year End Online Checks Using Time and Labor Filters Fails (Doc ID 1964602.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 and later
PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Online Check process Failing

Remote program PSPPYBLD failed with return code: 1400 .Reason: ORA-01400: cannot insert NULL into ("SYSADM"."PS_PAY_MESSAGE"."PAY_END_DT").

ERROR
-----------------------
PSAPPSRV.5697 (15) [2014-12-29T19:35:02.817 00008084354@172.26.28.162 (CHROME 39.0.2171.95; WINXP) ICPanel](0) Remote program PSPPYBLD failed with return code: 1400 .Reason: ORA-01400: cannot insert NULL into ("SYSADM"."PS_PAY_MESSAGE"."PAY_END_DT"). In section: SQLRT: EXECUTE-STMTPROCESS-PAY-MSGXA100-INSERT-MSGS (INSERT)CALL-PSPLDTL2CHK EXISTING PAYSHEETS(PSPLDTLG). Check log file: /app/ps/conf/hrfix/appserv/hrfix/LOGS/PSPPYBLD_00008084354_1229193502.out in App Server for more info. Check log file: /app/ps/conf/hrfix/appserv/hrfix/LOGS/PSPPYBLD_00008084354_1229193502.out in App Server for more info (2,-1) FUNCLIB_PAY.RETURN_CD.FieldFormula Name:emulate_paysheet PCPC:7439 Statement:149
Called from:PAY_OL_US_SRCH.PAY_END_DT.RowInit Statement:72
PSAPPSRV.5697 (15) [2014-12-29T19:35:02.825 00008084354@172.26.28.162 (CHROME 39.0.2171.95; WINXP) ICPanel](0) An error has occurred which prevents this transaction continuing


The issue can be reproduced at will with the following steps:
1. Run Online Check
2. After checking YES on LOAD AVAILABLE TIME from TIME AND LABOR
3. Process fails

The issue has the following business impact:
Due to this issue, users cannot do an online check.

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