My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.