My Oracle Support Banner

BI Report That Links Product Group Hierarchy In Sales With Product Line Attribute In Commissions (Doc ID 2408110.1)

Last updated on JUNE 06, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Analytics

BI report that links product group hierarchy in sales with product line attribute in commissions

Customer will like a report for commissions i.e. commission by product line (attribute 27) and by tower but we do not have the tower hierarchy in commissions. Customer need help to create this link between sales and commission.

ERROR
-----------------------
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,,,,,,,,,,,,,,,Period,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Sales Catalog Level 8,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Details,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Participant Source Transaction Details.Source Transaction Number],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)

State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Business Unit.Business Unit Key, Dim - Business Unit.Business Unit Name, Dim - Item.Sales Catalog Hierarchy 8, Dim - Item.Sales Catalog Hierarchy 8 Name, Dim - Participant Source Transaction Details.Source Transaction Number, Dim - Participant Transaction Details.CN_TP_BASETRANS_DFF_OPTY_ID_, Dim - Participant Transaction Details.CN_TP_BASETRANS_DFF_OPTY_NAME_, Dim - Participant Transaction Details.CN_TP_BASETRANS_DFF_PRODUCTLINE_, Dim - Participant Transaction Details.CN_TP_BASETRANS_DFF_PRODUCTNAME_, Dim - Participant Transaction Details.Transaction Id, Dim - Period Calendar.Period ID, Dim - Period Calendar.Period Name, Dim - Period Calendar.Period Number (HY000)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create report in BI with cross subject areas "Incentive Compensation - Transactions Real Time", "Incentive Compensation - Earnings Real Time" and "Sales - CRM Opportunities and Products Real Time"
2. It fails to create report as per requirement


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, user cannot create desired report

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.