Cannot Insert Opportunity Revenue Via WebService (Doc ID 2128801.1)

Last updated on OCTOBER 06, 2023

Applies to:

Symptoms

cannot insert Opportunity Revenue via web service

Webservice used: Process Opportunity - Operation Merge
Error:
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="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header></soapenv:Header>
<soapenv:Body>
<typ:processOpportunity xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/">
<typ:changeOperation>Merge</typ:changeOperation>
<typ:opportunity>
<opp:OptyId xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/">300000007659406</opp:OptyId>
<opp:ChildRevenue xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/">
<rev:RevnAmount currencyCode="EUR" xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/">170000</rev:RevnAmount>
<rev:ProdGroupId xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/">300000001370114</rev:ProdGroupId>
</opp:ChildRevenue>
</typ:opportunity>
<typ:processControl>
<typ1:returnMode xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">Key</typ1:returnMode>
<typ1:partialFailureAllowed xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">false</typ1:partialFailureAllowed>
</typ:processControl>
</typ:processOpportunity>
</soapenv:Body>
</soapenv:Envelope>

Cause

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