Anyone ever see this error when updating revenue p...
# arm
h
Anyone ever see this error when updating revenue plans, "ORA-02291: integrity constraint (NLCOMPANY.ALLPLANNEDREVENUEDEFACCT) violated - parent key not found BAD SQL STATEMENT:INSERT INTO plannedrevenue ( nkey, krevenueplan, kplannedperiod, kplannedrevenuetype, mamount, kdeferralaccount, krecognitionaccount, rfxrate, bisrecognized ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) Bind Variable #1: 902 (java.lang.Integer) Bind Variable #2: 902 (java.lang.String) Bind Variable #3: 22 (java.lang.String) Bind Variable #4: REV_REC (java.lang.String) Bind Variable #5: 71998.00 (java.lang.String) Bind Variable #6: 0 (java.lang.String) Bind Variable #7: 1637 (java.lang.String) Bind Variable #8: 1 (java.lang.String) Bind Variable #9: F (java.lang.String)"? Feels like I may have just missed a step in the configuration but I'm not sure where to even begin troubleshooting that message.
a
Thats an error from the underlying Oracle DB and is bad error handling by NetSuite. It’s complaining about a constraint violation but that’s not something you have control over. I think You’ll need to open a case with them