EAR8.9+: AR_UPDATE2 Abended At Step AR_REV_EST.ITEM_AMT.ITEMAMT For Maintenance Worksheet

(Doc ID 1102569.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
*** Checked for Relevance Thu 12-Jan-2011 ***
*** Checked for Relevance Fri 26-Sep-2014 ***


On : 8.9, 9.0 and 9.1 version, AR Update - Posting

When attempting to post a maintenance worksheet (offset item to adjust remaining overpayment) the following error occurs.

-- 02.16.07 Process 6303 ABENDED at Step AR_REV_EST.ITEM_AMT.ITEMAMT (Action SQL) -- RC = 1407
-- 02.16.08 SQL Error: ORA-01407: cannot update ("EMDBO"."PS_RE_ACT_TAO5"."ITEM_AMT") to NULL

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

  1. Create and post 2 items, 1 item for customer USA10 (amount 1000) and 1 item for customer USA11 (amount 400).
  2. Create and post a payment (amount 1400) for customer USA10. Fully pay item (amount 1000) and create an adjust remaining overpayment (amount -400).
  3. Transfer adjust remaining overpayment from customer USA10 to customer USA11 and post it.
  4. Offset item in a maintenance worksheet for customer USA11 (amount 400) to adjust remaining overpayment (amount -400) for the same customer.
  5. Run ARUPDATE and AR_UPDATE2 will abend at Step AR_REV_EST.ITEM_AMT.ITEMAMT.



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