ETL9.1: PY_PULL_COST Process Hangs On TL_DIST_DIL.ACCT_DT.STEP20 (SQL) (Doc ID 1294823.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
Add ***Checked for relevance on 03-Jul-2014***

Symptoms


On : 9.1 version, Pull Costs/Distribution
The process hangs on step TL_DIST_DIL.ACCT_DT.Step20 (SQL)

INSERT INTO PS_TL_COM_DEPT_W4 (PROCESS_INSTANCE , XREF_NUM , EMPLID ,
EMPL_RCD , SEQ_NBR , DUR , PAY_END_DT , PAY_BEGIN_DT , COMPANY , PAYGROUP ,
DEPTID , COMMIT_ACCTG_FLG , ACCOUNTING_DT) SELECT B.PROCESS_INSTANCE ,
B.XREF_NUM , B.EMPLID , B.EMPL_RCD , B.SEQ_NBR , B.DUR , A.PAY_END_DT ,
A.PAY_BEGIN_DT , A.COMPANY , A.PAYGROUP , D.DEPTID , D.USE_DISTRIBUTION ,
A.ACCOUNTING_DT FROM PS_TL_ACCTDT_WRK4 A , PS_WRK_XREF_CALC4 B , PS_JOB C ,
PS_DEPT_TBL D WHERE B.PROCESS_INSTANCE=6277 AND A.PROCESS_INSTANCE=6277 AND
A.XREF_NUM=B.XREF_NUM AND B.EMPLID='00021274' AND B.EMPL_RCD=0 AND
B.DUR=TO_DATE('2010-12-28', 'YYYY-MM-DD') AND C.EMPLID='00021274' AND
C.EMPL_RCD=0 AND C.EFFDT= ( SELECT MAX(C1.EFFDT) FROM PS_JOB C1 WHERE
C1.EMPLID='00021274' AND C1.EMPL_RCD=0 AND C1.EFFDT<=TO_DATE('2010-12-28',
'YYYY-MM-DD')) AND C.EFFSEQ=( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE
C2.EMPLID='00021274' AND C2.EMPL_RCD=0 AND C2.EFFDT=C.EFFDT) AND
C.SETID_DEPT=D.SETID AND C.DEPTID = D.DEPTID AND D.EFFDT=( SELECT
MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D1.SETID=D.SETID AND
D1.DEPTID=D.DEPTID AND D1.EFFDT<=TO_DATE('2010-12-28', 'YYYY-MM-DD'))

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