My Oracle Support Banner

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 APRIL 08, 2019

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.