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. (Doc ID 2109501.1)

Last updated on FEBRUARY 23, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, AR Update - Posting

When attempting to run ARUPDATE, AR_UPDATE2 ends in "No Success".


ERROR
-----------------------
-- 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
ROLLBACK
/
-- 14:10:03.826 SQL Error: ORA-01427: single-row subquery returns more than one row

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Bill is originated from project costing.Billing does budget check but AR accounting lines has budget date as blank.
  2. Set AR budget date override = Y.
  3. Created a deposit in AR.
  4. In deposit, Item Reference of this invoice is provided
  5. Create and build the Payment Worksheet for deposit created
  6. Set worksheet to Batch Standard
  7. Run ARUPDATE


BUSINESS IMPACT
-----------------------
Cannot post the deposit.

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