My Oracle Support Banner

Rules Engine: 'Not Exists' Operator is Not Working Correctly (Doc ID 2297495.1)

Last updated on AUGUST 16, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.


On :  9 version, Frameworks

When using Cohort Tag 'Not Exists' in the criteria  it should not return any row with Cohort Tag with matching criteria, however it is returning a row.  When you check if that row has cohort tag, it has cohort tag. Even though the cohort tag exists the cohort tag' not exists' criteria is not working

The criteria to work correctly.

The issue can be reproduced at will with the following steps:
1.  In Rules Engine , define rule to use Cohort tag of "Not Exists" in an operator (Setup SACR -> Campus Community -> System Administration -> Rules Engine- Set Up-Build Rules)
2.  Use Emplid as criteria
3. Use Effective date as of max as criteria
4. Use Cohort Tag not exists as criteria
5. Use Academic Career as criteria
6. Set a student academic program stack for the latest effective dated row with a cohort tag exist
On Rules Engine
7. Use a for each academic program in rule
8. Use a write to log statement to write out the values in for each in the rule
9. Observe that a row with a cohort tag exists appears in rule

The issue has the following business impact:
Due to this issue, users does not have accurate information


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.