Fusion CRM OTBI - Sales – CRM Historical Pipeline Displays No Value / blank /null For Sales Stage Start Date - For Imported Opportunities (Doc ID 1606851.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Fusion CRM

Historical Pipeline Snapshot is launched every day since 16/11/2013 and we are able to see records in the subject area: Sales – CRM Historical Pipeline

However, for some of opportunities

Sales Stage Start Date

does not have a value.

This corresponds to open and close opportunities we had IMPORTED into Steria staging sales cloud env.

Sales Stage Start Date is only filled in for opportunities we have entered directly in the system via the UI Form.

Also noted that that if we cross this

Subject Area “Sales – CRM Historical Pipeline” with the
Subject Area “Sales – CRM Opportunities Sales Stage Snapshot”,

then only the opportunities with a value in Sales Stage Start Date are displayed.

How could we fill this field? It is not possible via imports or via UI.

Cause

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