My Oracle Support Banner

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.


On : 9 version Bundle 32, AR Update - Posting

When attempting to run ARUPDATE the following error occurs.

-- 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

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.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.