This error commonly occurs when the Ask Amount rules used on the Source for the Segments are not configured correctly. If they are missing an Activity Type and/or Base Table, then that would cause the error. Correct the Ask Amount rules, or change the Ask Amount rule on the Source to another one that is setup correctly, then run the Appeal again.
The Segment Criteria was missing for a specific segment (in this case, "REM: All Other", which was SEGMENT_SEQ = 24 in the APPEAL_SEGMENTS table). You can see this in the front-end, in Appeal Segmentation Entry, in the Segments tab, clicking on each Segment until you find one without any criteria (at the bottom of the dialog box):
And in the back-end:
FROM APPEAL_SEGMENTS AS1, APPEAL_SEGMENTS_CRITERIA ASC1
WHERE UPPER(AS1.APPEAL_NAME) = UPPER( '[Appeal Name]' ) -- Take the Appeal name from the log
AND AS1.SEGMENT_SEQ = 24 -- Take this from the error (ORA-20999: Procedure error: Criteria not valid, segment sequence: 24;)
AND AS1.APPEAL_NAME = ASC1.APPEAL_NAME
AND AS1.SEGMENT_SEQ = ASC1.SEGMENT_SEQ
ORDER BY AS1.APPEAL_NAME, AS1.SEGMENT_SEQ;
To fix, add a proper criteria (i.e. Account_ID Is Not Null).