Rules Engine Errors Out When Updating a Rating Value with SaveEntity Function for Application Evaluation (Doc ID 2820548.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Symptoms

After configuring and setting up Rules Engine for Application Evaluation to update a rating value with the SaveEntity function, an 'invalid value' error occurs.

Error Message:

DEBUG: Returns - Success:False, Error Text:Admission Application Eval -
RATING_SCHEME_2(ADM_APPL_EVAL.RATING_SCHEME_2)   Invalid value - Check and try again;

Debug Log Error:

2021-10-07-08.49.51.257000 INFO: Starting Query -   (EMPLID = 'NUI000xx' OR 'NUI000xx' IS NULL) AND (ACAD_CAREER = 'UGRD' OR 'UGRD' IS NULL) AND (STDNT_CAR_NBR = 0 OR '0' IS NULL) AND (ADM_APPL_NBR = '00024xxx' OR
'00024xxx' IS NULL) AND (APPL_PROG_NBR = 0 OR '0' IS NULL) AND (EVALUATION_CODE = 'UGAPPLFYR' OR 'UGAPPLFYR' IS NULL) AND (APPL_EVAL_NBR = 1OR '1' IS NULL) AND (RATING_SCHEME = 'UGCOMMFYR' OR 'UGCOMMFYR' IS NULL) AND (RATING_SCHEME_2 = 'UGAPPLFYR' OR 'UGAPPLFYR' IS NULL)
2021-10-07-08.49.51.395000 INFO: Query Result Count - 1
2021-10-07-08.49.51.395000 INFO: Starting - Basic Test 3A -  update rating
2021-10-07-08.49.51.415000 DEBUG: 1 - FOR EACH Admission Application Compnent (EMPLID{NUI000xx}, ACAD_CAREER{UGRD}, STDNT_CAR_NBR{0}, ADM_APPL_NBR{00024xxx}, APPL_PROG_NBR{0}, EVALUATION_CODE{UGAPPLFYR},
APPL_EVAL_NBR{1}, RATING_CMP{1OVER})
2021-10-07-08.49.51.415000 DEBUG: 2 - IF Admission ApplicationCompnent.Rating Component = RATING_CMP
2021-10-07-08.49.51.415000 DEBUG: 3 - ASSIGN Admission ApplicationCompnent.Rating Value = RATING_CMP_VALUE
2021-10-07-08.49.51.415000 DEBUG: 4 - ASSIGN Admission ApplicationEval.Comment = Created by Rules Engine
2021-10-07-08.49.51.415000 DEBUG: 5 - CALL Function SaveEntity returning Success as SaveSuccess, Error Text as SaveError
2021-10-07-08.49.51.436000 DEBUG: Args -
2021-10-07-08.49.51.845000 DEBUG: Returns - Success:False, ErrorText:Admission Application Eval - RATING_SCHEME_2(ADM_APPL_EVAL.RATING_SCHEME_2)   Invalid value - Check and try again;
2021-10-07-08.49.51.846000 DEBUG: End - 1 - FOR EACH Admission Application Compnent
2021-10-07-08.49.51.856000 DEBUG: Variable Map Start
2021-10-07-08.49.51.856000 DEBUG: EMPLID : NUI000xx
2021-10-07-08.49.51.856000 DEBUG: ACAD_CAREER : UGRD
2021-10-07-08.49.51.856000 DEBUG: STDNT_CAR_NBR : 0
2021-10-07-08.49.51.856000 DEBUG: ADM_APPL_NBR : 00024xxx
2021-10-07-08.49.51.857000 DEBUG: APPL_PROG_NBR : 0
2021-10-07-08.49.51.858000 DEBUG: EVALUATION_CODE : UGAPPLFYR
2021-10-07-08.49.51.858000 DEBUG: APPL_EVAL_NBR : 1
2021-10-07-08.49.51.858000 DEBUG: RATING_CMP : 1OVER
2021-10-07-08.49.51.858000 DEBUG: RATING_CMP_VALUE : 0
2021-10-07-08.49.51.858000 DEBUG: SaveSuccess : False
2021-10-07-08.49.51.858000 DEBUG: SaveError : Admission Application Eval - RATING_SCHEME_2(ADM_APPL_EVAL.RATING_SCHEME_2)   Invalid value - Check and try again;
2021-10-07-08.49.51.858000 DEBUG: Variable Map End
2021-10-07-08.49.51.858000 INFO: End - Basic Test 3A -  update rating

Steps to Reproduce the issue:

1. Login as PS
2. Create the following Entities:
   - Admission Application Component
   - Admission Application Eval
3. Create Entity Profile named Admission Rules
4. Navigate to: Main Menu > Set Up SACR > System Administration > Entity > Entity Property Sync
5. Click Sync all Entity Properties (refresh till complete)
6. Click Wipe Entity Cache
7. Create rule category under Main Menu > Set Up SACR > System Administration > Rules Engine > Setup > Define Categories
8. Go to Security Tab and add a Role e.g. "CS - Rules Administrator" and save
9. Setup an existing application for Application Evaluation or create a new application
10. Navigate to: Student Admissions > Application Evaluation > Application Evaluation
    For application # 00024xxx (PSUNV, UGRD, Emplid: NUI000xx)
11. Go to the Overall Rating tab and fill up the Rating Component section as shown in the screenshot
12. Go to Rule Setup Menu > Set Up SACR > System Administration > Rules Engine > Rules Engine Manager
13. Select Add a New Rule and hit Next
14. Fill in the details needed as shown in the screenshot
15. Go back to Application Evaluation and add Rating Value to the Rating Component lines
16. Go back to Rules Engine Manager and build the rule.
17. Test Rule by filling in the fields as shown in the screenshot
18. Click Execute Test button
    
    

Cause

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