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 DECEMBER 22, 2020

Applies to:

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


On : 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.

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)

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

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


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

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