My Oracle Support Banner

EPY: SSN Verification SQR Failed With ORA-01847: Day Of Month Must Be Between 1 And Last Day of month (Doc ID 2595557.1)

Last updated on OCTOBER 03, 2019

Applies to:

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

Symptoms


Customer is receiving the below error upon running  Employee SSN Verification Report (TAX109.sqr)

(SQR 5528) ORACLE OCIStmtExecute error 12801 in cursor 8:
ORA-12801: error signaled in parallel query server P001, instance hi-dm1-adm01-vm01.cherryroad.com:HIHP921 (1)
ORA-01847: day of month must be between 1 and last day of month

Error on line 384:
  (SQR 3723) Problem executing cursor.

SQR for PeopleSoft: Program Aborting.

Changes

 Recurrence was set for the Report to run at the end of the month, each month.

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