OBIa 11G: Procurement And Spend Purchase Orders. Balancing Segment (Requisition BU ID 0/Unspecified) (Doc ID 1633154.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

I am working on OBI Applications 11.1.1.7.1 Dashboards; the Source system is PeopleSoft FSCM 9.1. We are working on Procurement and Spend System Environment:

PeopleSoft FSCM 9.1
OBI Applications 11.1.1.7.1
OBIEE 11.1.1.7.0
Note: Everything is standard.  No customization has been performed yet.

Issues:

Subject Area: Procurement and Spend - Purchase Order
Dimensions: Balancing Segment Code

I have a simple analysis showing Requisition Business Unit, and several FACTS showing 2012 data.

Note that there are 6 Business Unit IDs, and the totals.

When I add the Balancing Segment Code to the Analysis, I suddenly get data for Requisition BU ID 0/Unspecified appearing:


Year    Requisition BU ID    Requisition Business Unit Name
2012    0                          Unspecified

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