OBIA 11g Incorrect Data In "Top 10 GPA By Degrees" Report

(Doc ID 2017755.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

The report "Top 10 GPA by Degrees" is displaying incorrect data.

For example in the W_SIA_ACADPLAN_SUMM_F table and W_SIA_ACADPLAN_SUMM_FS table you have a specific number of  records each for a specific scholar_id. Each record has a GPA equal a value. So the report would have a value of  GPA*Number of Records, however,  in the  source if you have  only one row for a scholar id in PS_ACAD_DEGR the output of he report should be 2863 just 1*GPA

Basically the GPA for any scholar_id should be one figure. It shouldn't be multiplied by the number of records that scholar has which is what is being done.

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