My Oracle Support Banner

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

Last updated on JANUARY 24, 2023

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.