3C Engine Assigns Same Comments Content to All Comment Categories in the Same Event ID

(Doc ID 2276439.1)

Last updated on OCTOBER 25, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


The 3C Engine process assigns the same COMMENTS content to all Comment Categories in the same Event ID. When there is a 3C Engine Event ID with multiple comment categories, the 3C engine gives each PERSON_COMMENT the same COMMENTS content, regardless of the DESCR254 in CMNT_CATG_TBL.

When there is a 3C Engine Event ID with multiple comment categories, the 3C engine gives each PERSON_COMMENT the correct COMMENTS content.

The issue can be reproduced at will with the following steps:

1. Go to Campus Community > Comments > Set Up Comments > Comment Category Table and set up a new comment category for the admin function of ADMP, using an effective date of 1/1/1901, set the description and the comment itself to "COMMENT TEST 1", and set the allow changes to Yes.
2. Go to Comment 3C Groups and assign the new comment category to the 3C groups of ADMP and UGAD.
3. Go to Query Manager and set up the query QA_CS_CC_PS_3CENGINE_ADMP to select just one EMPLID (e.g. ADMDUR107 - Academic Institution = PSUNV, Academic Career=UENG, Admit Term=0670).
4. Go to Campus Community > 3C Engine > Set Up 3C Engine > Event Definition and add a new event definition (with an effective date of 1/1/1901; set the description of "COMMENT TEST 1", Admin function to ADMP and select the Comment created above.)
5. Run the 3C engine with the parameters set to use pop selection, Institution of PSUNV, Admin Func of ADMP, Event definition created above, which should then populate the Comment area with the comment to get the comment assigned to the IDs.
6. Verify by going to the person comment entry page to see the comments. This is important - CHANGE the Comment date to yesterday's date, as this is one of the fields that does get picked up correctly.
7. Go to the comment category page in correct history mode and access the comment category created above.
8. Add a new effective-dated row and change both the description and the comment text to "COMMENT TEST 2" and save.
9. Go to the event definition for and add a new effective-dated row. Note that the NEW description for the comment category shows on the event definition.
10. Run the 3C engine as above. Note that the comment shows the new description in the run control page.
11. Go to the Person Comment entry page to see the comments now assigned to ID. All the comments that were run for this person have now been changed to the newer Comment description; however, users will be able to tell which are the new verses the old by looking at the comment date. Also note that the comment text for all rows is the old text.


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