EAR 9.2: ARUPDATE Fails In ARUPDATE2 At Step AR_REV_EST.MASSAGE.BUDGETD3 When Invoice Data Is From Project Costing With Budget Check Is Done In Billing.
Last updated on SEPTEMBER 01, 2017
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, AR Update - Posting
When attempting to run ARUPDATE, AR_UPDATE2 ends in "No Success".
-- 14:10:03.738 .....(AR_REV_EST.MASSAGE.BUDGETD3) (SQL)
UPDATE PS_RE_TRANS_TAO21 SET BUDGET_DT = ( SELECT X.ACCOUNTING_DT_BI FROM
PS_RE_BI_DST_TAO21 X , PS_RE_TRANS_TAO21 WHERE
PS_RE_TRANS_TAO21.BUSINESS_UNIT = X.BUSINESS_UNIT AND
PS_RE_TRANS_TAO21.CUST_ID = X.CUST_ID AND PS_RE_TRANS_TAO21.ITEM = X.ITEM AND
PS_RE_TRANS_TAO21.ITEM_LINE = X.ITEM_LINE AND
PS_RE_TRANS_TAO21.PROCESS_INSTANCE = X.PROCESS_INSTANCE AND
PS_RE_TRANS_TAO21.AR_SEQ_NUM = X.AR_SEQ_NUM AND PS_RE_TRANS_TAO21.DST_SEQ_NUM
= X.DST_SEQ_NUM) WHERE PROCESS_INSTANCE = 5279 AND SYNC_BUDGET_DT = 'Y' AND
REV_SOURCE = 'B' AND BUDGET_DT IS NULL AND 'N' = ( SELECT BUDGET_DT_OVER_FLG
FROM PS_BUS_UNIT_OPT_AR B WHERE B.SETID = ( SELECT SETID FROM
PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = PS_RE_TRANS_TAO21.BUSINESS_UNIT AND
RECNAME = 'BUS_UNIT_OPT_AR'))
-- Row(s) affected: 0
-- 14:10:03.817 Process 5279 ABENDED at Step AR_REV_EST.MASSAGE.BUDGETD3 (Action SQL) -- RC = 1427
-- 14:10:03.826 SQL Error: ORA-01427: single-row subquery returns more than one row
The issue can be reproduced at will with the following steps:
- Bill is originated from project costing.Billing does budget check but AR accounting lines has budget date as blank.
- Set AR budget date override = Y.
- Created a deposit in AR.
- In deposit, Item Reference of this invoice is provided
- Create and build the Payment Worksheet for deposit created
- Set worksheet to Batch Standard
- Run ARUPDATE
Cannot post the deposit.
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