My Oracle Support Banner

OBIA 11g Product Hierarchy Names not showing in OOTB SA “Inventory-Transactions” report (Doc ID 1665768.1)

Last updated on FEBRUARY 24, 2019

Applies to:

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


Spend Category analytics are not returning the expected results when drilling down on the Purchasing Category displayed in an overview analytic.

  1. The user opens the Spend Analyzer:Overview page and sees the Spend by Top Categories analytic displaying.
  2. They select the Spend by Categories report and chooses View All by erasing the default group.
  3. The Spend By Category report displays with the Top Level Category Name displaying (Segment1).
  4. They drill-down on the Top Level Category Name and see an unexpected result:

 the specified criteria did not result in any data.

The expected result is a display of the Minor categories spend details related to the selected Top Level category.
After doing analysis of the unexpected resulting report, it was determined that the dimension column "Purchasing Category"."Purchasing Category Hierarchy 8 Name" has been selected.
This column contains only a single value: 'Not Applicable'.




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.