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 188.8.131.52.0 and later
Oracle Fusion Common CRM - Version 184.108.40.206.0 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.
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.
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