EAR 9.1+ Abend AR_CNDMON.CHK_USER.INSPRCSSQL Command Not Properly Ended When Using Assessment Rule User Using ' ' (Doc ID 1906832.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

ENVIRONMENT
-------------------------
9.1 Bundle 23

Statement of Issue
-----------------------------------
EAR 9.1 Abend AR_CNDMON.CHK_USER.INSPRCSSQL command not properly ended when using Assessment Rule User Using ' '

Business Impact
---------------------------------------
Unable to create a rule user with a blank condition

Error Message
-----------
-- 22.57.34 Process 14209 ABENDED at Step AR_CNDMON.CHK_USER.INSPRCS (Action SQL) -- RC = 933
ROLLBACK
/
-- 22.57.34 SQL Error: ORA-00933: SQL command not properly ended

Steps to Replicate
----------------------------
1. Create Assessment Rule User where one field searches for ' '.
2. The action template consists of 3 actions
3. 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