Fusion Applications OTBI - Using "SALES - CRM HISTORICAL PIPELINE" the resulting report data is not fixed / snapshotted as expected , it changes over time

(Doc ID 1945980.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version and later
Oracle Fusion Common CRM - Version and later
Information in this document applies to any platform.


Fusion CRM Cloud OTBI

SA:  Sales - CRM Historical Pipeline

When building historical analyses using snapshot Dim tables, the data is still moving over the time.

Unexpected Behavior

Snapshot data is designed to be fixed at a point in time,but ther data is not fixed.
when a month is over,  in a case of a monthly report, the data for this month should not moved anymore whatever if there area changes for the concerned records.

Later input:

1. Ess Jobs for populating the snapshot tables have been executed
2. Per new documentation of this Subject Area: Pipeline Snapshot Date, Historical Opportunity, Historical Revenue have been used , which is correct


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