Created By And Created Date For Activities Is Not Populating In Reports (Doc ID 2160683.1)

Last updated on APRIL 02, 2017

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Technology Management - BI & Reporting

ACTUAL BEHAVIOR
---------------
Created By and Created Date for Activities is not populating in reports

We have few reports created in BI for Activities. Activities were imported on Production environment and after import we observed that Created By field for these activities is populated as BULK_IMPORT and in the report we do not see any value.
Created Date is populated on UI but it is not visible in report.

Can you please check the issue for Created By and Created Date.

STEPS TO REPRODUCE
---------------

1. Imported activities through file import
2. Created analysis based on:

SELECT
0 s_0,
"Sales - CRM Sales Activity"."Activity"."Activity Name" s_1,
"Sales - CRM Sales Activity"."Activity"."Activity Type" s_2,
"Sales - CRM Sales Activity"."Activity"."Actual End Date" s_3,
"Sales - CRM Sales Activity"."Activity"."Created By" s_4,
"Sales - CRM Sales Activity"."Activity"."Creation Date" s_5,
"Sales - CRM Sales Activity"."Activity"."Description" s_6,
"Sales - CRM Sales Activity"."Activity"."Last Updated By" s_7,
"Sales - CRM Sales Activity"."Contact"."First Name" s_8,
"Sales - CRM Sales Activity"."Contact"."Last Name" s_9,
"Sales - CRM Sales Activity"."Customer Organization Extension"."Extension Attribute Character 020" s_10,
"Sales - CRM Sales Activity"."Customer"."Customer Unique Name" s_11,
"Sales - CRM Sales Activity"."Customer"."Organization Size" s_12
FROM "Sales - CRM Sales Activity"
WHERE
(DESCRIPTOR_IDOF("Sales - CRM Sales Activity"."Customer"."Organization Size") IN ('Dixie Chopper Dealer', 'Dixie Chopper End User', 'Dixie Chopper Prospect'))
ORDER BY 1, 5 ASC NULLS LAST, 12 ASC NULLS LAST, 11 ASC NULLS LAST, 17 ASC NULLS LAST, 16 ASC NULLS LAST, 2 ASC NULLS LAST, 7 ASC NULLS LAST, 6 ASC NULLS LAST, 4 ASC NULLS LAST, 8 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

3. Run report
4. Created By and Created Date shows blank. 

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