JBO-25083 Error While Invoking Out Of Box FindOpportunity Operation For Opportunity Service (Doc ID 2217603.1)

Last updated on JANUARY 03, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, CX Integration

Error while invoking Out of box findOpportunity operation for Opportunity Service
WSDL URL--https://<host>/opptyMgmtOpportunities/OpportunityService?wsdl

Request:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:findOpportunity>
<typ:findCriteria>
<typ1:fetchStart>0</typ1:fetchStart>
<typ1:fetchSize>200</typ1:fetchSize>
<!--Optional:-->
<typ1:filter>
<!--Optional:-->
<typ1:conjunction>And</typ1:conjunction>
<!--1 or more repetitions:-->
<typ1:group>
<!--Optional:-->
<typ1:conjunction>And</typ1:conjunction>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<!--1 or more repetitions:-->
<typ1:item>
<typ1:conjunction>And</typ1:conjunction>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:attribute>LastUpdateDate</typ1:attribute>
<typ1:operator>AFTER</typ1:operator>
<typ1:value>2016-12-22T16:20:00-08:00</typ1:value>
</typ1:item>
</typ1:group>
<!--Zero or more repetitions:-->
</typ1:filter>
<!--Optional:-->
</typ:findCriteria>
</typ:findOpportunity>
</soapenv:Body>
</soapenv:Envelope>

ERROR
-----------------------
<tns:code>25180</tns:code>
<tns:message>JBO-25180: Exception in expression "OpportunityEO.CustomFormulaField": oracle.jbo.InvalidOperException</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:detail xsi:type="tns:ServiceErrorMessage">
<tns:code>25083</tns:code>
<tns:message>JBO-25083: Cannot create a secondary iterator on row set OpportunityEO_RevenueTerritory_OpportunityVOSumRevnToRevenueTerritoryVO_RevenueTerritoryVO_0 because the access mode is forward-only or range-paging</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.jbo.InvalidOperException</tns:exceptionClassName>
</tns:detail> 


Cause

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