My Oracle Support Banner

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 OCTOBER 21, 2020

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


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.