Deleted Accounts Showing on Report Based on Custom Subject Area (Doc ID 2162315.1)

Last updated on MARCH 08, 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, Analytics

ACTUAL BEHAVIOR
---------------
Custom report is showing deleted Accounts that does not exists in OSC anymore


EXPECTED BEHAVIOR
-----------------------
Expected not to see them in Report as well

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a Custom Subject Area (CSA) based on Account object. Published CSA. 

2. Created a new analysis based on created CSA: 
2. SELECT
  0 s_0,
  "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"."Organization0"."ExtnAttributeChar007_Meaning" s_1,
  "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"."Organization0"."ExtnAttributeChar046_Meaning" s_2,
  "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"."Organization0"."ExtnAttributeChar047_Meaning" s_3,
  "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"."Organization0"."OrganizationName" s_4,
  "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"."Organization0"."UniqueNameSuffix" s_5
FROM "custExt42b55930_9f9e_44eb_b6a3_103bc75764c6"
WHERE
(("Organization0"."OrganizationName" LIKE 'ABO%') OR ("Organization0"."OrganizationName" LIKE 'SRI%'))
ORDER BY 1, 6 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

3. Results shows non existent Accounts in OSC
4. When using Sales - CRM Customer Overview, same rows does not show up. 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are seeing outdated data

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