How To Filter Out Customers from W_PARTY_D (Doc ID 1931801.1)

Last updated on JULY 01, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

On : 7.9.6.4 version, DataWarehouse

ACTUAL BEHAVIOR
---------------
When making new analysis in any subject Area that contains Customer Party information (e.g. Sales - Invoice Line) and selecting "Customer Party name" as example for the only column of the report, it will show all records from W_PARTY_D which will include records that are customers, Supplier or employee. This is not expected.

EXPECTED BEHAVIOR
-----------------------
They expect to see only Customers listed... not employee or Supplier.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Analytics make new analysis in any subject Area that contain Customer Party information (e.g. Sales - Invoice Line)
2. drag the "Customer Party name" over to the report
3. click Results tab
4. note that not just Customers but also suppliers and employee are listed

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot build a report of just customers

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