Last updated on JUNE 01, 2017
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, Interfaces and Integrations
Direct Retro process abends with a SQL error
When running the Direct Retro Process (App Engine HP_DIRRETDST) and using the 'Chartfield Department' in the search criteria on the Run Control Page the following error occurs
File: e:\pt85410b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'DEPTID'.
Failed SQL stmt: SELECT A.COMPANY, A.PAYGROUP, (CONVERT(CHAR(10),A.PAY_END_DT,121)), A.OFF_CYCLE, A.PAGE_NUM, A.LINE_NUM, A.SEPCHK, A.ERNCD, A.FISCAL_YEAR, A.ACCOUNTING_PERIOD, A.ACCT_CD, A.BUDGET_DATA, A.ACCOUNT, A.DEPTID, A.POSITION_NBR, A.JOBCODE, A.EMPL_RCD, A.EARNINGS, A.CURRENCY_CD, A.POSITION_POOL_ID, (CONVERT(CHAR(10),A.EARNS_END_DT,121)), B.NAME, A.DEFAULT_FUND_OPTN, A.HP_DISTRIB_OVRRIDE FROM PS_PAY_ERN_DIST A, PS_PAY_CHECK B, PS_PAY_CALENDAR C WHERE A.EMPL_RCD = 0 AND B.EMPLID = '8002639' AND A.REVERSED = 'N' AND B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND B.PAY_END_DT = A.PAY_END_DT AND B.OFF_CYCLE = A.OFF_CYCLE AND B.PAGE_NUM = A.PAGE_NUM AND B.LINE_NUM = A.LINE_NUM AND B.SEPCHK = A.SEPCHK AND B.COMPANY = C.COMPANY AND B.PAYGROUP = C.PAYGROUP AND B.PAY_END_DT = C.PAY_END_DT AND C.CA_GL_INTFC_RUN = 'Y' AND B.PAYCHECK_STATUS <> 'R' AND A.HP_RETDIST_STATUS = '0' AND A.EARNS_END_DT BETWEEN '2015-07-01' AND '2015-07-15' AND B.BUSINESS_UNIT IN ('NDSU1') AND A.ACCT_CD IN (SELECT ACCT.ACCT_CD FROM PS_ACCT_CD_TBL ACCT WHERE ACCT.DEPTID = '2670' )
Process 2782520 ABENDED at Step HP_DIRRETDST.ERNWRKTB.GETERNS (Do Select) -- RC = 8010 (108,524)
The issue can be reproduced at will with the following steps:
1. Navigate to Payroll for NA> Payroll Distribution> Commitment Accounting USA> Process Direct Retro Dist
2. Use 'Chartfield Department' in the search criteria
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms