EAP: Period End Accrual only selects Voucher that meet all Options Criteria

(Doc ID 2421948.1)

Last updated on JULY 11, 2018

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

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