My Oracle Support Banner

Cannot Insert Opportunity Revenue Via WebService (Doc ID 2128801.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Fusion CX Sales Cloud Service - Version and later
Information in this document applies to any platform.


cannot insert Opportunity Revenue via web service

Webservice used: Process Opportunity - Operation Merge
JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-27120. Please contact service provider on details.
ORA-00904: "PRODUCTGROUPPEO"."PROD_GROUP_ID": invalid identifier

Request used:

<soapenv:Envelope xmlns:soapenv="">
<typ:processOpportunity xmlns:typ="">
<opp:OptyId xmlns:opp="">300000007659406</opp:OptyId>
<opp:ChildRevenue xmlns:opp="">
<rev:RevnAmount currencyCode="EUR" xmlns:rev="">170000</rev:RevnAmount>
<rev:ProdGroupId xmlns:rev="">300000001370114</rev:ProdGroupId>
<typ1:returnMode xmlns:typ1="">Key</typ1:returnMode>
<typ1:partialFailureAllowed xmlns:typ1="">false</typ1:partialFailureAllowed>



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

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