Goal Cascade Within ePerformance document Causing Buffer Error

Last updated on MARCH 09, 2017

Applies to:

Symptoms

Some managers pass goals down to their direct reports through Manager Self Service. And some managers choose to copy goals among their employees using the "Copy to other documents" button.
However, once goals have been cascaded to more than two levels, then copied amongst peers (by the manager through manager self service), the following buffer error shows.

When free-form items are copied, the sequence numbers will be set to the same as the originating document unless that seq-num is already being used (for a FF item). In that case the seq-num will be incremented to the next available seq-num according to the already existing free-form items in that section of the document.
The seq-num for the sub items will always be the same as the seq-num of the Items they belong to.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create docs for at least 4 employees and one for the manager
2.All docs using same Template with the same period-begin-end dates
3.sub items enabled for a section
4.all copy items options enabled
5 Add 3 free-form items to Cynthia's document
Add 2 sub-items to FF item seq #3

Error in PeopleCode ScrollSelect processing. (2,213) EP_APPR_BASE.GBL.PostBuild PCPC:3939 Statement:76
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.

Cause