My Oracle Support Banner

Issue While Creating Analysis For Account Hierarchy And Custom Object AccountProduct (Doc ID 2432188.1)

Last updated on DECEMBER 22, 2020

Applies to:

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

Goal

On : 11.13.18.02.0 version, Analytics

We have 3 levels of accounts.

SUBACCOUNT
CID
BUID

We are doing Customer hierarchy loads to load the parent child relationships.

We have Product associated at BUID level. Products are associated only to lowest level of accounts.

We are trying to build a report with the below fields.

SUBACCOUNT Name
CID Name
BUID Name
Product Name (product associated at BUID level)

We built an analysis using Siebel - CRM Customers subject area, and able to show the hierarchy of accounts. to get the product detail from AccountProduct custom object, since the subject area is not available, we tried creating custom subject area, with Account as parent ,and AccountProduct as child object.

 

Solution

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
Goal
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.