EAR9.2: AR Auto Maintenance Process AR_AUTOMNT Is Failing At AR_AUTOMNT.WKSHEETS.WS_FLAG (Doc ID 2093812.1)

Last updated on JANUARY 13, 2016

Applies to:

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

Symptoms

On : 9.2 version, Automatic Maintenance

When attempting to run auto maintenance for the method with multiple steps it is failing with the following error.

ERROR
-----------------------
ABENDED at Step AR_AUTOMNT.WKSHEETS.WS_FLAG (Action SQL) -- RC = 1407
ROLLBACK
/
-- 10:47:30.275 SQL Error: ORA-01407: cannot update ("SYSADM"."PS_MT_ITEM_TAO4"."WORKSHEET_FLG") to NULL



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

  1. Create maintenance method with step as item balance matches with credit item balance, step2 is collector is equal to credit item collector, step 3 as execute algorithm #OLDEST.
  2. Enters debit and credit items.
  3. Post the items and run auto maintenance.

BUSINESS IMPACT
-----------------------
Cannot do auto maintenance.

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