Forecast - Rest API Data - Duplicate Results in the Response (Doc ID 2298883.1)

Last updated on AUGUST 29, 2017

Applies to:

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

Goal

On : 11.1.11.1.0 version, Sales Forecasting

Forecast - Rest API Data

Case :


We need to copy our forecast data to local warehouse.(by web service).
We use with rest api to take Forecast.
Yesterday, we got 8 duplicate lines on forecast date. All two line were completely equal
I executed this url in rest: (POD).crm.em2.oraclecloud.com:443/salesApi/resources/11.1.11/territoryForecasts?totalResults=true&limit=200&offset=0&q=ForecastParticipantId=206028
and I got 2 record
Today - When I run the same query, i got just one record.

Why do duplicates have records? How to prevent it?

Attached:
1. PrintScreen of query in Rest.
2. territoryForecasts (1) - Respone.
 

Solution

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