My Oracle Support Banner

Parts Integration Fails When CRM is Parts Master (Doc ID 2450156.1)

Last updated on FEBRUARY 02, 2023

Applies to:

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

Symptoms

When attempting to import parts from a CRM such as Salesforce (SFDC) or Oracle Sales Cloud (OSC), the following error occurs:

17 Sep 2018 20:02:43,030 [ERROR] com.bm.xchange.services.GeneralDBService.processSqlError(GeneralDBService.java:248) - Error while trying to execute a sql statement (0cae2169-7708-4996-b924-757163d4c4d0) INSERT INTO BM_PART_PRICING_INTEGRATION SELECT BM_PART_PRICING.ID, BM_PART.PART_NUMBER, BM_PART_PRICING.PRICE_PROFILE_ID, BM_PART_PRICING.DATE_ADDED, BM_PART_PRICING.DATE_MODIFIED FROM BM_PART JOIN BM_PART_PRICING ON BM_PART.ID=BM_PART_PRICING.PART_ID
java.sql.SQLSyntaxErrorException: ORA-00904: "BM_PART_PRICING"."PART_ID": invalid identifier

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
References


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