Issue/Symptom/Question

Our user is trying to forecast a job and after attempting to load the costcodes, we receive the below internal system error:

User: PENTA Installer
Date: 6/9/2022
Time: 17:03:28
Port: Port
Program: u_commandButton
Function: clicked
SQL Error Number: 2291
SQL Error Text: ORA-02291: integrity constraint (PENTA.FORECAST_WORK_RK01) violated - parent key not found
ORA-06512: at "PENTA.PK_W_FORECASTENTRYLOAD", line 1977
ORA-06512: at "PENTA.PK_W_FORECASTENTRYLOAD", line 155
ORA-06512: at line 1
System Error Text: Window: w_pentaMaint
u_commandButton ( clicked, Call p_pk_w_forecastEntryLoad_loadCostcodes )
SQL Code: -1

Applies To

Penta for Windows

Project Management > Forecast & Completion Information > Forecast Entry

Project Management > Jobs > Job Information > Other > Reporting tab

Resolution/Fix/Answer

Job was set up with a Forecasting > Calculate Contingency Forecast > Cost Type and Cost Code that was not set up for the job.