EAR9.2: Condition Monitor Process Abended at Step AR_CNDMON.CHK_COLL.INS_PRCS When Customer Has More Than 1 COLL Customer Group. (Doc ID 1933322.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of Issue
-----------------------------------
Condition monitor process ABENDED at Step AR_CNDMON.CHK_COLL.INS_PRCS (Action SQL) -- RC = 805 when customer has more than 1 COLL customer group.

What is Working
------------------------------
The abend does not happen when customer only has 1 COLL customer group.

Error Message
-----------
-- Row(s) affected: 0
-- 14.53.51 Process 1765015 ABENDED at Step AR_CNDMON.CHK_COLL.INS_PRCS (Action SQL) -- RC = 805
ROLLBACK
/
-- 14.53.51 SQL Error: ORA-00001: unique constraint (SYSADM.PS_AR_CM_PRC_TAO7) violated

Steps to Replicate
----------------------------

  1. Setup customer to have more than 1 COLL customer group.
  2. Create Collection rule for each customer group.
  3. Both rules have the same details.
  4. Post an item and run condition monitor.

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