SYNERGEN.SDBP_SEND_ALERT fails: ORA-01400: cannot insert NULL into ("SYNERGEN"."SA_WORKFLOW_ITEM"."PRIMEKEY_PLANT") (Doc ID 1364054.1)

Last updated on JULY 26, 2013

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***

Goal

Upgraded to version 1.9.0.3.1. It was noticed recently that when calls to the procedure SYNERGEN.SDBP_SEND_ALERT are failing with the following message:
ORA-01400: cannot insert NULL into ("SYNERGEN"."SA_WORKFLOW_ITEM"."PRIMEKEY_PLANT") ORA-06512: at "SYNERGEN.SDBP_SEND_ALERT", line 239




Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms