EAR9.1+: ARUPDATE Fails at Step AR_PGG_SERV.BDT_UPD.UPD_BD When Payment Is an Item That Has Multiple Items on Same Line With Same ID (Doc ID 2065786.1)

Last updated on NOVEMBER 23, 2015

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Maintenance Worksheet

ARUPDATE fails if the payment is on an item that has multiple items on same line with same ID


ERROR
-----------------------
Process 98403 ABENDED at Step AR_PGG_SERV.BDT_UPD.UPD_BD(SQL) -- RC=1427 (108, 524)


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

  1. Enter item (INV1) and Post.
  2. Enter credit item (INV1) and Post.
  3. Unpost credit item (INV1) from step 2.
  4. Enter credit invoice (INV1) with item_line 1 and Post.
  5. Create Maintenance WS and offset the two open items INV1 (from step 2 and step 4) and Post.
  6. Results: ARUPDATE abends at Step AR_PGG_SERV.BDT_UPD.UPD_BD(SQL)


BUSINESS IMPACT
-----------------------
Due to this issue, users are frequently facing ARUPDATE failures

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