Error During Parts Sync [Fatal database error]

(Doc ID 1958012.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 11.0 and later
Information in this document applies to any platform.


When performing a parts sync, a number of parts are not synchronized due to the following error in the log for the parts sync:

Exception occurred while merging target table:bm_part_temp to source table:bm_part Fatal database error: Exception while executing the query: MERGE INTO bm_part s USING bm_part_temp

The error message then continues to show each field that is not matched.


Various administration processes to the parts database in the CRM environment.


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