GPFRA: DSN MONTHLY Report Aborts When Run in PUM Environnement
(Doc ID 3053871.1)
Last updated on OCTOBER 21, 2024
Applies to:
PeopleSoft Enterprise HCM Global Payroll France - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
The DSN monthly process aborts in PUM 47, at step ADD_LOA_EMPLOYEES, 001, ADD_LOA_EE, DEL_LOA_EE_DSNWA
This is due to a missing space in the following SQL Delete: EMPLIDFROM
Before:
SQL.DELETE_EE Application AND %CASE[%PARM.RUN_CTL.GROUP_LIST_ID = ' '; EMPLID BETWEEN %PARM.RUN_CTL.FIRST_EMPLID AND %PARM.RUN_CTL.LAST_EMPLID; EMPLID IN
(SELECT X.EMPLIDFROM PS_GP_GRP_LIST_DTL X
After:
SQL.DELETE_EE Application AND %CASE[%PARM.RUN_CTL.GROUP_LIST_ID = ' '; EMPLID BETWEEN %PARM.RUN_CTL.FIRST_EMPLID AND %PARM.RUN_CTL.LAST_EMPLID; EMPLID IN
(SELECT X.EMPLID FROM PS_GP_GRP_LIST_DTL X
Steps to reproduce the issue:
1. Run DSN Monthly:
Global Payroll & Absence Mgmt > Social Security/ Insurance > Run DSN Monthly Extraction FRA > DSN Monthly Run Page
2. The process runs to No success.
3. Check the ViewLog/Trace and the process aborts in ADD_LOA_EMPLOYEES, 001, ADD_LOA_EE, DEL_LOA_EE_DSNWA
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 |
| Cause |
| Solution |
| References |