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 laterInformation 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 |