EAP: Period End Accrual only selects Voucher that meet all Options Criteria
(Doc ID 2421948.1)
Last updated on MAY 11, 2023
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
Would like the Period End Accruals process to pick up any Vouchers that meet one of the following criteria:
1. Unapproved Voucher
2. Voucher with a Budget Status or Budget Misc STatus of Error
3. Voucher with a Match Exception.
So, the Period End Accruals Options > Document page has the following fields and values specified under Status Field:
APPR_STATUS = A
APPR_STATUS = P
BUDGET_HDR_STATUS = E
MATCH_STATUS_VCHR = E
When the Period End Accruals process runs, none of the Vouchers with the above criteria are being selected since the WHERE clause for Step AP_PEACCRL.MAIN.00000-3 is using an 'AND' criteria instead of an 'OR' criteria. The Steps wants the Voucher to meet all of the above criteria instead of any one of the criteria.
Below is the Step that is being executed:
-- 13:10:49.951 ..(AP_PEACCRL.MAIN.00000-3) (Do Select)
%SelectInit(BUSINESS_UNIT,BUSINESS_UNIT_GL,SETID,POST_OPTION, ACCOUNTING_DT,
APPL_JRNL_ID_PEACR, AP_KK_ACCRL_FLG, WHERE_CLAUSE1, WHERE_CLAUSE2) SELECT
A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.SETID , A.POST_OPTION ,cr
TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD') , A.APPL_JRNL_ID_PEACR ,
A.AP_KK_ACCRL_FLG , B.WHERE_CLAUSE1 , B.WHERE_CLAUSE2 FROM PS_PE_APBU_TMP4 A
, PS_PE_OPTION_TMP4 B WHERE A.PROCESS_INSTANCE = 153039 AND
A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.SETID = B.SETID
/
-- Buffers:
-- 1) US001
-- 2) US001
-- 3) SHARE
-- 4) Y
-- 5) 2018-05-31
-- 6) AP_PACCRUE
-- 7) N
-- 8) AND APPR_STATUS IN ('A','P') AND BUDGET_HDR_STATUS IN ('E') AND
MATCH_STATUS_VCHR IN ('E')
-- 9) AND BUDGET_MISC_STATUS = 'V' AND DOC_TOL_HDR_STATUS = 'V'
-- 13:10:49.970 Iteration 1 of ..(AP_PEACCRL.MAIN.00000-3) (Do Select) loop
Is this considered a Bug?
Solution
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
Goal |
Solution |
References |