Fusion Applications OTBI - Using "SALES - CRM HISTORICAL PIPELINE" the resulting report data is not fixed / snapshotted as expected , it changes over time
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Fusion Application Toolkit Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Common CRM - Version 188.8.131.52.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
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