SAP Knowledge Base Article - Public

2256244 - Error: Set Bonus Calculation job fails with ORA-02291: integrity constraint (SFV4_STOCKPM5766.FK_PAY_ITEM_GOAL_MEASURE) - Variable Pay

Symptom

Job fails with a reason SQLException caught: ORA-02291: integrity constraint (SFV4_STOCKPM5766.FK_PAY_ITEM_GOAL_MEASURE.

Environment

SuccessFactors Variable Pay

Cause

1. One possible root cause is during running bonus payout calculation, some business goal records was deleted, and the exception happened.

2. It is due to some quartz server issue.

3. The root cause is data inconsistent issue. During bonus payout calculation, some business goal records are deleted or re-imported

Resolution

During Bonus calculation, Please ask customer not to update anything on the template.

Especially if they try to add or remove business goals, business weights etc, Set bonus calculation job will fail.  

Keywords

Set Bonus calculation ORA-02291 ITEM_GOAL_MEASURE , KBA , LOD-SF-VRP-SYS , System Performance , Problem

Product

SAP SuccessFactors HCM suite all versions