EPY: Retro Pay Going To Error With With SQLCODE Of : -180 in DB2/OS390 Environment
(Doc ID 2723134.1)
Last updated on NOVEMBER 16, 2020
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Retro Pay Going to error in a DB2/OS390 environment. Issue does not occur when running in DB2/Windows environment:
ERROR
-----------------------
SQL Stmt Data : SELECT A.SINGLE_CHECK FROM PS_COMPANY_TBL A WHERE A.COMPANY
=
:1 AND A.EFFDT=(SELECT MAX(V.EFFDT) FROM PS_COMPANY_TBL V W
H
ERE V.COMPANY=A.COMPANY AND V.EFFDT<=:2)
With SQLCODE Of : -180
With SQLERRM Of : *N
With SQLERRP Of : DSNXRIHB
With SQLERRD(1) Of : 00000135
With SQLERRD(2) Of : 00000000
With SQLERRD(3) Of : 00000000
With SQLERRD(4) Of : -00000001
With SQLERRD(5) Of : 00000000
With SQLERRD(6) Of : 00000000
Changes
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 |