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