My Oracle Support Banner

Error When Trying to Upload a Commerce Process [Error while trying to execute a sql statement UPDATE bm_cm_attribute SET company_id =... java.sql.SQLException: ORA-01407: cannot update ("XXXXXX"."XXXXXX"."XXXXXX") to NULL] (Doc ID 2494476.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 18 A Patch 1 and later
Information in this document applies to any platform.

Symptoms

When attempting to bulk upload a commerce process, the following error occurs.

Error while trying to execute a sql statement (XXXXXX) UPDATE XXXXXX SET XXXXXX = ? WHERE (XXXXXX = ? )
java.sql.SQLException: ORA-01407: cannot update ("XXXXXX"."XXXXXX"."XXXXXX") to NULL

Cause

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
Symptoms
Cause
Solution


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