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

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

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



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