EGL9.2: Budget Check (FS_BP) Running Long On (FS_BP_BKOT.dEXPTN.Step01.S) SQL
(Doc ID 2913954.1)
Last updated on DECEMBER 07, 2022
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Budget check (FS_BP) running long on step (FS_BP_BKOT.dEXPTN.Step01.S) SQL since missing a bind for Process Instance.
Current SQL from the step:
DELETE
FROM PS_KK_EXCPTN_TBL
WHERE kk_tran_id = %Bind(FS_BP_WRK_AET.KK_TRAN_ID)
AND kk_tran_dt = %Bind(FS_BP_WRK_AET.KK_TRAN_DT)
AND kk_tran_ln NOT IN (
SELECT a.kk_tran_ln
FROM ps_kk_excptn_tbl a
, %Table(%Bind(KK_SRC_TRAN_AET.RECNAME_SRC_TAO, NoQuotes)) B
WHERE a.kk_tran_id = b.kk_tran_id
AND a.kk_tran_dt = b.kk_tran_dt
AND a.kk_tran_ln = b.kk_tran_ln
AND A.KK_TRAN_ID = %Bind(FS_BP_WRK_AET.KK_TRAN_ID)
AND A.KK_TRAN_DT = %Bind(FS_BP_WRK_AET.KK_TRAN_DT)
AND B.kk_skip_edits = 'Y')
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 |