EPY: Budget Retro Distribution failing due to missing SQL object (Doc ID 622023.1)

Last updated on MAY 10, 2017

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 8 to 9.2 [Release 8 to 9]
Information in this document applies to any platform.

Information in this document applies to any platform.



SPECIFIC TO:   Enterprise, North American Payroll, Commitment Accounting, Release 8.x



This document was previously published as Customer Connection Solution 200764550


Symptoms


We received the following error when running Retro Distribution:
INSERT INTO PS_HPBDERNCH_TAO (PROCESS_INSTANCE , SETID , DEPTID , FISCAL_YEAR , POSITION_POOL_ID , SETID_JOBCODE , JOBCODE , POSITION_NBR , EMPLID , EMPL_RCD , EFFDT , EFFSEQ , BUDGET_LEVEL_INDC , ACCT_CD , HP_PRIOR_ACCT_CD , HP_PREV_EFFDT , HP_PREV_EFFSEQ , EFF_STATUS , PRIOR_EFF_STATUS) SELECT DISTINCT 415441 , SETID , DEPTID , FISCAL_YEAR , POSITION_POOL_ID , SETID_JOBCODE , JOBCODE , POSITION_NBR , EMPLID , EMPL_RCD , TO_DATE('1900-01-01','YYYY-MM-DD') , 0 , BUDGET_LEVEL_INDC , ACCT_CD , ' ' , HP_PREV_EFFDT , HP_PREV_EFFSEQ , ' ' , ' ' FROM PS_HP_BDGT_ERNCHG WHERE
Process 415441 ABENDED at Step HP_BGTRETDST.CHANGES.ERNSETD1 (SQL) -- RC = 921 (108,524)

It appears that we are missing SQL object HP_RETBDGT, therefore the final WHERE clause is incomplete.

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