EAR9.0+: ARUPDATE Abends at Step AR_PGG_SERV.MNTCNTL.MWC_MLB with Unique Constraint When Posting Maintenance Worksheets with OnAccount Offsets (Doc ID 1477032.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

On : 9 version Bundle 32, AR Update - Posting

When attempting to run ARUPDATE the following error occurs.

ERROR
-----------------------
-- 05.40.59 .........(AR_PGG_SERV.MNTCNTL.MWC_MLB) (SQL)
-- Row(s) affected: 0
-- 05.41.01 Process 852481 ABENDED at Step AR_PGG_SERV.MNTCNTL.MWC_MLB (Action SQL) -- RC = 805
ROLLBACK


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

  1. Create online item for CAN01 BU, with two AR accounts and one User Account and with Department and Project chartfield values.
  2. Create online item for US001 BU, with single AR account.
  3. Create and post on account payment for above items.
  4. Create maintenance worksheets to offset OA and items.
  5. Post both BUs in one run control.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process certain maintenance groups

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