EPY: COBOL Errors After Converting To Oracle 12G Database

(Doc ID 2417710.1)

Last updated on JUNE 29, 2018

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

On : 9.2 version, Payroll Technical

COBOL errors after converting to Oracle 12G database

Customer was converting their databases from Oracle 11.2.0.4 to Oracle 12.2.0.1.

During testing they received errors when running COBOL programs. They  recompiled and linked the COBOL programs. 

 

ERROR
-----------------------

EPO error pos=28

14:32:40.894 829 0.010 0.000 #1 RC=0 GETSTMT Stmt=PSPPYGRP_S_CALTB, length=387
14:32:40.895 830 0.000 0.000 #1 RC=0 COM Stmt=SELECT PAY_BEGIN_DT ,CHECK_DT ,PERIOD_WEEKS ,PAY_PERIOD ,PAY_PDS_PER_YEAR ,PAY_SHEETS_RUN ,PAY_CALC_RUN ,PAY_CONFIRM_START ,PAY_CONFIRM_RUN ,PAY_OFF_CYCLE_CLS ,SINGLE_CHECK ,ONCYCLE_PAY_END_DT ,DED_TAKEN ,DED_SUBSET_ID ,DED_TAKEN_GENL ,DED_SUBSET_GENL ,OFF_CYCLE_EE_DED ,CONFIRM_ERRORS ,ERR_PAY_END_DT ,GVT_CY_BEGIN FROM PS_PAY_CALENDAR WHERE COMPANY=:1 AND PAYGROUP=:2 AND PAY_END_DT=:3
14:32:40.896 831 0.000 0.000 #1 RC=0 Bind-1, type=SQLPBUF, length=3, value=NIU
14:32:40.897 832 0.000 0.000 #1 RC=0 Bind-2, type=SQLPBUF, length=3, value=CON
14:32:40.898 833 0.000 0.000 #1 RC=0 Bind-3, type=SQLPDTE, length=10, value=2018-04-15
14:32:40.899 834 0.000 0.000 #1 RC=0 SSB column=1, type=SQLPDTE, length=10
14:32:40.900 835 0.000 0.000 #1 RC=0 SSB column=2, type=SQLPDTE, length=10
14:32:40.901 836 0.000 0.000 #1 RC=0 SSB column=3, type=SQLPSSH, length=2
14:32:40.902 837 0.000 0.000 #1 RC=0 SSB column=4, type=SQLPBUF, length=1
14:32:40.902 838 0.000 0.000 #1 RC=0 SSB column=5, type=SQLPSSH, length=2
14:32:40.903 839 0.000 0.000 #1 RC=0 SSB column=6, type=SQLPBUF, length=1
14:32:40.904 840 0.010 0.000 #1 RC=0 SSB column=7, type=SQLPBUF, length=1
14:32:40.905 841 0.000 0.000 #1 RC=0 SSB column=8, type=SQLPBUF, length=1
14:32:40.906 842 0.000 0.000 #1 RC=0 SSB column=9, type=SQLPBUF, length=1
14:32:40.907 843 0.000 0.000 #1 RC=0 SSB column=10, type=SQLPBUF, length=1
14:32:40.908 844 0.000 0.000 #1 RC=0 SSB column=11, type=SQLPBUF, length=1
14:32:40.909 845 0.000 0.000 #1 RC=0 SSB column=12, type=SQLPDTE, length=10
14:32:40.910 846 0.000 0.000 #1 RC=0 SSB column=13, type=SQLPBUF, length=1
14:32:40.911 847 0.000 0.000 #1 RC=0 SSB column=14, type=SQLPBUF, length=10
14:32:40.912 848 0.000 0.000 #1 RC=0 SSB column=15, type=SQLPBUF, length=1
14:32:40.913 849 0.000 0.000 #1 RC=0 SSB column=16, type=SQLPBUF, length=10
14:32:40.913 850 0.000 0.000 #1 RC=0 SSB column=17, type=SQLPBUF, length=1
14:32:40.914 851 0.010 0.000 #1 RC=0 SSB column=18, type=SQLPBUF, length=1
14:32:40.915 852 0.000 0.000 #1 RC=0 SSB column=19, type=SQLPDTE, length=10
14:32:40.916 853 0.000 0.000 #1 RC=0 SSB column=20, type=SQLPBUF, length=1
14:32:40.918 854 0.000 0.000 #1 RC=0 EXE
14:32:40.919 855 0.000 0.000 #1 RC=0 Fetch
14:32:40.920 856 0.000 0.000 #2 RC=0 EPO error pos=28
14:32:40.921 857 0.000 0.000 #2 RC=0 Rollback
14:32:40.922 858 0.000 0.000 #2 RC=0 Disconnect
14:32:40.923 859 0.000 0.000 #1 RC=0 EPO error pos=28

Changes

 Upgrade database from 11G to 12G

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