GPES: Error Building GPES_ERE_BRD_VW View - "Expected Tokens May Include: "CORRELATION NAME". SQLSTATE=42601" (Doc ID 1946805.1)

Last updated on JUNE 21, 2016

Applies to:

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

Symptoms

On : 9.1 version, General

We are getting below error while executing createvw.dms script for only 2 views.

ERROR
-----------------------
Creating View GPES_ERE_BRD_VW
 - SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0104N An unexpected token "" was found following "". Expected tokens may include: "CORRELATION NAME". SQLSTATE=42601
 (SQLSTATE 42601) -104
 
 CREATE VIEW Z1HRA02$.PS_GPES_ERE_BRD_VW (EMPLID, EMPL_RCD, GPES_MONTH_END_DT, GPES_MONTH_BGN_DT, GPES_SSTC_DAYS, GPES_TOT_CNTB_DAYS, GPES_SSTC_AMOUNT, GPES_TOT_CNTB_BSCC) AS SELECT EMPLID , EMPL_RCD , GPES_MONTH_END_DT , GPES_MONTH_BGN_DT , GPES_SSTC_DAYS , CONTRIB_DAYS_ESP , GPES_SSTC_AMOUNT , CONTRIB_BASE_ESP FROM ( SELECT RS1.EMPLID , RS1.EMPL_RCD , SY.GPES_MONTH_END_DT , SY1.GPES_MONTH_BGN_DT , MAX(RS1.CONTRIB_DAYS_ESP) GPES_SSTC_DAYS , SUM(RS2.CONTRIB_DAYS_ESP) CONTRIB_DAYS_ESP , MAX(RS1.CONTRIB_BASE_ESP) GPES_SSTC_AMOUNT , SUM(RS2.CONTRIB_BASE_ESP) CONTRIB_BASE_ESP FROM PS_GPES_CNTRB_RSLT RS1 , PS_GPES_CNTRB_RSLT RS2 , PS_GPES_SYS_CALEND SY1 , PS_GPES_SYS_CALEND SY WHERE RS1.EMPLID = RS2.EMPLID AND RS1.EMPL_RCD = RS2.EMPL_RCD AND RS1.EFFDT BETWEEN SY1.GPES_MONTH_BGN_DT AND SY1.G
Error: Unable to process create statement for GPES_ERE_BRD_VW
Views remaining: 14352
Creating View GPES_ERE_TER_VW
 - SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0104N An unexpected token "" was found following "". Expected tokens may include: "CORRELATION NAME". SQLSTATE=42601
 (SQLSTATE 42601) -104
 
 CREATE VIEW Z1HRA02$.PS_GPES_ERE_TER_VW (EMPLID, EMPL_RCD, GPES_MONTH_END_DT, GPES_MONTH_BGN_DT, GPES_SSTC_DAYS, GPES_SSTC_AMOUNT) AS SELECT EMPLID , EMPL_RCD , GPES_MONTH_END_DT , GPES_MONTH_BGN_DT , CONTRIB_DAYS_ESP , CONTRIB_BASE_ESP FROM ( SELECT RS1.EMPLID , RS1.EMPL_RCD , SY1.GPES_MONTH_END_DT , SY1.GPES_MONTH_BGN_DT , SUM(RS1.CONTRIB_DAYS_ESP) CONTRIB_DAYS_ESP , SUM(RS1.CONTRIB_BASE_ESP) CONTRIB_BASE_ESP FROM PS_GPES_CNTRB_RSLT RS1 , PS_GPES_SYS_CALEND SY1 WHERE RS1.EFFDT BETWEEN


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run datamover script createvw.dms
2. Get error


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